thomsonr

Strip Alphabet Characters from field

Discussion created by thomsonr on Mar 27, 2012
Latest reply on Mar 27, 2012 by dkwiens
I've got a series of addresses in one field (P_LOCATION) similar to this:  27 WINSLOW ST

What I need to do divide the civic number and street address to separate fields, so I created P_Civic and P_Street and populated them with P_Location.  I was able to strip the numeric from P_Street successfully using a script I found but am having no luck with stripping the non-numeric characters from P_Civic.

This must be a common task, what would the best way be to do it?

Thanks

Outcomes