is there an option in flexmonster to properly parse or take into account the sep= metadata at the top of CSVs?
e.g. in europe many files use , in place of the decimal in numbers.
so the CSV then uses ; as sep.
so many CSVs have sep=’,’ or sep=’;’ etc. on the first line. Is there any facility in flexmonster to read this directive, or at least ignore it if it’s the default sep=’,’
Thank you for contacting us.
Currently, Flexmonster does not support this type of metadata. CSV files with the “sep=” string on the first line will not be parsed correctly.
However, adding support for this notation sounds reasonable. We will include the feature in the minor update ETA Feb 8.
Our team will notify you as soon as the version with the feature is available to download.
Also, we want to draw your attention to the
fieldSeparator property of the Data Source Object. It can be used as a temporary workaround to define different fields separator to split CSV row.
Please contact us if other questions arise.