Solved: Re: Extract only numbers in the String - Qlik Community

Anonymous · ‎2015-07-01

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

MayilVahanan · ‎2015-07-01

Hi

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

PrashantSangle · ‎2015-07-01

hI,

use

KeepChar(fieldname,'0123456789')

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Anonymous · ‎2015-07-01

hi result Come like this

002423002423

i want only of 002423 this kindly help me.

arulsettu · ‎2015-07-01

try this

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

MK_QSL · ‎2015-07-01

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

PrashantSangle · ‎2015-07-01

If Nos is always come after last space then

you can try

subfield(FieldName,' ',-1)

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

MayilVahanan · ‎2015-07-01

Hi

Try like this

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

Anonymous · ‎2015-07-01

Hi thanks for all

All the answers working fine

Thanks to all..

Siraj