topic Re: Extract numeric part in QlikView

Extract numeric part

Tue, 30 Sep 2014 07:10:50 GMT

NEED help for following:-

PFA image

My data is in alphanumeric format as shown in attached image below i need to extract only numeric part :-

Please help

Re: Extract numeric part

maxgro — Tue, 30 Sep 2014 07:12:51 GMT

from Qlik inline help

KeepChar(s1 , s2)

Returns the string s1 less all characters not contained in string s2.

Example:

keepchar ( 'a1b2c3','123' ) returns '123'

PurgeChar(s1, s2)

Returns the string s1 less all characters contained in string s2.

Example:

purgechar ( 'a1b2c3','123' ) returns 'abc'

Re: Extract numeric part

Tue, 30 Sep 2014 07:14:00 GMT

but how cani specify second part data is different in all rows

Re: Extract numeric part

ychaitanya — Tue, 30 Sep 2014 07:14:16 GMT

Use KeepChar(FieldName) as Field_Name

This should work

Regards

Chaitanya

Re: Extract numeric part

ychaitanya — Tue, 30 Sep 2014 07:15:41 GMT

use purgechar(Fieldname) as String_Data

and

use keepchar(Fieldname) as Numeric_Data

so you will get the values in 2 different fields

Re: Extract numeric part

ashfaq_haseeb — Tue, 30 Sep 2014 07:20:20 GMT

Try this

KeepChar(SAP_CODE,'0123456789') as SAP_CODE

Regards

ASHFAQ

Re: Extract numeric part

Tue, 30 Sep 2014 07:23:41 GMT

yup it worked,,Thanx

Re: Extract numeric part

ashfaq_haseeb — Tue, 30 Sep 2014 07:25:46 GMT

Hi,

Can you close this thread by selecting appropriate answers.

Regards

ASHFAQ

Re: Extract numeric part

Tue, 30 Sep 2014 07:30:15 GMT

Hii Snehal,

Use the following script to keep only numeric data:-

LOAD * INLINE [
A
12s
234f
];

store S into S.qvd;
drop Table S;

d:

LOAD PurgeChar(A,'sf') as A
FROM
S.qvd
(qvd);

Thanks & Regards

Prince Anand

Re: Extract numeric part

maxgro — Tue, 30 Sep 2014 07:46:40 GMT

load

....,

KeepChar(yourfield , '0123456789') as newfield

.....

from

.....