1 Reply Latest reply on Oct 31, 2012 7:56 PM by davidanders

parsing and deleting the parsed items

BruceMeyers Oct 31, 2012 6:43 PM

Title

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

1. Re: parsing and deleting the parsed items

davidanders Oct 31, 2012 7:56 PM (in response to BruceMeyers)

     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
Like Show 0 Likes(0)

Actions