Hi All,
I need a quick resolution to one of my problem.
I need to diplay the content of a single cell in a following way.

Input Format:

Vendor_ID Product

Vend1 Dept:1 Prod1 Item1 , Dept:1 Prod2 Item 2, Dept:2 Prod1 Item25
Vend2 Dept:4 Prod4 Item 1
Vend3 Dept:5 Prod1 Item1 , Dept:5 Prod2 Item 2, Dept:5 Prod6 Item2

Required Format:

Vendor_ID Product

Vend1 Dept: Multiple
Vend2 Dept:4 Prod4 Item 1
Vend3 Dept:Multiple

The Input Format section contains the information of the products that each vendor supplies.Number of products is seperated by a ',' as shown in the Input format. So my requirement is that if the vendor supplies more than 1 product then we need to display as "Dept"Multiple" else if Vendoe supplies only one product then display the product as it is there in the Product Column.

Can anybosy provide me the working code using CAR/Employee DB.

This message has been edited. Last edited by: Kerry,

Nice spec. You want I should give quote for doing work? I learn v quick, give good answer.

How much you pay?

Kofi

Prash,

Look up the GETTOK function. This is what I use for this type of requirement.
As for the Multiple, use common logic.

Prash,

Maybe this is too simple but...

  
DEFINE FILE ...
PRODUCT=IF PRODUCT CONTAINS ',' THEN 'Dept: Multiple' ELSE PRODUCT;
...
END