Instr() ?

[SteveE]

I have a file delivered to us daily which has a "services" field with string contents like i.e. ,W07,W31,W63,W85,W88
Each of these W codes are proceeded by a "," I am trying to match each code in the string and create a text field with the meanings from my table of Codes and Descriptions using the Instr function but I can only pull the first code i.e. ,W07 Timed Delivery

What I would like to have is a function which will pull together the description values of ,W07,W31,W63,W85,W88 and consolidate them in a single string but how can I make instr() pickup on each code in the service string and return the values from the code table? if this possible.?

Any advice gratefully accepted
Steve

 

[Atomic Shrimp]

I think the code I posted here will do it, possibly with a little tweaking.

 

[SteveE]

Thanks Mike, I will take a look and see if I can amend to suit my needs
regards

steve