HockeyDiablo
Board Regular
- Joined
- Apr 1, 2016
- Messages
- 182
I have extracted a rather large XML file. Inside the file was an old method of how I stored my invoices. Here is the string of text that I have:
Data
sp 199 blah blah blah
blah blah 60 cbl blah
Door 999 blah blah blah
blah 299 sp door 888 blah blah
Here is what I am looking to get done...
[TABLE="width: 500"]
<tbody>[TR]
[TD]SP[/TD]
[TD]CBL[/TD]
[TD]Door[/TD]
[/TR]
[TR]
[TD]199[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]299[/TD]
[TD][/TD]
[TD]888[/TD]
[/TR]
</tbody>[/TABLE]
Data
sp 199 blah blah blah
blah blah 60 cbl blah
Door 999 blah blah blah
blah 299 sp door 888 blah blah
Here is what I am looking to get done...
[TABLE="width: 500"]
<tbody>[TR]
[TD]SP[/TD]
[TD]CBL[/TD]
[TD]Door[/TD]
[/TR]
[TR]
[TD]199[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]60[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]999[/TD]
[/TR]
[TR]
[TD]299[/TD]
[TD][/TD]
[TD]888[/TD]
[/TR]
</tbody>[/TABLE]