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> |
