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-21LH-23
I want to add commas so that it looks like this:
BaC,LH-20,LH-21,LH-23
If the first part was just four characters, that would be a clean split but the first part has three characters. I have also tried SplitTextBy.CharacterTransition but that did not work effectively.
After the text gets split into different columns, each individual item (BaC, LH-20, LH-21, and LH-23) will then be summed and used in visualizations.
Does anyone have any ideas?
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
6 Replies
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-ad2f9783ffa2Is this what you are looking for?
pls try this
Hi,
What common logic has to be deployed for inserting commas? Please take a representatie sample and show the expected result.
