1 of 1 people found this helpful
If your data is in one field, then perhaps substitute the commas with tabs (Chr (9):
Set Field [ YourField ; Substitute ( YourField ; “,” ; Chr (9) )
Exporting field content with the script step “Export Filed Content” ?
In FM Go, using the script step “Export Filed Content”, can only be saved with “.txt” extension. I can then use "Insert File" to a container, then "Export Field Content" to the TemporaryPath Folder or DocumentPath folder with appropriate path. Then "Import from URL" with appropriate path for OS X and iOS, and Windows to a text field. Then this field can be parse for csv data or what separator is being used.
From FM GO, If you export the file from the Export Field Content script step to a desktop to open with a spreadsheet, then you will have to open the exported file with a text editor, like TextWrangler (OS X), or NotPad ++ (Windows) and save formatted as Unicode (UTF-8). Because the Export Field Content saves files formatted as Unicode (UTF-16) Little Endian, and in this format the comma may not be properly interpreted by spreadsheets.
Need changing separator to Char(9) from "," when combining. After combined you can't substitute only "," used as separator, "," in data also will be substituted.
user19752, have read your comment several times, cant figure out what your are trying to say / do.
If the combined csv is
"I have comma in data, do you understand?","2nd field here"
Substitute "," to Char(9) makes it
"I have comma in data do you understand?" "2nd field here"
comma in data is now tab.
OK, I used a field for the SearchString, and a field for the ReplaceString, if you want to only change the comma in quotation marks, place “,” (quotation marks with comma inside) in the SearchString field. Then:
Set Field [ Table::YourField ; Substitute ( Table::YourField ; Table::SearchString ; Chr(9) ) ]
Or: Set Field [ Table::YourField ; Substitute ( Table::YourField ; Table::SearchString ; Table::ReplaceString ) ]
Note in OS X: hold down option key and press tab key, this will insert a tab in the ReplaceString field.
Results in replacing the comma in quotation marks only.