In PowerBI Query Editor, split column using starting and ending delimiter

[Anonymous]

Hi,

I have a column of data which is of the format given below:

[{'name': 'TriStar Pictures', 'id': 559}, {'name': 'Teitler Film', 'id': 2550}, {'name': 'Interscope Communications', 'id': 10201}]

I want to split this column of data into multiple columns, with delimiter start as '{' and delimiter end as '}'.

Endresult expected:

Column 1	Column 2	Column 3
{'name': 'TriStar Pictures', 'id': 559}	{'name': 'Teitler Film', 'id': 2550}	{'name': 'Interscope Communications', 'id': 10201}

If I use the delimiter as comma, then even then the result would be 6 columns, which is not what I want. Can you please suggest how this can be done in Power BI Query Editor using the Split column feature.

[adityavighne · Accepted solution]

You can use below DAX

=PATHITEM(SUBSTITUTE(Person[Full Name], “{”, “|”), 1)

1 is for previous text {

2 for after text  {

[Anonymous]

Thanks Aditya for your quick response. It really helped in resolving the issue. Thanks once again.