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,

[alexandros17]

Load

....

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

...

From

....

[preminqlik]

Load *,

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

from path;

[deepakqlikview_123]

Hi all,

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

Thanks

[tresesco]

Try like:

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

[#6]

If you want to filter records this should work..

Load * From Table

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

Thanks,

Prabhu

[deepakqlikview_123]

Hi All,

I am using condition

not exists(DealerToDealerInvoiceCode,'*DI99*')

Seems it works f9.

Other condition not giving proper results.

Plz suggest.

Thanks

[tresesco]

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

[jagan]

Hi Deepak,

Try like this

LOAD

*

FROM Datasource

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

OR

LOAD

*

FROM Datasource

Where YourField like 'DI99*';

OR

LOAD

*

FROM Datasource

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

Regards,

Jagan.

[deepakqlikview_123]

Hi Tresco,

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

Thanks