topic Re: Split number alone in Alpha numeric string in QlikView

Split number alone in Alpha numeric string

Anonymous — Sun, 29 Mar 2015 17:34:21 GMT

Dear All

I need a string function which splint integer values in the alpha numeric string

Example chequeNo 23456 xxxxxxxx bank

from this value i need to split this number alone 23456 as separate field which function i need to use can any one kindly help me

Thanks in Advance

Siraj

Re: Split number alone in Alpha numeric string

prieper — Sun, 29 Mar 2015 18:06:33 GMT

SUBFIELD(MyField, ' ', 2) AS MyNumber

HTH Peter

Re: Split number alone in Alpha numeric string

jjordaan — Sun, 29 Mar 2015 18:07:18 GMT

Hi Siraj,

I think that you can use function KeepChar.

It works like this (copied from help file)

KeepChar(s1 , s2)

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

Example:

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

In your case s2 parameter should be like '0123456789

Re: Split number alone in Alpha numeric string

MK_QSL — Sun, 29 Mar 2015 18:10:11 GMT

KeepChar(YourFieldName,'0123456789') as YourFieldName

Re: Split number alone in Alpha numeric string

Anonymous — Sun, 29 Mar 2015 18:17:43 GMT

Hi Siraj Ahamed:

KeepChar(Field,'0123456789') as NumbersOnly

KeepChar('chequeNo 23456 xxxxxxxx bank','0123456789' as NumberOnly

NumbersOnly will contain 23456

Good luck

CB.

Re: Split number alone in Alpha numeric string

Anonymous — Sun, 29 Mar 2015 18:24:54 GMT

the keepChar functions provides integer randomly not returning the Cheque number '23456' of that filed

This is feild

CHQ DEPOSIT574918 XXXXXXX Bank

CHQ DEPOSIT681820 XXXXXXX Bank

CHQ DEPOSIT751955 XXXXXXX Bank

CHQ DEPOSIT000364 XXXXXXX Bank

I want like this

574918

681820

751955

000364

thanks for your reply.

Re: Split number alone in Alpha numeric string

jjordaan — Sun, 29 Mar 2015 18:29:18 GMT

Use this in a textbox to verify it

=KeepChar('CHQ DEPOSIT574918 XXXXXXX Bank', 0123456789)

Re: Split number alone in Alpha numeric string

Anonymous — Sun, 29 Mar 2015 18:38:03 GMT

Thanks lot

this KeepChar('CHQ DEPOSIT574918 XXXXXXX Bank', 0123456789) work well

Thanks all Great...

Re: Split number alone in Alpha numeric string

R_Woods_UWS — Fri, 12 Jun 2020 10:45:46 GMT

My alphanumeric string has numbers then alpha chars then number. I want to show only the numbers before the first alpha character - is there a way to do this. Each part of the string can be different lengths.

Example text numeric (keep) remainder(drop)

1918xxxxxx1 1918 xxxxxx1

873xxxxxxxx34 873 xxxxxxxx34