Power Automate Parse a Quote Encapsulated CSV with Commas in Data Columns

>> YOUR LINK HERE: ___ http://youtube.com/watch?v=Ci9EO7SRalY

This video demonstrates how to parse a quote encapsulated CSV file with commas in data columns using Power Automate. It shows two solutions: one with multiple expressions and one with a single expression. • Parsing a CSV in Power Automate can be easy enough but what about a CSV that contains a comma in one of the data columns. Watch my video to find out how I did it. Data is a sample from ServiceNow. • If you Office Scripts, you might want to check out the following solution • CSV to Excel Power Automate and Offic... • Highlights: • [00:00:01] The problem and the example CSV file • The CSV file has commas within the data columns • This causes extra columns when using the split expression • [00:01:11] The first solution with multiple expressions • Replace all double commas with comma double quotes comma • Replace all single quote comma with a pipe • Replace all double quotes with nothing • Split the string by the return line • [00:04:24] The select statement to return an array • Skip the first line with the header • Provide the key names for the fields • Split each item by the pipe • [00:05:18] The test run of the first solution • The output is a nicely formatted array • The commas within the data columns are preserved • [00:05:52] The second solution with a single expression • Combine all the compose actions into one expression • Use the same select statement as before • [00:07:49] The test run of the second solution • The output is the same as the first solution • The expression is shorter and simpler Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕

#############################

New on site