I am using crystal 11 and have a field in the database that is a string field and contains multiple data elements.
For ex: 10.25;0;0;4.5;0
The field contains freight and shipping charges each seperated by a ;. I need to parse the field and create 5 fields from it. I tried the spit command and unsuccessful. Any help is greatly appreaciated.
john
For ex: 10.25;0;0;4.5;0
The field contains freight and shipping charges each seperated by a ;. I need to parse the field and create 5 fields from it. I tried the spit command and unsuccessful. Any help is greatly appreaciated.
john