techwriterAR
MIS
I have a Crystal XI Report that uses a stored procedure to create a list of late shipments. The data is stored in MS SQL and the field is a character field. When I look at the field in my report, crystal calls it a string. What I need to do is remove the number, space and dash from the string field, but I cannot get TrimLeft, Trim, or Truncate to work.
The data looks like:
0 -Team Scheduling
2 -Inventory Counts
4 -Completed, External Delay
15-Non Plant Other
I need to return only:
Team Scheduling
Inventory Counts
Completed, External Delay
Non Plant Other
I have been working on this and searching for help for 3 hours without any luck and the report is due Wednesday by noon. I really hope someone can help me with this.
Thanks,
GJeffcoat
The data looks like:
0 -Team Scheduling
2 -Inventory Counts
4 -Completed, External Delay
15-Non Plant Other
I need to return only:
Team Scheduling
Inventory Counts
Completed, External Delay
Non Plant Other
I have been working on this and searching for help for 3 hours without any luck and the report is due Wednesday by noon. I really hope someone can help me with this.
Thanks,
GJeffcoat