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> |
Solved! Go to Solution.
Hi atcodedog05,
Thank you so much for the quick help. Really appreciated!
Happy to help : ) @Mohd-Siddiqui1
Cheers and have a nice day!