Jump to content

Importing parts of a Ascii CSV file


Benjamin Foster
 Share

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

Recommended Posts

  • Newbies

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!

Link to comment
Share on other sites

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) wink.gif" border="0 . 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

Link to comment
Share on other sites

This topic is 7255 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
 Share

×
×
  • Create New...

Important Information

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