position of subfield in a string qlikview

[Deepak13]

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

[BrunPierre]

As below

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

[MarcoWedel]

In the script?

"All numbers" means one record per number?

[Deepak13]

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

Gdhjsj hdhjdka 123 9163738

[vinieme12]

as below

load *

From SomeQvdSource.qvd(qvd)

Where Wildmatch(Fieldname,'91*');

[Deepak13]

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
];