Match

[smilingjohn]

Hi all,

I have a field name called Description wthin which i have content like

"Ispire I13019: grow: GDT Tes passpot verily gone"

there are more than 1000 id's , among this i want to take out only  "I13019" 

\How do we achieve this ? in qlikview ?

Wildmatch(description ,'I13*.')

i tried using this but its taking whole sentence .

[Chanty4u]

try simple

sam:

LOAD * INLINE [

    ID

    Ispire I13019: grow: GDT Tes passpot verily gone

];

result:

LOAD *,

KeepChar(ID,'I13019') as NewID

Resident sam;

[smilingjohn]

Thanks chanty ,

But i have many ID's will this work for all of them ?

[Chanty4u]

yes it will work .

[arulsettu]

try this

keepchar(id,'0123456789') as id

[smilingjohn]

Hi arul , its taking only numbers , But not "I " which is in the begning of the number

Please find the attachment

[Chanty4u · Accepted solution]

in future also if u  want to add any letters  just add to    I0123456789   and that will give you the result

KeepChar(Description,'I0123456789') as Id

[tamilarasu]

Hi,

If the description format for all the entries are same, you can try like below.

Purgechar(SubField(Description ,' ',2),':')  as ID

[arulsettu]

did u checked this?

KeepChar(Description,'I0123456789') as id

result will be

II13019

two 'II' will come

this will give u expected result

=PurgeChar(SubField(Description,' ',2),':')