Solved: Remove unwanted text from a String - Qlik Community

brf10043 · ‎2017-04-20

I'm pulling data from a sharepoint list and some of the text has extra unwanted characters.

How would I remove "<span aria-hidden="true"></span>" from the string below

<span aria-hidden="true"></span>Lets all work 3 days a week

or

remove everything except "Lets all work 3 days a week" from the string below?

<div class="ExternalClass450FFA875469469B9098549F4A621B80"><p><span aria-hidden="true"></span>Lets all work 3 days a week</p></div>

vinieme12 · ‎2017-04-20

The below works

EDITTEXT:

Mapping Load * inline [

From,to

>,@{

<,}@

];

LOAD

textbetween(Mapsubstring('EDITTEXT',replace(FIELDIS,'><','_')),'@{','}@') as FieldIS

;

LOAD if(Match(right(Trim(FIELDIS),1),'>')=0,FIELDIS&'<',FIELDIS) as FIELDIS inline [

FIELDIS

<span aria-hidden="true"></span>Lets all work 3 days a week line 2 test

];

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

devarasu07 · ‎2017-04-20

temp:

LOAD * INLINE [

Field

];

Fact:

Load stripHTML(Field) as FieldCleaned

Resident temp;

devarasu07 · ‎2017-04-20

Hi,

Refer to the attachment,

vishsaggi · ‎2017-04-20

Try this

= Subfield(Subfield('<div class="ExternalClass450FFA875469469B9098549F4A621B80"><p><span aria-hidden="true"></span>Lets all work 3 days a week</p></div>', '</span>',2), '<')

vishsaggi · ‎2017-04-20

stripHTML() is this new function in V12.0 ?

brf10043 · ‎2017-04-20

Could be. I can't get it to work in 11.

devarasu07 · ‎2017-04-20

Hi,

nope, it's vbscript function

4GuysFromRolla.com

brf10043 · ‎2017-04-20

I'm not sure I follow this. It appears that you are hardcoding this. I can't predict what the text I want to keep will be.

"Lets all work 3 days a week" is just on of the entries.

brf10043 · ‎2017-04-20

The actual column is "ows_TO_x002d_BE"

devarasu07 · ‎2017-04-20

Hi,

It's just vbscript only. it working fine in QV 11 also

try below steps,

1) in your qvw document. Press Ctrl+M (open macros windows)

2) try to do below settings and

2)