topic Re: Match in QlikView

Match

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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 .

Re: Match

Chanty4u — Thu, 25 Aug 2016 05:35:55 GMT

try simple

sam:

LOAD * INLINE [

Ispire I13019: grow: GDT Tes passpot verily gone

];

result:

LOAD *,

KeepChar(ID,'I13019') as NewID

Resident sam;

Re: Match

smilingjohn — Thu, 25 Aug 2016 05:39:36 GMT

Thanks chanty ,

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

Re: Match

Chanty4u — Thu, 25 Aug 2016 05:41:17 GMT

yes it will work .

Re: Match

arulsettu — Thu, 25 Aug 2016 05:42:26 GMT

try this

keepchar(id,'0123456789') as id

Re: Match

smilingjohn — Thu, 25 Aug 2016 05:48:10 GMT

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

Please find the attachment

Re: Match

Chanty4u — Thu, 25 Aug 2016 05:53:50 GMT

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

Re: Match

tamilarasu — Thu, 25 Aug 2016 05:57:21 GMT

Hi,

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

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

Re: Match

arulsettu — Thu, 25 Aug 2016 06:03:56 GMT

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),':')