extract text to tabular format

Question

Hello All,&nbsp;Pl help&nbsp;I get a CSV where one column has got all tags extracted data with values. the values starts with&nbsp;@{ all values seperated by ; }&nbsp;the data is seperated by semi colan ";" mark.&nbsp;@{Fist Name=John; middle name=Joe; Last Name=Boxer} some thing like this.&nbsp;&nbsp;All cells extracted data is not unique. Means that some cells will not have first name &amp; last Name or Only Fist name like that.&nbsp;Is it possible to extract using a text and places the values under a table with headersColumn B&nbsp; &nbsp; Column C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Column D&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;First Name&nbsp; Middle Name&nbsp; &nbsp;Last NameJohn&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Joe&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Boxer&nbsp;

lorenzo · Answer

Hi&nbsp;Srikanth0405&nbsp;&nbsp;With Get &amp; Transform aka Power Query:&nbsp;All Power Query steps with the User Interface

Forum Discussion

extract text to tabular format

1 Reply

Resources