Breaking numeric and text in a field

[marvin67]

Hi there,

I am doing a lot a data cleansing, specifically addresses. Sometime I have database that addresses are written in a one column (i.e. PO Box 159 Queenstown). Is there a easy way to break the po box and suburb if they are separated by a single space.

Checking for the last numeric on the data is the one i am thinking off but do not know how to start.

I would really appreciate your help.

Kind regards
Marvin

 

[DCrake]

You can use the split function to copy the string into an array using a space as a delimiter. Then you can enumeratge through the array and post the different elements into their rewspective fields.

David