how to use a pipe delimiter (|) in extract?
Need my extract to use a pipe delimiter (|) in extract. Any way this is possible?
using FileMaker Pro 9.0v3 on WinXPSP3.
Appreciate any feedback/help!
create a calculation field:
Substitute ( List ( Field1 ; Field2 ; ... FieldN ) ; ¶ ; "|" )
and export that field.
If some of those fields could be empty, but you need to see the pipe, use instead this calculation :
Field1 & "|" & Field2 & "|" & ... & "|" & FieldN
Please define "extract". Can you give an example of what you want to do here?
Thanks for the response!
I need to export some fields into a file. A pipe (|) must be used as the field delimiters.
I currently have a script that exports the file. A script step to use (|) as a delimiter would be optimal.
Does this provide clarity RE: "extract"?
Please let me know.
What type of file should i export the calculation field to? (e.g. tab, csv)
Retrieving data ...