topic Re: How to remove unwanted characters in QlikView

How to remove unwanted characters

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

Hi,Experts.

I want remove unwanted characters in my data.My data is below manner

sid	SNO
TT2347	1
RT76388_AW4	2
HR342344-YUE	3
TY2564 (YRU_34)	4
JKA4242(TR56)	5
UJ67383	6
YR56784	7

My output of above table is like this

sid	SNO
TT2347	1
RT76388	2
HR342344	3
TY2564	4
JKA4242	5
UJ67383	6
YR56784	7

Please give me a solution.

Thanks in advance.

Re: How to remove unwanted characters

arvind_patil — Sat, 23 Jun 2018 07:50:23 GMT

Hi Suman,

Please use d Sub filed three time function like below:

1. Step1

Subfield(sid,'_',1),

2. =Subfield(sid,'-',1),

3 .Subfield(sid,'(',1),

Thanks,

Arvind Patil

Re: How to remove unwanted characters

arvind_patil — Sat, 23 Jun 2018 07:56:35 GMT

Hi ,

Try Below

=Subfield(Subfield(SubField(sid,'-',1),'_',1),'(',1)

Thanks,
Arvind Patil

Re: How to remove unwanted characters

Anonymous — Sat, 23 Jun 2018 08:45:46 GMT

Thanks Arvind.

Its working.You give a good suggestion.

Re: How to remove unwanted characters

sunny_talwar — Sat, 23 Jun 2018 11:02:18 GMT

This might be another way to do it. It also gives you the option to add more characters.

Table:

LOAD *,

FindOneOf(sid&'(', '_-(') as CharacterToFind,

Left(sid, FindOneOf(sid&'(', '_-(')-1) as ReqSid;

LOAD * INLINE [

sid, SNO

TT2347, 1

RT76388_AW4, 2

HR342344-YUE, 3

TY2564 (YRU_34), 4

JKA4242(TR56), 5

UJ67383, 6

YR56784, 7

];

Re: How to remove unwanted characters

Anonymous — Sun, 24 Jun 2018 16:15:35 GMT

Thanks sunny.

You give me good suggestion.