topic Re: Removing Numeric characters in QlikView

Removing Numeric characters

Anonymous — Wed, 11 Oct 2017 10:17:01 GMT

Hello All,

In dimension, I have data as follows,

1718-021-A

1718-021-AA

1718-021-A1

1718-021-AA1

1712-021-B

1718-021-B1

My final requirement is to get the data as follows,

1718-021-A

1718-021-AA

1718-021-A

1718-021-AA

1712-021-B

1718-021-B

Removing all numeric characters from the field.

Re: Removing Numeric characters

tresB — Wed, 11 Oct 2017 10:24:47 GMT

If it's about removing numerics from last substring, one solution could be like:

Left(YourStringField,FindOneOf(YourStringField,'-',-1)) & Purgechar(SubField(YourStringField,'-',-1),'0123456789')

Re: Removing Numeric characters

krishna789 — Wed, 11 Oct 2017 10:26:46 GMT

hope this will help you Removing character values and taking only numeric values from particular field

Re: Removing Numeric characters

mayankraoka — Wed, 11 Oct 2017 10:28:56 GMT

Also you can refer below blog for better understanding

PurgeChar and KeepChar Functions

Regards,

Mayank

Re: Removing Numeric characters

jonathandienst — Wed, 11 Oct 2017 10:36:58 GMT

Or this:

Left(Field, Index(Field, '-', -1)) & PurgeChar(SubField(Field, '-', -1), '0123456789')

Re: Removing Numeric characters

arvind_patil — Wed, 11 Oct 2017 10:42:08 GMT

Hi,

Please find below:

LOAD * Inline [

Data

1718-021-A

1718-021-AA

1718-021-A1

1718-021-AA1

1712-021-B

1718-021-B1

];

NoConcatenate

T1:

LOAD *,

SubField(Data,'-',1)&'-'&SubField(Data,'-',2)&'-'&purgechar(SubField(Data,'-',3) ,'0123456789') as [Final Data]

Resident T;

DROP Table T;

Thanks,

Arvind Patil