Jump to content

Setting delimiter for export


Jack
 Share

This topic is 6588 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 6588 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.