topic Extract only numbers in the String in QlikView

Extract only numbers in the String

Anonymous — Wed, 01 Jul 2015 05:52:46 GMT

Hi All

i have an issues i need to extract the Cheque number from the bank Statement Excel

The String like this

CHQ DEPOSIT002423xxx BANK LTDCHQ No 002423

In this Above String i need to extract the Red Number alone other string and number i don't want

Kindly help me to achieve this...

Thanks

Siraj

PrashantSangle — Wed, 01 Jul 2015 05:54:07 GMT

hI,

use

KeepChar(fieldname,'0123456789')

Regards

Anonymous — Wed, 01 Jul 2015 06:00:30 GMT

hi result Come like this

002423002423

i want only of 002423 this kindly help me.

arulsettu — Wed, 01 Jul 2015 06:01:13 GMT

try this

=KeepChar(Left('CHQ DEPOSIT002423xxx BANK LTDCHQ No 002423',20),'0123456789')

MK_QSL — Wed, 01 Jul 2015 06:03:12 GMT

=KeepChar(TextBetween('CHQ DEPOSIT002423xxx BANK LTDCHQ No 002423',' ',' '),'0123456789')

PrashantSangle — Wed, 01 Jul 2015 06:05:16 GMT

If Nos is always come after last space then

you can try

subfield(FieldName,' ',-1)

Regards

MayilVahanan — Wed, 01 Jul 2015 06:06:15 GMT

Try like this

=Keepchar(TextBetween('CHQ DEPOSIT002423xxx BANK LTDCHQ No 002423','','BANK'),0123456789)

Anonymous — Wed, 01 Jul 2015 06:13:34 GMT

Hi thanks for all

All the answers working fine

Thanks to all..

Siraj