Forum Discussion
Cleaning Data in Query Editor with Inconsistent Delimeters
Hi All, I am trying to clean some data from within the Query Editor, but I'm a little limited in my M knowledge to be able to do so. Here's a mock data set that I am working with: W...
Hi Anonymous ,
We can use the Text.TrimStart function to meet your requirement, this function can removing all leading whitespace from text value. You can get more information from this document: https://docs.microsoft.com/en-us/powerquery-m/text-trimstart
BTW, pbix as attached.Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous ,
Use trim on your column to remove whitespaces.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel