Is there any way to Trim 3 characters off of a string in QR. ie. the first three characters of the Item Code from IC to use in a formula.

Hi Jim,

Absolutely, there are a number of ways of extracting specific characters from a string-formatted field in Quik Reports.

If you want only the first 3 characters of an item code, create a formula with syntax:
Item Number[1 to 3]
Make sure you use the square brackets for this to work.

If you want all characters except the first 3, it's a little trickier, but still can be done. The syntax for the formula is:
Item Number[4 to count(Item Number)]

You can even concatenate non-consecutive groups of characters from the same field, and insert other characters:
Item Number[1 to 2] + '/' + Item Number [4 to 7]

[This message has been edited by Softrak Support (edited 02-14-2000).]

Thank you ! I still could not find that in the help screens and my customer has the manual.