Good after noon. I have a large data set similar to the following:
Mr Smith Downtown storage 1234 any town USA.
Mr Smith Downtown park bench #234 any town USA.
Mr Smith Downtown park bench /5566 any town USA.
I need to extract everthing after the last character before the 1st number or . So I need:
1234 any town USA.
234 any town USA.
5566 any town USA.
Mr Smith Downtown storage 1234 any town USA.
Mr Smith Downtown park bench #234 any town USA.
Mr Smith Downtown park bench /5566 any town USA.
I need to extract everthing after the last character before the 1st number or . So I need:
1234 any town USA.
234 any town USA.
5566 any town USA.