Split Text in Columns Based on a Delimiter

[vyny17]

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.

[mwegener]

Hi @vyny17 ,

use "Split Column By Delimiter"

[jdbuchanan71 · Accepted solution]

@vyny17 

In the query editor you can right click on your column and go to split column > be delimeter to break it into multiple fields.