Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish2459_58
Creator
Creator

Text edit

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....

Labels (1)
1 Solution

Accepted Solutions
Kushal_Chawda

@Krish2459_58  try below

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

 

Screenshot 2023-06-15 at 14.55.20.png

View solution in original post

4 Replies
Kushal_Chawda

@Krish2459_58  try below

=trim(TextBetween(lower(Notes),'">','</div>', SubStringCount(Notes,'">')))
BrunPierre
Partner - Master
Partner - Master

Perhaps?

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

@Kushal_Chawda ,

 

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

Krish2459_58_0-1686795410392.png

 

 

Kushal_Chawda

@Krish2459_58  try below

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

 

Screenshot 2023-06-15 at 14.55.20.png