Search code examples
filemaker

Export data records from filemaker pro 16 with all strings quoted with ""

Is it possible to export data records from filemaker and have all strings be in a "" quote? With string I mean type = text. Numbers shouldn't change though.

Solution

  • There’s no option I'm aware of that provides this behavior when exporting.

    The fieldType() function may be helpful. https://fmhelp.filemaker.com/help/16/fmp/en/index.html#page/FMP_Help/fieldtype.html

    Or, just create a single calc field "row" with all of the fields you want included - with appending quotes around the text fields - and do a .tab export of "rows" instead. That's generally how I handle it.