How to parse a value from a csv field in MS Access

[zirilan]

I need an Access function that will give me the xth value from a CSV field.

ie: ParseCSV([Keywords],1) will return the first value from the field [Keywords] for the current record,
ParseCSV([Keywords],2) will return the 2nd etc.

This would be used in a MS Access query to break our values in a CSV field into seperate fields.

My VB knowledge is light but give me a good example and I can make it work.

Thanks

 

[PHV]

Have a look at the Spli function.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886