Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Deepak13
Contributor III
Contributor III

position of subfield in a string qlikview

 

Hello Qlik Community

i have a field that has string value as shown below

abscssdf sadfsdf sdfsdf 911232243 912323234

i want to extract all numbers starting with 91 from the field.

TIA

 

 

 

Labels (1)
6 Replies
BrunPierre
Specialist II
Specialist II

As below

Evaluate(KeepChar([String Field],0123456789)) as [Numeric Field]
MarcoWedel

In the script?

"All numbers" means one record per number?

 

 

Deepak13
Contributor III
Contributor III
Author

There can other numeric values apart from those starting from 91. For eg.

Gdhjsj hdhjdka 123 9163738

vinieme12
Champion III
Champion III

as below

load *

From SomeQvdSource.qvd(qvd)

Where Wildmatch(Fieldname,'91*');

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Deepak13
Contributor III
Contributor III
Author

This would just extract the records which have 91 in them. 

Input :- shhdhd gdhsjs 53627 9163637 91737337

Output :- 9163637,91737337

 

 

MayilVahanan

Hi 

Try like below


Load Concat(Field,',') as Field where WildMatch(Field, '91*');
Load SubField(Field, ' ') as Field Inline
[
Field
shhdhd gdhsjs 53627 9163637 91737337
];

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