Could someone please explain why this parsing loop repeats the second line in my file ?
My csv file looks like this:
Code: Select all
Nrpakbon;Cddeb;Naam klant;Naam2;Naam3;Straat+hnr;Postcode;Plaats;Naam land;aantal;eMail;PickId
485845;101920;Microsoft;Bill Gates;;Cash Cow street 12;1106 WK;Amsterdam;NL;1;[email protected];42955
<blank line>*
(the <blank line> part is actually a real blank line, not the text)
Code: Select all
if FileExist("testfile.csv")
{
FileDelete, testfile.csv
sleep, 2000
}
FileRead, MyFile, parceldata_RRUBINGH40047658.csv
IfInString, MyFile, 101920
{
Loop, Parse, MyFile, `n, `r
{
StringSplit, data, A_LoopField, `;
If (data1 = "")
continue
else
{
FileAppend, %data1%`;%data2%`;%data4%`;;%data5%`;%data6%`;%data7%`;%data8%`;%data9%`;%data10%`;%data11%`;%data12%, testfile.csv
If (data1 = "NrPakbon")
{
FileAppend, `n, testfile.csv
}
}
}
}
I end up with a file that looks like this:
Code: Select all
Nrpakbon;Cddeb;Naam klant;Naam2;Naam3;Straat+hnr;Postcode;Plaats;Naam land;aantal;eMail;PickId
485845;101920;Microsoft;Bill Gates;;Cash Cow street 12;1106 WK;Amsterdam;NL;1;[email protected];42955485845;101920;Microsoft;Bill Gates;;Cash Cow street 12;1106 WK;Amsterdam;NL;1;[email protected];42955