Substituting NULL in the external text file

[NewFM85User]

Hi,

Is it possible to substitute the NULL values with space in the external .txt file from Filemaker.

I do not want to use the TROI file plug in or any plug in.

Is it possible just with filemaker ?

Thanks for your help in adavnce.

[Lee Smith]

I started to reply to your post while it was in the Relationship Topic, but someone moved to the Import Export Topic Area, where I believe it belonged also.

Assuming that the [color:blue] external .txt file, is a text file that you want to Import, what is the format of that text file. i.e. csv or tab delimited?

If it is a Tab Delimited File, then insert a Tab where you want the blank field, if it is a csv Delimited, then you need to insert a "," where you want the blank field.

If on the other hand, this isn't what you are wanting to do, then you need to clarify what the external .txt file is, and how you what to use it in FileMaker.

HTH

Lee

[NewFM85User]

Hi ,

Yes it is my post and thanks for the reply.

My text file .txt is tab delimited. MySQL exports data to this file and some of the values in the file are NULL. I need to import these records to filemaker. Import fails with this NULL values. So I am planning to open this .txt file and substitute all the NULLs with single space or nothing and then import the data.

Need help.

[Lee Smith]

I'm not sure how mySQL exports. However, usually an export will include a Tab for fields that are blank.

Do you have field name: that preceed the data, such as [color:blue]Name: and then tab and the data?

Can you attach a sample of the text file?

Lee