topic Re: Function Help in QlikView

Function Help

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

Hi,

Can any one please help me on below requirement.

I have a Name field with below records.

Name

<p>A code that identifies the type of party that the postal address usage applies to.</p>

The name of the residential postal address country for the individual.

<div>A code that identifies the country of an organisation operating address.</div>

<p style="font-size: 12.0px;"><span style="font-size: 13.0px;">A code that identifies the country where an entity is registered to operate, in accordance with the rules set forth by the regulatory body that grants the registration.<br/></span></p>

Expected Output:

Name

A code that identifies the type of party that the postal address usage applies to.

The name of the residential postal address country for the individual.

A code that identifies the country of an organisation operating address.

A code that identifies the country where an entity is registered to operate, in accordance with the rules set forth by the regulatory body that grants the registration.

I have tried this logic to avoid<p> </p> but its removing p letter in the middle of text also.

PurgeChar(Name,'<,>,/,#,p')

I there any other way to handle this scenario. Please help me on this.

Thanks in advance.

Re: Function Help

m_woolf — Tue, 18 Feb 2020 13:15:45 GMT

Try:

replace(PurgeChar(Name,'/,#'),'<p>','')

Re: Function Help

pawwy1415 — Tue, 18 Feb 2020 14:00:04 GMT

Hi @m_woolf

Thanks for your reply.

Its working fine on <P> TAG scenario. But there are some records staring with <div> and some with <Span> tags. Is there any way to remove those tags as well .

Please help me on this.

Re: Function Help

m_woolf — Wed, 19 Feb 2020 13:34:25 GMT

replace(replace(replace(PurgeChar(Name,'/,#'),'<p>',''),'<div>',''),'<span>','')

Unless the "s" in span is capitalized as you show in your reply.

Re: Function Help

Brett_Bleess — Tue, 24 Mar 2020 18:46:12 GMT

Did the last post you received get you what you needed? If so, do not forget to return to the thread and use the Accept as Solution button on the post(s) that got you what you needed, in this case I would assume the last post above mine likely was the solution, but I prefer to have folks mark them versus me assuming as much, so please be sure to circle back to take care of this thread to close it out properly. If you still have further questions, please leave an update.

Regards,
Brett