Forum Discussion
Post PatronSplit column by comma - not followed by a space
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-space/td-p/1080924 . 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.
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.
1 Reply
patri0t82Ah, 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.