Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
We value your feedback – take our 5-minute QlikView modernization survey
cancel
Showing results for 
Search instead for 
Did you mean: 
venkatbza
Creator
Creator

Extract number from string

Hi All,

I have a comments column and in that I have service number and along with some comments and dates. In that I have to strip only service number. service numbers are mostly having 8 digits but few cases service numbers are 7 and 9 digits. 

sample data posted below, help me out how I can extract only numbers(highlighted red color) from a given column.

Comments
DLL DISC / 02.09.2021/ 30364307/abc
LEASE DISC / 11.23.2020/10117134/def
LEASE DISC / 11.23.2020/10127588/Integr
LEASE DISC / 10101466, 10143520 / ADFC
LEASE DISC / 10111445 / 80800005
LEASE DISC / 10131743, 10149069 / not
LEASE DISC / 10133124/ 10146144 QUALITY
LEASE DISC / 10145033 / 10118692 / Comm
LEASE DISC / 10146155/10135854 / Avffd
LEASE DISC / 10147220/10104449 /kjkdj
LEASE DISC / 10147431, 10147394 / hdhdh
LEASE DISC / 30335157 / 1518833 hhdyyy
LEASE DISC /10104449, 10147220 RYETBDJ
LEASE DISC/10105402-10144528/TRHJDSNJ
LEASE DISC/10124511-10147275/HTHRJHJ
LEASE DISC/10143314-10144617/hdjhjdhk
PMC DISC / 10141863, 10147184 / kokoo
PMC DISC 91000010 /10141863/hhdj ddd
PMC DISC 91000010 /10145554/jjjdjd'sss
PMC/ADV MED HOMECARE/10131042 10144358
PMC/DYNAMIC HEALTHCARE/10146887 10101760
WIRE FEE / 08-26-2020/10106466/MEDICAL
WIRE FEE/03.26.2021/10141187/TG OXYGEN
10100465 Lease Disc
10101498 Lease Disc
10101760 Lease Disc
10123751 / hddyytr nnn
10125787 Lease Disc
10126312 /reed nhhd lllj
10127600 Lease Disc
10140316 Lease Disc
10146887 Lease Disc
ACH / 10101498 / hhdjh jkeebeel
ACH 91000016/AUGUST PREFUND/REBATE
WIRE FEE/03.26.2021/955843261/TG OXYGEN
LEASE DISC / 1014368 / bvcded Consulting

 

Thanks

3 Replies
Or
Champion
Champion

PurgeChar() or KeepChar() should work here - note that the cases where there are two sets of numbers will result in one large number.

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/StringF...

 

 

venkatbza
Creator
Creator
Author

Hi Master,

Thank you for reply. By using PurgeChar or KeepChar dates are also converting to numbers which I don't need.

Thanks.

Or
Champion
Champion

PurgeChar and KeepChar both return strings, not numbers.

You can explicitly use num() or text() as required to convert the results to a number or text interpretation.