Forum Discussion
Adding Commas to Text
Hello, My data source is a SharePoint list and I want to add a comma within a text column so that it be cleanly split by a delimiter. This is how the text appears in some of the rows: BaCLH-20LH...
Anonymous , I power query use Split by position, multiple times with 3,4,4 and the create columns. If needed append them again
https://learn.microsoft.com/en-us/power-query/split-columns-positions
For visual you can also consider this approach after splitting and combine
Power BI- Text Part slicer to filter/search text - https://youtu.be/MKKWeOqFG4c
https://medium.com/@amitchandak/power-bi-search-text-parts-in-text-ad2f9783ffa2
What I did so far was change the three-letter 'BaC' into a four-letter one and then could split by number of characters as they now were all the same number. Once divided, I could revert the three-letter one into its original form.