Search Text in string and return a value from table

[krishnanshu]

Here is the table of raw data
[TABLE="width: 440"]
<colgroup><col></colgroup><tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Hi, I will call Sonia to come and get Nidhi from US for the party[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]R u going to teach in the school, where Rashi is teaching[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hi, I went to california and I saw Nidhi over there. I think she has shifted[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]I would like to me Karl in office today[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I would like These words to be searched in sequential order from L1 to L4 column. If any found, return with value of L5 in new column

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 441"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]L1[/TD]
[TD]L2[/TD]
[TD]L3[/TD]
[TD]L4[/TD]
[TD]L5[/TD]
[/TR]
[TR]
[TD]Gopal[/TD]
[TD]Babu[/TD]
[TD]Venkat[/TD]
[TD]Nidhi[/TD]
[TD]Sunnyvale[/TD]
[/TR]
[TR]
[TD]Sudeep[/TD]
[TD]Sameer[/TD]
[TD]Rashi[/TD]
[TD]Bala[/TD]
[TD]Los angeles[/TD]
[/TR]
[TR]
[TD]Sonia[/TD]
[TD]Arun[/TD]
[TD]Satish[/TD]
[TD]Jeeda[/TD]
[TD]New York[/TD]
[/TR]
[TR]
[TD]ABC[/TD]
[TD]Monika[/TD]
[TD]Karl[/TD]
[TD]MNO[/TD]
[TD]San Jose[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[krishnanshu]

but how do i copy and then paste??

 

[krishnanshu]

Thanks, XOR

 

[XOR LX]

Thanks, XOR

Sure! Is everything working, then? Solved?

Regards

 

[krishnanshu]

Sure! Is everything working, then? Solved?

Regards

yup, Kind of... Might reach you to you for some more help

 

[XOR LX]

yup, Kind of... Might reach you to you for some more help

Sure. Though not quite sure what you mean by "kind of"?

Regards