55
Hello guys,
I'm trying split a CSV-text into the array of separate lines. I have a Text array, where the CSV-text is stored, it looks like following:
"Header1, Header2, Header3
Value1, Value2, Value3
Value4, Value5, Value6"
In order to split the text I tried following constructions:
Text.Split('\n');
Text.Split('\\n');
Text.Split('\r\n');
Neither of the above mentioned versions work.
Maybe someone could advise what is the proper way to split text by new lines?
Ah, yeah...
I used the wrong type for the new line code
Here is working version:
procedure Parse(CSV: Text): List of [Text];
var
result: List of [Text];
CRLF: Char;
begin
CRLF := 10;
result := CSV.Split(CRLF);
Exit(result);
end;
Hi Alok!
Thank you for your reply!
I tried your advice, but it didn't work, maybe I did something wrong.
I used following file as an example - people.sc.fsu.edu/.../addresses.csv
...
Client.Get('people.sc.fsu.edu/.../addresses.csv', Response);
Response.Content.ReadAs(Body);
Exit(Utils.Parse(Body));
...
codeunit 50100 Utils
{
procedure Parse(CSV: Text): List of [Text];
var
result: List of [Text];
CRLF: Integer;
begin
CRLF := 13;
result := CSVText.Split(Format(CRLF));
Exit(result);
end;
}
Also I tried 10 instead of 13, but it didn't work either
Hi
Try below
CRLF[1] := 13; (if 13 not work than try 10)
Value1, Value2, Value3 + CRLF[1] + Value4, Value5, Value6
Regards,
Alok Kulshreshtha
Please Verify my answer if you find my post helpful.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
