Hello,
CSV Input Stream allow to parse CSV files to input data into a Stream Loop for instance. By default, the separator is a comma (,). I use a non english version of Excel to edit a CSV file, and every CSV format write a semi-colon as separator (;):
A;0;0;2
A;10;30000;5
A;20;15;7
B;75;42;1
B;100;12;0
Using an expression, I am able to dynamically (at run-time) change the property SeparatorChar:
Locals.MyInputStream.AsCsvFileInputRecordStream.SeparatorChar = ";"
I think it could be more convenient to have a direct access to this parameter in the configuration pane, allowing also to check the content of the file before execution with Parse Record Prototype funtions.
Best regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.