Importing with Special Delimiter Character

[CCBtx]

I need to import a flat text file that uses Ascii(158) as the delimiter.

...I also need to export a flat text file that uses Ascii(158) as the delimiter character.

The reason for this is that I am inserting filemaker in the middle of an existing process.

Can Filemaker perform these types of imports and exports?

Thanks

[comment]

Do you mean a FIELD delimiter? With records being delimited by carriage returns?

[CCBtx]

Yes. A field delimiter. The delimiter is Ascii Character 158.

I surmize that FM does not support this. What is the easiest way to import this and break it into FM table fields.

Here is an example:

žFULL NAMEžž1112345ž100.00ž12292005žžLASTNAMEžFIRSTNAMEž1žKSTžž25ž4ž466667777žSžž03086ž2700 SW 1ST #999žžAMARILLOžTXžUSAž79102ž8065551212žžžžžžžžž

(I think I have the export figured out)

Edited September 14, 2009 by Guest

[comment]

I would import the file into a temp table, use calculation fields to parse out the imported field, and import the result into the real table. I believe you will need a global text field to hold the delimiting character, since non-printing characters do not work in a calculation formula.