Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
akumar_c
Contributor

Find the series between multiple number

Hi,

I have some series like this

IWG10SAD0260000
IWG10SAD0280000
IWG10SAD0250000
IWG10SAD0050000
IWG10SAD0290000
IWG10SAD0060000
IWG12GAN0150000
IWG12BAR0010000
IWG12BEH0010000
IWG12BHA0030000
IWG12BET0050000
IWG12BET0030000
IWG12ADO0020000
IWG12BET0040000
IWG11VAJ0400000
IWG11VAJ0320000
IWG11VAJ0310000
IWG11VAJ0330000
IWG11VAJ0300000

Now I want only those number which start from IWG11 and IWG12.

How I can do it from edit script.

Thanks & Regards,

A Kumar

1 Solution

Accepted Solutions
MVP
MVP

Re: Find the series between multiple number

Maybe like

LOAD

FIELD

FROM TABLE where FIELD like 'IWG11*' or FIELD like 'IWG12*';

2 Replies
MVP
MVP

Re: Find the series between multiple number

Maybe like

LOAD

FIELD

FROM TABLE where FIELD like 'IWG11*' or FIELD like 'IWG12*';

Not applicable

Re: Find the series between multiple number

Hi,

You can try somthing like this,

Load

Data

from Sample.xls

where left(Data,5) = 'IWG11' OR left(Data,5) = 'IWG12';

Regards,

Alex

Community Browser