Select records having ABC NOT ABCD

sivakumar cv · New User Joined: 18 Sep 2007 Posts: 4 Location: US

Hi,

I am running a batch fileaid and facing the following problem.

There are records that consists of ABC only and also ABCDE. Now i want to select records that have only ABC but not ABCDE.

EXAMPLE FILE LAYOUT :

12345 ABC MNOP
2345 ABCDE KLMN

To select first record(but not second record) I am writing this :

IF=(7,EQ,C"ABC")

to extract only 1st row, BUT

I am getting both the rows as output. I want to select records that has only ABC not those which has ABCDE.

I appreciate your help.

Thanks
sivakumar.cv

dick scherrer · Posted: Mon Sep 24, 2007 9:13 pm

Hello,

Try "ABC ". . . . Place a space after the C. You might want a space before the A also.