JerrySalem Posted February 16, 2005 Share Posted February 16, 2005 I have a Text file that I need to parse into fields. I would like to do it all in FMP7 and not go into Excel. (Mainly for bragging rights, but also for ease of use). The file I get is output from a web form, of people that visit our web site. The file has many people in one file. each data element in on a seperate line (with an identifier), there are also many extranious lines, but the whole thing is fairly structured. What I would like to do is import the file into a table with a single field. Making each line of the text document a new record in the table. Then walk down the fields and process each field (record) as nessisary. Sort of like this; Create a new Record in the people table. Check the line for a field, add it to the new record Go to the next line, check for data, and populate the new record in people. Repeate till end of a 'Record' Go to next line and create a new record in the people table. etc..... OK, now my problem. When I try to import the file, my only choices are as a CVS. This is a problem, because the file contains commas for instance when someone puts in an address between the City and state. How do I import a file as a TAB file? TIA Jerry Link to comment Share on other sites More sharing options...
This topic is 6618 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
Already have an account? Sign in here.Sign In Now