special group formula
I've got the need to create a group based on certain criteria. I have a series of varying item lists in my QuickBooks item table. They all have different names and have a certain structure to them. There are about 50 that have the following type name: F6112-PT-6001 where all the letters and number stay the same except for the last 4 which go up in increments of 1. Ex. F6112-PT-6002.
What I need is the ability to 1) search in the item name for the value F6112-PT and 2) if it exists strip the last 4 digits off the right, 6001 and use that as the group name.
I know how to do this type of stuff in Excel and SQL but not Crystal Reports. Any ideas?