Importing parts of a Ascii CSV file

[Benjamin Foster]

For those of you you are regulars to this forum this is my thrid post on the topic.I am sorry about that but I am still trying to import a student roster into a filemaker data base. The file is an Ascii file with each piece of data seperated by a comma I am running a windows computer and I would like to be able to take one piece of information out of this file and place it in my data base. Is this possible? When I try to convert the file to a filemaker pro database only the first feild of the file is copyed. Do I need to set filemaker to import a comma seperated files? what sorts of things need to be done to my data base to prepare it for the file. Please help!

[LiveOak]

I think I responded to this one. Yes, it is possible to import a CSV file into FM. FM interprets the file as follows:

field1,field2,field3 <cr> <--- this is one record, the first

field1,field2,field3 <cr> <--- this is the second record

.

.

.

field1,field2,field3 <--- last record

A carriage return denotes a new record, a comma a new field. There are two ways to proceed. 1) you can drop the CSV file on top of FM and see what the automatic conversion yields or 2) you can create a FM file with the fields you need and use the "Import" command. The dialog displayed will allow you to match up fields and review records (you might want to RTFM, read the fine manual) . My guess is that your CSV file isn't quite what you need, but without seeing the file it's hard to know what is going wrong.

-bd