extract text to tabular format

Copper Contributor

Hello All,


Pl help


I get a CSV where one column has got all tags extracted data with values. the values starts with @{ all values seperated by ; } the data is seperated by semi colan ";" mark.


@{Fist Name=John; middle name=Joe; Last Name=Boxer} some thing like this. 


All cells extracted data is not unique. Means that some cells will not have first name & last Name or Only Fist name like that.


Is it possible to extract using a text and places the values under a table with headers

Column B    Column C         Column D              

First Name  Middle Name   Last Name

John            Joe                   Boxer 

1 Reply

Hi @Srikanth0405 


With Get & Transform aka Power Query:

Sans titre.png


All Power Query steps with the User Interface