topic Re: Remove the characters in QlikView

Remove the characters

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have a field with values as below

<div class="ExternalClassA912479D552541668AD7097708527483">Orders & Shipments</div>

In this, i wanted to remove the characters which are all existed in between < >

That means, for the above value i need

Orders & Shipments

only.

Few more values ::

<div class="ExternalClass97B6256A295C43DF98B54A852E644B1E"><html> <div class="ExternalClassD1A3669AB4B8494E860ED52F60A4F5AC">Orders & Shipments</div> </html></div>

<div class="ExternalClass06D57CDFE8344AE9A95A9D9E3C238F30">Order data</div>

How can i remove ?

Re: Remove the characters

devarasu07 — Fri, 05 May 2017 06:43:40 GMT

Hi,

Like this?

Temp:

load * Inline [

Field

<div class="ExternalClassA912479D552541668AD7097708527483">Orders & Shipments</div>

<div class="ExternalClass06D57CDFE8344AE9A95A9D9E3C238F30">Order data</div>

];

Data:

LOAD RecNo() as RecNo, Field

Resident Temp;

Drop Table Temp;

HtmlTag_Map:

MAPPING LOAD DISTINCT '<' & TextBetween('<' & SubField(Field, '<'),'<','>') & '>' as HtmlTag, '' as Substitute

Resident Data;

JOIN(Data) LOAD RecNo, MapSubstring('HtmlTag_Map', Field) as Field_Cleansed

Resident Data;

FYI,

Re: Remove the characters

ahaahaaha — Fri, 05 May 2017 07:05:46 GMT

Hi,

May be like this (look attached file)

Expression:

'Order'&TextBetween(Field, 'Order', '<')

Regards,

Andrey

Re: Remove the characters

Anil_Babu_Samineni — Fri, 05 May 2017 07:21:07 GMT

What you do if you have something like below

<div class="ExternalClassA912479D552541668AD7097708527483">Sample Welcome Orders & Shipments</div>

May be this?

=TextBetween(FieldName, '>', '<')

Re: Remove the characters

mohan2391 — Sun, 07 May 2017 07:44:59 GMT

Hi,

It's working fine but is giving all the values which start with ORDER only.

But in my field values are starting with different names not with a few fixed words

Thanks for the support.