topic Re: Removing string in QlikView

Removing string

deepakqlikview_123 — Fri, 23 May 2014 08:04:22 GMT

Hi all,

i want to remove string from column starting with DI99.

Can u plz suggest how to proceed for this.

Thanks,

Re: Removing string

alexandros17 — Fri, 23 May 2014 08:08:46 GMT

Load

....

If(left(MyField,4)='DI99',Mid(MyField,5),MyField) as myfield

...

From

....

Re: Removing string

preminqlik — Fri, 23 May 2014 08:11:46 GMT

Load *,

if(wildmatch(field,'DI99*'),keepchar(field,'0123456789'),field) as Newfield

from path;

Re: Removing string

deepakqlikview_123 — Fri, 23 May 2014 08:22:49 GMT

Hi all,

I want to apply this condition in where statement after load .

Thanks

Re: Removing string

tresB — Fri, 23 May 2014 08:25:19 GMT

Try like:

Where Not WildMatch(YourField, 'DI99*');

Re: Removing string

Fri, 23 May 2014 08:29:20 GMT

If you want to filter records this should work..

Load * From Table

Where wildmatch(Column,'*DI99*') <> 1;

Thanks,

Prabhu

Re: Removing string

deepakqlikview_123 — Fri, 23 May 2014 08:38:23 GMT

Hi All,

I am using condition

not exists(DealerToDealerInvoiceCode,'*DI99*')

Seems it works f9.

Other condition not giving proper results.

Plz suggest.

Thanks

Re: Removing string

tresB — Fri, 23 May 2014 08:43:44 GMT

If your first post was what you wanted, this exists() would not be the right one. Be sure that you are getting right output.

Re: Removing string

jagan — Fri, 23 May 2014 08:57:39 GMT

Hi Deepak,

Try like this

LOAD

FROM Datasource

Where Not WildMatch(YourField, 'DI99*');

LOAD

FROM Datasource

Where YourField like 'DI99*';

LOAD

FROM Datasource

Where Left(YourField, 4) = 'DI99';

Regards,

Jagan.

Re: Removing string

deepakqlikview_123 — Fri, 23 May 2014 09:04:30 GMT

Hi Tresco,

I do not want those rows having string DI99 in 1 perticular column.

Thanks

Re: Removing string

tresB — Fri, 23 May 2014 09:10:47 GMT

Load

field

From <> Where not WildMatch(field, 'DI99*') ;

Note:

'DI99*' - removes rows that STARTS with 'DI99'

'*DI99*' - removes rows that have 'DI99' anywhere in the string.

So use the one you need. If you have doubt, try to post your sample qvw.

Re: Removing string

preminqlik — Fri, 23 May 2014 09:16:48 GMT

i think u need this

Load *,

if(wildmatch(field,'DI99*'),null(),field) as Newfield

from path;

Re: Removing string

its_anandrjs — Fri, 23 May 2014 09:27:52 GMT

It seems work fine for you but if you want to exclude that word which contains string DI99 in any position then you have to use

Load

From Location

Where Not Wildmatch(DealerToDealerInvoiceCode,'*DI99*');

If it is first position then use

Load

From Location

Where Not Wildmatch(DealerToDealerInvoiceCode,'DI99*');

Re: Removing string

deepakqlikview_123 — Fri, 23 May 2014 10:31:23 GMT

Hi Anand,

Thanks for reply.

I f I use where not exists(DealerToDealerInvoiceDate,'*DI99*') instead of Where Not Wildmatch(DealerToDealerInvoiceCode,'*DI99*');will it gives me same result.

Which will be better in which case .

Can u plz suggest,

Thanks

Re: Removing string

jagan — Fri, 23 May 2014 10:54:00 GMT

Hi Deepak,

As far as I concern the condition is correct

Where Not Wildmatch(DealerToDealerInvoiceCode,'*DI99*');

instead of using Exists().

Regards,

Jagan.

Re: Removing string

its_anandrjs — Fri, 23 May 2014 11:15:18 GMT

Hi Deepak,

The right script will be Wildmatch(DealerToDealerInvoiceCode,'*DI99*'); exists are used where we need to exclude or include some key values from the fields here is condition where from each row we have to find the string D199 and exclude them.

Regards