Exporting data into pipe-separated text file

[Brewster]

We want to export our FileMaker database into a pipe-separated text file to serve a purpose for an online database extraction system we propose to use on our website. Are there any export options that allow us to control how the database fields are saved in order to easily create a web-compatible format? The closest export option that seems to be available in the FileMaker application is *.csv files, but we require the pipe separator rather than the comma, and no quotes around the field items.

[andygaunt]

Hi -

Without going to a secondary program such as word to replace the comma's with Pipe characters you may want to look into a plugin such as Troi File (www.troi.com)

This allows you to write to a file one line at a time, and you should be able to specify your seperator.

Otherwise, maybe use a .mer file and then open that in word and do a find/replace on the comma for a pipe.

ps. This forum is for feedback on the forum itself as opposed to posting.

HTH

[bruceR]

You could Just create a calc field and export that single field in tab delimited format, example:

FirstName & "|" & LastName & "|" & Address

For somebody trying to do this on a Mac, you could do this and not have to create any new fields:

Go to layout Export

# a layout that holds the fields you want

Copy All Records

Perform applescript:

set AppleScript's text item delimiters to tab

set x to text items of (the clipboard)

set AppleScript's text item delimiters to "|"

set x to x as text

do shell script "echo " & quoted form of x & " > ~/desktop/webtext.txt"