topic Re: position of subfield in a string qlikview in App Development

position of subfield in a string qlikview

Deepak13 — Sun, 25 Sep 2022 18:02:26 GMT

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

Re: position of subfield in a string qlikview

BrunPierre — Sun, 25 Sep 2022 19:35:21 GMT

As below

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

Re: position of subfield in a string qlikview

MarcoWedel — Sun, 25 Sep 2022 20:48:54 GMT

In the script?

"All numbers" means one record per number?

Re: position of subfield in a string qlikview

Deepak13 — Mon, 26 Sep 2022 03:36:44 GMT

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

Gdhjsj hdhjdka 123 9163738

Re: position of subfield in a string qlikview

vinieme12 — Mon, 26 Sep 2022 04:21:36 GMT

as below

load *

From SomeQvdSource.qvd(qvd)

Where Wildmatch(Fieldname,'91*');

Re: position of subfield in a string qlikview

Deepak13 — Mon, 26 Sep 2022 04:46:06 GMT

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

Input :- shhdhd gdhsjs 53627 9163637 91737337

Output :- 9163637,91737337

Re: position of subfield in a string qlikview

MayilVahanan — Mon, 26 Sep 2022 05:35:51 GMT

Try like below

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