My data will always look like this. I need to extract the address.
Example:
Home Address: 1900 TRANSIENT, PICO RIVERA , CA 00000
What I need is: 1900 TRANSIENT
Here is another example:
Home Address: 15521 EUCALYPTUS AV, BELLFLOWER , CA 00000
What I need is: 15521 EUCALYPTUS AV
Here is another example:
Home Address: 1210 N LA BREA, WEST HOLLYWOOD , CA 00000
What I need is: 1210 N LA BREA
Any help would be great.
Thanks
Paul
Bookmarks