topic Re: How to Remove '-' from field in QlikView

How to Remove '-' from field

soha1902 — Wed, 13 May 2015 08:38:07 GMT

Hi All,

I have one field like below

My requirement is if a pariticular fieldname value contains non numeric values in its 2nd position then I need to remove first '-' from left.

For example:

Values AC-BC-45

AB-AC-56

conatins non numeric values in its 2nd position (BC and AC)

Now I want to remove first '-' from left and the desired output should like this:

Please help.

Thanks.

stigchel — Wed, 13 May 2015 08:45:26 GMT

Try with

=PurgeChar(FieldName,'0123456789-')&'-'&KeepChar(FieldName,'0123456789')

tresB — Wed, 13 May 2015 08:49:49 GMT

Try like:

Load

If(not IsNum(SubField(Input,'-',2)), SubField(Input,'-',1)&Mid(Input,Index(Input,'-',1)+1), Input) as NewInput;

Load * Inline [

Input

AB-12

CD-34

AC-BC-45

AB-AC-56

DE-10

];

awhitfield — Wed, 13 May 2015 08:49:50 GMT

Hi shoa,

See the example below using an inline load:

DATA:

Load (Left(Data,2)&Mid(Data,4)) AS Data
Inline
[
Data
AB-DC-01
];

Which gives the result ABDC-01

HTH

Andy