I need to extract a word between 2 different strings. The first strings starts in any of the following words- LTD, LP, FD or LTD. And it ends before the word "TWO". I'm thinking of using mid function but it can only be used for one argument.
Example:
I need to extract the following : ASWU, ASDU, ASWU from this data
[TABLE="width: 145"]
<tbody>[TR]
[TD]LTD ASWU TWO[/TD]
[/TR]
[TR]
[TD]LP ASDU TWO[/TD]
[/TR]
[TR]
[TD]FD ASWU TWO[/TD]
[/TR]
[TR]
[TD]LTD ASWU TWO
I hope you could help me guys. thank you
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
Example:
I need to extract the following : ASWU, ASDU, ASWU from this data
[TABLE="width: 145"]
<tbody>[TR]
[TD]LTD ASWU TWO[/TD]
[/TR]
[TR]
[TD]LP ASDU TWO[/TD]
[/TR]
[TR]
[TD]FD ASWU TWO[/TD]
[/TR]
[TR]
[TD]LTD ASWU TWO
I hope you could help me guys. thank you
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]