Ignore fields

[Anonymous]

Hi ,

I want to ignore sold to party starting from "004" and "Y". Please help me with the script. Excel file enclosed.

SOLD TO PARTY	SALES DISTRICT	NET VALUE	GROSS VALUE
0000125927	0178	11,248.12	40,171.88
0000125927	0178	24,500.00	87,500.00
0000300118	A19	0.00	2,47,418.00
0010000003	0.00	25,452.00
0010000003	0.00	25,593.00
0040000153		0.00	2,520.00
0040000153		0.00	3,150.00
0040000153		0.00	2,520.00
Y3106	0747	0.00	0.00

Thanks, Rahul.

[sunny_talwar]

May be use WildMatch

Where Not WildMatch([SOLD TO PARTY], '004*', 'Y*');

[eduardo_dimperio]

Hi Rahul

Load

*

FROM YOURQVD

WHERE

LEFT([SOLD TO PARTY],3) <>'004' AND LEFT ([SOLD TO PARTY],1) <>'Y';

[Anonymous]

Thanks! it solved my purpose.

[oknotsen]

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

[eduardo_dimperio]

You're Welcome, please close the question choosing a right question

[oknotsen]

Eduardo DImperio wrote:

choosing a right question

Answer