Forum Discussion
How to split strings by a delimiter?
Hello, I have a filed called campaign name and the most recent campaign names have their strings delimited by "-" For instance I have a campaign called: London_Car-Blue-March_2021 and I ...
Hi Anonymous
You can use Split Column in Query Editor .Enter “-” to split value .
The effect is as shown:
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HotChilli
Community Champion
Community ChampionNot really. In the intermediate step between Get Data and powerbi front end where you can shape and 'Transform Data'
It's all here:
https://docs.microsoft.com/en-us/power-query/split-columns-delimiter
Hi,
Just for clarification, I am using a table created from a union of different data sources. Hence, power Query is not available for this table created. Is there any way I can use split the desired column by a delimiter in this case"-" without using Power Query?