Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
5 years ago

A slightly unusual question.  You have tried Power Query split by delimiter? 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Sorry I am not  sure what is it i am new into Powerbi. However,  I have tried your suggestion but I am not able to use the split function from the "Transform data" tab as I am using a direct query data source