48
Views
8
Comments
[CSVUtil] Can FileIdDelimiter be semicolon (;)?
Question
csvutil
Service icon
Forge component by Wei Zhu

My CSV is delimited by simicolon (;), when using "LoadCSV2RecordList" and choosing Chr(59), there is insuccess. 

2021-06-14 11-14-04
Douglas Tadeu Montemor

Hello Mónica Coelho 

Replace ";" per ",".

Thank you @Douglas Tadeu Montemor , the problem is that my cvs have decimal numbers delimited by ",".

2021-06-14 11-14-04
Douglas Tadeu Montemor

For decimal numbers in excel it must be ".".

2021-06-14 11-14-04
Douglas Tadeu Montemor

Hello Mónica Coelho,

So, Did my answers help your needs?

best regards

Yes, thank you for your help.

I'm having the same problem, did you managed to solve it?

Generally, You can use semicolon as delimiter 
if special character (semicolon, newline and double quotation) are escaped correctly. 

I guess there may be some characters not escaped correctly.
So could you please check the out parameter DebugInfo of LoadCSV2RecordList ?

If you still can not figure out the root cause.
Please provide your OML and CSV file.

Regards
Wei

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.