Setting delimiter for export

[Jack]

Hi everyone !

When e3xporting records, is there a way to set the field delimter as a pipe (|)

rather than as a comma etc ? Is there a way to set the record delimiter to a carriage return ?

Thanks for any help.

~ jack

[BobWeaver]

The record delimiter is already a carriage return, so you should be okay there. As for using a pipe for delimiting fields, you have a couple of options. The first is to use FM6's XML export facility.

If you are using FM5.5 or earlier, then you can create a single calculated export field. For example, suppose you want to export fields Text01, Text02, Text03, Date01, and Number01. You would create a calculated text field "ExportData" with the formula:

Text01 & "|" & Text02 & "|" & Text03 & "|" & Date01 & "|" & Number01

Then export this single field as tab delimited.

[Jack]

Ahah !

So easy when you know how to do it.

Thanks.

~ jack