We are extracting data from a system and looking for the best field delimiter and text qualifier to use? Tried semi-colon and double quotes, but IOM doesn't seem to like semi-colons as a delimiter. Then a comma as the delimiter and double quotes, but IOM doesn't seem to like double quotes as the text qualifier (would include the double quotes in the data).
Of course comma and not text qualifier works, but then we run into issues when data contains a comma.
I tried searching, also couldn't find any user configuration options in regards to file formats within the program.