Text edit

[Krish2459_58]

Hi,

How to extact the exact text from the below field value.

Column Name : Notes

<div class="ExternalClass9B5D49FF54C5429293939AB8EE7E6521"><div style="font-family&#58;Calibri, Arial, Helvetica, sans-serif;font-size&#58;11pt;color&#58;rgb(0, 0, 0);">Test note 1</div></div>

Actual field value : Test note 1

Thanks....

[Kushal_Chawda]

@Krish2459_58  try below

=trim(TextBetween(lower(Notes),'">','</div>', SubStringCount(Notes,'">')))

[BrunPierre]

Perhaps?

=SubField(Trim(Subfield(Trim(Notes),'</div></div>',1)),'">',3)

[Krish2459_58]

@Kushal_Chawda ,

It works, but for few rows it's not working.Sharing the data file.Please check once.

[Kushal_Chawda · Accepted solution]

@Krish2459_58  try below

LOAD *,
SubField(TextBetween(left(Notes,index(Notes,'</div>',-1)-1),'<div','<',SubStringCount(Notes,'<div')),'>',-1) as Notes_Description