My CSV has multiple fields in a row empty, so it looks like, (data,,,,data,,,data) as an example. That first step you replace ,, with ,"", ! Should this work when there are multiple empty fields in a row like mine? I seem to be losing columns after the replace.
Quote encapsulated csvs are a pain if there are empty fields. I would suggest taking a look at the office script demo ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9J6ThPWGaG0.html
Nice one. But my problem is little different could you plz help me. I have the Array like this ["68642", "47", "68662", "-", "Status At Closure", "\"Closed"] where the last item "Status At Closure", "\"Closed" is single string, since there is a comma in it, a backslash is added to it automatically. The Graph API to inset to Excel might think it as 6 columns (excel table has 5 Columns) and I am getting error since there is a mismatch in Number of Columns.
Hello Damo, thanks for your sharing, if some column in CSV file with " " as below, I can't follow upper step, could you mind share some hits for me? Name, Salary, age Teodoro, "5,000", 30
Take a look at this method CSV to Excel Power Automate and Office Scripts Any File Encoding - Free | Fast | Easy ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9J6ThPWGaG0.html
thanks for your sharing again, unfortunately my company blocks Office scripts. I will try another way to solve my problem, thanks again for your support
Update: I removed 1 comma from the first replace expression. everything was split correctly, except for the "title" column which has double commas in it.