Quote Character

Hi lastnn30 ,

You can also choose to split based on some special characters. And you can choose a Quote character for the text. A quote character means that the delimiter within will not be considered as a delimiter.

For example, a text like this:

“895A xyz street, city A, Country B”,”Reza”,”Rad”

If used with a quote character of (“), will avoid using the (,) inside the address as the delimiter, and will give the output below;

If you have multiple occurrences of the same delimiter in the text, you can easily use this option to split into multiple columns. You can also consider splitting the values into multiple rows if the different parts of the text carry the same logical meaning. Options such as the quote character and special characters as delimiter can help in complex situations.

More details: Split Column by Delimiter in Power BI and Power Query - RADACAD

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.