Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Evaluate(KeepChar([String Field],0123456789)) as [Numeric Field]
In the script?
"All numbers" means one record per number?
There can other numeric values apart from those starting from 91. For eg.
Gdhjsj hdhjdka 123 9163738
This would just extract the records which have 91 in them.
Input :- shhdhd gdhsjs 53627 9163637 91737337
Output :- 9163637,91737337
Try like below
Load Concat(Field,',') as Field where WildMatch(Field, '91*');Load SubField(Field, ' ') as Field Inline[Fieldshhdhd gdhsjs 53627 9163637 91737337];