Need Help??

[paulwalker]

Hi All,

i have table..

Highlighted lines description, we are not using

how to exclude....??

here starting with Allowance and Memo need to exclude.....

Item                Description

AR100000          Test

AR100001          Advertising display

AR100002          Advertising abc

AR100003          Advertising flying

AR100004          Allowance - New Store

AR100005          Allowance -Audit

AR100006          Vendor-1

AR100007          Vendor-2

AR100008          Vendor-3

AR100009          Vendor-4

AR100010          Memo - abc

AR100011          Memo - xyz

Hope you understand ..

Thanks in Advance....

[#2]

So you want to get rid of the descriptions that are highlighted?

[Anonymous]

You could exclude in your load script with this WHERE

where not wildmatch( 'Allowance - New Store' , 'Allowance*' , 'Memo*' ', 'Test*')

[munna1317]

hi ,

LOAD

      Item,

     Description

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq)

Where not WildMatch(Description,'Allowance*',Memo*) ;

regards , harish