Title
parsing and deleting the parsed items
Post
Hello, I have 11 Pro Advanced and am trying to parse the company name, address, city, state, zip, phone field which is the way I received it.
I know how to get the last numbers (the phone numbers) but don't know how to eliminate them from the field so that I can go to the zip, then address, etc.,
Any ideas.
Thanks for any help.
Bruce
The information is in one file? txt file? it may be comma delimited or tab delimited?
If Filemaker File Menu > Open does not recognize the file, then there is likely no delimiting characters.
Opening the file in Excel will also put each line into the first cell on each line.
If there is reliably two spaces between Address and City also two spaces between City and State, etc Word Replace would work.
If not this page gives a good parsing overview.
http://www.mightydata.com/blog/parsing-like-a-pro/
http://help.filemaker.com/app/answers/detail/a_id/3638/kw/separating%20first%20and%20last%20names
Extracting Title, First, Middle, and Last Name from a Single Field
Answer ID: 3638Last Updated: Feb 27, 2012