QlikView App Dev

[Anonymous]

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]

hI,

use

KeepChar(fieldname,'0123456789')

Regards

[Anonymous]

hi result Come like this

002423002423

i want only of 002423 this kindly help me.

[arulsettu]

try this

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

[MK_QSL]

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

[PrashantSangle]

If Nos is always come after last space then

you can try

subfield(FieldName,' ',-1)

Regards

[MayilVahanan · Accepted solution]

Hi

Try like this

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

[Anonymous]

Hi thanks for all

All the answers working fine

Thanks to all..

Siraj