Syntax - @WRAP(Text,NumCharacters1,NumCharacters2)
Parameters :
Text - Any text or alpha-numeric field.
NumCharacters - Any integer.
Action:
The @WRAP function is used for Word Wrapping. It is the same as the @Mid function except that the starting points and ending point (entered as number of characters to include) are automatically moved back to the first space character (if there is one).
Example:
Create a Variable
Name: DescriptionTop
Formula: @WRAP([INV:Description],1,20)
Create a second Variable
Name: DescriptionBottom
Formula: @WRAP([INV:Description],20,40)
Add the variables to the Report or Label form.
On one line, use the variable DescriptionTop.
On a line below it, use the second variable DescriptionBottom.
Result:
If the Description was "Gift Basket with a Bottle of Wine", then the result is:
Gift Basket with a
Bottle of Wine
Result Explained:
DescriptionTop - Prints the Left Side of the Description, starting with the 1st character through the 20th character, and moves back to the first space character found.
DescriptionBottom - Prints the Right Side of the Description, starting with the 20th character through the 40th character, and moves back to the first space character found.
See:
Filters and Formula Functions - All
Edit Variable Screen
Variables in SubTotals and Grand Totals
Filters and Formula Operators
Filters - Transaction Types