Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

sep= metadata handling on csv files

Answered
Michael T asked on January 4, 2021

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!
 

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster January 6, 2021

Hello,
 
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.
 
Regards,
Illia

Please login or Register to Submit Answer