You’re offline. This is a read only version of the page.
Announcements
2
Hi All,
---First time posting here, so if I lack information or posted in a wrong location please let me know---
I'm working with a CSV file that is being emailed in to us from a vendor and I'm attempting to Parse this CSV file into our SQL server for use with Power Bi. I was able to successfully parse the CSV file, however in some of the files I found commas that are throwing off the parse process, and this is where I've been stuck. Where there is a cell with a comma in it I know the cell is wrapped with quotations (Ex. "this is, an example"), and I haven't successfully found resolution here. Conceptually my thought is to break the array into individual arrays ("child arrays"), find the object with a quotation, removing the quotations & comma, and then rebuild the "master" array and continue the process, but I haven't gotten this theory to work & I'm about to give up & move to Powershell. Any solutions, insight, advice here? Below is a screenshot of the process without the comma removal portion. I will also note the data will always have 8 columns, but the row count will be dynamic.
Also note: I'm working in Power Automate online version (not desktop) and I'm trying to do this with only Power Automate & not purchase a 3rd party connector,
Thank you
Adding a note here - The Compose function at the top of the screenshot is converting the CSV attachment from Base64 to String, I was then appending this to an array which was indicating a length of 1.
Instead I split the outputs of Compose, and then took the length of that output & am now getting a correct count of array elements. Working on a Do-Until loop with that.
Share
Report
All responses (
Answers (
