Split column by comma - not followed by a space

[patri0t82]

Hello, this post is very similar to this post: https://community.fabric.microsoft.com/t5/Power-Query/Split-column-by-delimeter-not-followed-by-a-sp... . I'm not sure how to incorporate the solution though.

In a nutshell, there are some commas incorrectly mapped in my CSVs that are followed by spaces. 

I'm importing a SharePoint folder full of CSVs, which is already splitting the bad data by comma, creating the misaligned columns. I need to ignore commas followed by spaces BEFORE the data is imported.

[patri0t82 · Accepted solution]

Ah, okay I figured out a solution. I imported the CSVs into Power Query as one single column without splitting. I then replaced the value ", " with "" (nothing), then split by comma, and it worked just fine.