Skip to Content (Press Enter)
2022-01-20 10-34-24
Mónica Coelho
57Views
8Comments
[CSVUtil] Can FileIdDelimiter be semicolon (;)?
Question
Forge
csvutil
Service icon
CSVUtil (O11)
Forge asset by Wei Zhu

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

0
0
17 May 2021
Copy Link
2021-06-14 11-14-04
Douglas Tadeu Montemor

Hello Mónica Coelho 

Replace ";" per ",".

1
0
17 May 2021
Copy Link
2022-01-20 10-34-24
Mónica Coelho

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

1
0
17 May 2021
Copy Link
2021-06-14 11-14-04
Douglas Tadeu Montemor

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

0
0
17 May 2021
Copy Link
2021-06-14 11-14-04
Douglas Tadeu Montemor

Hello Mónica Coelho,

So, Did my answers help your needs?

best regards

1
0
24 May 2021
Copy Link
2022-01-20 10-34-24
Mónica Coelho

Yes, thank you for your help.

0
0
16 Nov 2023
Copy Link
2021-04-01 07-44-07
João Coelho

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

0
0
16 Nov 2023
Copy Link
2021-06-21 12-37-59
Wei Zhu

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

0
0
16 Nov 2023
Copy Link
2021-04-01 07-44-07
João Coelho
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.