Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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
try simple
sam:
LOAD * INLINE [
ID
Ispire I13019: grow: GDT Tes passpot verily gone
];
result:
LOAD *,
KeepChar(ID,'I13019') as NewID
Resident sam;
Thanks chanty ,
But i have many ID's will this work for all of them ?
yes it will work .
try this
keepchar(id,'0123456789') as id
Hi arul , its taking only numbers , But not "I " which is in the begning of the number
Please find the attachment
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
Hi,
If the description format for all the entries are same, you can try like below.
Purgechar(SubField(Description ,' ',2),':') as ID
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),':')