Jump to content

parsing data into new fields during open with FMP


This topic is 6168 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I opened a huge txt data file with FMP and all the data is in a single field. There are about 50 pieces of data, each separated by a semi-colon. There are way too many records to open this in Excel, where I could use "convert to columns" to extract the data into separate fields. I know I could go through the laborious process of creating calculation fields in FMP that would extract the data, but this would take way too much effort. Is there a quick way to get FMP to recognize that data needs to be extracted during the opening process? The only option I see is whether or not the first record has field names. Thanks in advance for any help with this.

Link to comment
Share on other sites

You could try opening the text file in a text editor (e.g. TextWrangler), and do a Find/Replace (find semicolon, replace with t). Then you will have a tab-separated file, which Filemaker will import/convert.

This is assuming that it's only FIELDS that are separated by semicolons, while actual records are separated by carriage returns.

Link to comment
Share on other sites

This topic is 6168 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.