Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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>
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
<div class="ExternalClass450FFA875469469B9098549F4A621B80"><p><span aria-hidden="true"></span>Lets all work 3 days a week</p></div>
<span aria-hidden="true"></span>Lets all work 3 days a week line 2 test
];
temp:
LOAD * INLINE [
Field
<div class="ExternalClass450FFA875469469B9098549F4A621B80"><p><span aria-hidden="true"></span>Lets all work 3 days a week</p></div>
];
Fact:
Load stripHTML(Field) as FieldCleaned
Resident temp;
Hi,
Refer to the attachment,
Try this
= Subfield(Subfield('<div class="ExternalClass450FFA875469469B9098549F4A621B80"><p><span aria-hidden="true"></span>Lets all work 3 days a week</p></div>', '</span>',2), '<')
stripHTML() is this new function in V12.0 ?
Could be. I can't get it to work in 11.
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.
The actual column is "ows_TO_x002d_BE"
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)