sas, regex, numbers, substring, prxchange

[user112a2]

I need help with the below code. I do not see how this is extracting the number from this address line text. When it says \D/ / I thought this replaces the digits with a space. I know the second part here is taking the substring up to the first space in the address line text. But, then I do not see how this is extracting the numbers. I pulled up the data set and it looks like this does work. Please help me understand how this is working.

Removed

[Jagadishkatam · Accepted solution]

Here the \D represents anything but not a digit. Because of which it is suppressing the every other data except the digit.

[ChrisNZ]

Function compress() would be a lot faster for this simple change.