Hi Peter, how are you?
I have another Text to Columns problem i want to solve. It's very similar to the last one but the column layout is different.
I want to split the follow text strings into columns. Below I have written the delimiters:
[TABLE="class: cms_table, width: 572"]
<tbody>[TR]
[TD]Alpine Persefone LR1 74,500 Sungdong 2008 13,500 Navig8 1 Year[/TD]
[/TR]
[TR]
[TD]Archangelos Gabriel LR1 72,300 Hudong 2005 14,000 Trafigura Beheer BV 9 Months[/TD]
[/TR]
[TR]
[TD]Alpine Penelope LR1 74,400 Sungdong 2008 14,500 Inc Options Vitol 1 Year[/TD]
[/TR]
[TR]
[TD]Nord Vantage MR2 50,600 Hyundai Vinashin 2018 16,000 Union Maritime 1 Year[/TD]
[/TR]
[TR]
[TD]Centennial Misumi MR2 47,200 Onomichi Dockyard 2008 13,250 Phillips 66 1 Year[/TD]
[/TR]
[TR]
[TD]Front Loki Suezmax 156,000 Jiangsu Rongsheng 2010 23,500 Repsol 1 Year
Example CSV
Vessel Name, Type, DWT, Yard, Built, Rate, Charterer, Period
Alpine Persefone, LR1, 74500, Sungdong, 2008, 13500, Navig8, 1 Year
Delimiters
Vessel Name stops when LR1 or MR2 or Suezmax or VLCC or LR2 or or MR1 or Handy appears.
DWT is always a number
Yard is always Text
Built is always a number
Rate is always a number
Charterer can be text and numbers
Period maybe days, month, months, year, years, min-max
Again I prefer a formula over a Macro
Many thanks for any help you can provide.
Kind regards
Bear 1[/TD]
[/TR]
</tbody>[/TABLE]