Hello, everybody,
I need to upload a CSV file. Texts are qualified by double quotation marks. Some columns may have an embedded comma (company name, product description, etc.).
I have tried StringUtils.LoadCSV2, and I don't find how to let you know about the qualified texts, and it breaks my columns, with every comma it finds.
I've also tried to do it with File.ReadList, and each row in the list contains the entire string including commas and quotation marks.
From here I have no idea how to make a correct Split.
The goal is to display this information in a TableView (w/multiple columns).
Can you guide me or tell me what is (the best) way to do this?
Thank you very much!
[EDIT] I found one column that cause a break, the content is: "MAIL BOXES "FAST POST", S.A. DE C.V." that contains quotes and comma.
I'm stuck in the problem.
I need to upload a CSV file. Texts are qualified by double quotation marks. Some columns may have an embedded comma (company name, product description, etc.).
I have tried StringUtils.LoadCSV2, and I don't find how to let you know about the qualified texts, and it breaks my columns, with every comma it finds.
I've also tried to do it with File.ReadList, and each row in the list contains the entire string including commas and quotation marks.
From here I have no idea how to make a correct Split.
The goal is to display this information in a TableView (w/multiple columns).
Can you guide me or tell me what is (the best) way to do this?
Thank you very much!
[EDIT] I found one column that cause a break, the content is: "MAIL BOXES "FAST POST", S.A. DE C.V." that contains quotes and comma.
I'm stuck in the problem.
Last edited: