Crystal newbie needs assistance. I have a field example customer name that may contain from 0-9 names. I have a formula that contains all the customer names which total about 50. The customer name also has a state assigned to it. I need the formula to extract each name and assign the state. Ex:
CustName - John, Joe, Debbie, Mike, Lisa
State - Michigan
on the next read of the record the contents may be
CustName - Joe, Lisa
State - Ohio
CustName and state changes and I need to list each. Thanks for any help.
CustName - John, Joe, Debbie, Mike, Lisa
State - Michigan
on the next read of the record the contents may be
CustName - Joe, Lisa
State - Ohio
CustName and state changes and I need to list each. Thanks for any help.