If field of CUSTOMERS is multivalued and I want to exclude certain values from the listing how is that accomplished with RList?

Example…

LIST CUSTOMERS FLD2

Output

0001 Bob's Stores

            JimBo's Stores

            MaryEllens Stores

0002 Bob's Stores

            Gramma's Stores

I would like to

LIST CUSTOMERS IF FLD2 # "Bob]" FLD2

and get

0001 JimBo's Stores

            MaryEllens Stores

0002 Gramma's Stores

Given your select statement of…

LIST CUSTOMERS IF FLD2 # "Bob]" FLD2

use…

LIST CUSTOMERS LIMIT FLD2 # "Bob]" FLD2

Your request

---

LIST CUSTOMERS FLD2

Output

0001 Bob's Stores

JimBo's Stores

MaryEllens Stores

0002 Bob's Stores

Gramma's Stores

I would like to

LIST CUSTOMERS IF FLD2 # "Bob]" FLD2

and get

0001 JimBo's Stores

MaryEllens Stores

0002 Gramma's Stores

---

LIST CUSTOMERS WITH FLD2 # "Bob]"

LIMIT FLD2 NOT "Bob]"

FLD 2

This handles the Multivalued issue.

HTH

Don M.

Richard ..

It works better if you use the WITH clause in conjunction with the LIMIT clause. Otherwise, you'll get a lot of unwanted empty items.

LIST CUSTOMERS WITH FLD2 # "Bob]"

.. and then the LIMIT statement

LIMIT FLD2 NOT "Bob]"

FLD2

Don M.

That was what I was looking for, thank you both very much!!

View this thread on the forum...