problem of importing record from file

[New_2_FM]

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

[Lee Smith]

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

[New_2_FM]

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, 2005 by Guest

[Lee Smith]

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

[Inky Phil]

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

Phil

[mr_vodka]

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

[Lee Smith]

I already asked that.

[Lee Smith]

I pointed that out already.

[Inky Phil]

Sorry Lee,

I was only trying to help

Regards

phil

[Lee Smith]

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

[New_2_FM]

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