I try to import record from a text file into a field. It stores each line as one record. But it will always ignore the content after the first comma in every single line.

for example.

"Today is a good day, can we go out?"

The line will be imported as

"Today is a good day"

The content after the comma is ignored.

The previous version File Maker does not truncated the line at all. But File Maker version 7 does.

Any ideas?

Thank you.

Jackson

Hi Jackson, and Welcome to the Forum.

Check out the information regarding File Formats, either in the Manuel, or accessing the online help when FileMaker is open. It sounds like you have the wrong one choose for your file.

BTW, you select the file type in the Import Dialog Box. It Defaults to FileMaker File.

HTH

Lee

Lee,

Thanks for replying.

What I need to do is to read and parse a text file and auto import records into the table.

It works pretty well, except the content after comma did not get read at all. I just wonder if this is a bug for File Maker 7.

I checked out the file format. I think my text file is good to go.

What do you think?

Thank you.

Jackson

Edited October 6, 200520 yr by Guest

Not a bug that I'm aware of. Can you post a sample of the Import file, and or a clone of your FM file?

Lee

Could the import routine think that it is importing from a csv(comma seperated values) file?

Phil

On your import dailog box, make sure that it is being imported as a file type of .tab .txt

I already asked that.

I pointed that out already.

Sorry Lee,

I was only trying to help

Regards

phil

Not a problem Phil, I was merely pointing out that you, mr_vodka and myself had pointed to the same things, and if Jackson didn't find the answer there, then the next step would be to post samples of the files.

Lee

thank you all for helping out. At this time, I have my users replaced all the comma(,) with semicomma(: in the notepad. And then do the import in the FileMaker application. All the data get imported.

Basically I have this text data file contains predefined format of content. When I tried to do a "record import" the text file for parsing, somehow the FileMaker Pro must read the comma(,) as a delimiter, so all the content after the comma in the line get truncated.

Jackson