Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?


Derek Caldwell

Former Member


You can use the In String function to search for the text, for example;

If InStr( "F6112-PT", {database field} ) > 0 then LEFT( {database field}, 8) else {database field}

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question