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).]