Forum Discussion
Solved
Split Text in Columns Based on a Delimiter
Hey there, power BI experts and enthusiasts!
I have been facing quite a problem recently in one of my projects.
The thing is:
I have a column that give me file addresses, with that in mind, i would like to split this column in other columns based on the string "\" delimiting the folders/files/parts of the address.
It must look like something like this:
The column "Adress" is the column I already have, I want to create the others.
If you could help me in this one I'd be really thankful.
In the query editor you can right click on your column and go to split column > be delimeter to break it into multiple fields.
2 Replies
In the query editor you can right click on your column and go to split column > be delimeter to break it into multiple fields.
