Skip to Content
0
Former Member
Mar 23, 2011 at 08:30 PM

How to separate a field separated by semi colons

326 Views

Hi - thought I would give this a try - any help is appreciated.

I have a field separated by semi colons - for example - prod1;prod2;prod3

In a cross tab I'm trying to show which products have a date in them and put an X there. My problem is if the field is like my example - it only shows once and instead of listing each single product as a product - it shows it as one like the example.

I would like to have a column for each product with and X under each.

I hope this is enough information.

Any help is much appreciated.

Thanks.

Bill