Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How to extact the exact text from the below field value.
Column Name : Notes
<div class="ExternalClass9B5D49FF54C5429293939AB8EE7E6521"><div style="font-family:Calibri, Arial, Helvetica, sans-serif;font-size:11pt;color:rgb(0, 0, 0);">Test note 1</div></div>
Actual field value : Test note 1
Thanks....
@Krish2459_58 try below
LOAD *,
SubField(TextBetween(left(Notes,index(Notes,'</div>',-1)-1),'<div','<',SubStringCount(Notes,'<div')),'>',-1) as Notes_Description
@Krish2459_58 try below
=trim(TextBetween(lower(Notes),'">','</div>', SubStringCount(Notes,'">')))
Perhaps?
It works, but for few rows it's not working.Sharing the data file.Please check once.
@Krish2459_58 try below
LOAD *,
SubField(TextBetween(left(Notes,index(Notes,'</div>',-1)-1),'<div','<',SubStringCount(Notes,'<div')),'>',-1) as Notes_Description