Parse If contains a digit.

Question

I am trying to parse addresses out if it starts with a char rather than a digit with regex. If it does start with a char then i want it to put the chars in another column and everything after the digit left in the address column.

EX:

AddressJames May 4506 River Bind Road506 Wrong Way Lane

After Parse:

Address Other stuff4506 River Bind RoadJames May506 Wrong Way Lane

Per · Answer

@Qiu

But your RegEx is stronger than mine 🙂

philipmannering · Answer

Another solution is to use The Regex Tool set to Parse with expression,

(.*?) ?(\d.*)

Hope this helps.

Thanks,

Philip

Qiu · Answer

@Per 
You are typing fast.😁