How to split DownloadData (HTML meta data) into multiple columns based on tr> Tags

[Mohd-Siddiqui1]

Hi there,

I have download data from a website in the form of HTML. I want to split the data contained in single column (DownloadData)

into multiple columns.

Condition for splitting is: Data contained in tags tr> to /tr> should be in one column, and the data in next tr> to /tr> should be in another column and so on.

Input Data:  

DownloadData

tr>

td>

p>

strong>Hello. This is test string.

/strong>

/p>

/td>

/tr>

tr>

td>

p>

a href="testLink"> XYZ Country

/a>

/p>

/td>

/tr>

Output Data:

DownloadData1	DownloadData2
tr>	tr>
td>	td>
p>	p>
strong>Hello. This is test string.	a href="testLink"> XYZ Country
/strong>	/a>
/p>	/p>
/td>	/td>
/tr>	/tr>

[atcodedog05 · Accepted solution]

Hi @Mohd-Siddiqui1 

Here is how you can do it.

Workflow:

Hope this helps : )

[Mohd-Siddiqui1]

Hi atcodedog05,

Thank you so much for the quick help. Really appreciated!

[atcodedog05]

Happy to help : ) @Mohd-Siddiqui1 

Cheers and have a nice day!