Removing string

[deepakqlikview_123]

Hi all,

i want to remove string from column starting with DI99.

Can u plz suggest how to proceed for this.

Thanks,

[tresesco]

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.  

[preminqlik]

i think u need this

Load *,

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

from path;

[its_anandrjs]

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*');

Or

If it is first position then use

Load

*

From Location

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

[deepakqlikview_123]

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

[jagan]

Hi Deepak,

As far as I concern the condition is correct

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

instead of using Exists().

Regards,

Jagan.

[its_anandrjs]

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