extract text to tabular format

Occasional Visitor

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