Use this button to bring up the functions to handle strings
This button will allow the input of string based functions using the functions box and fields box (for cutting and board list rules). The formula must start with an "=" for the OK button to be active. When the dialog is closed and the String button has been selected the formula will be entered between the brackets with a prefix of STR e.g.With the String radio button selected the formula in the box is entered as
=[Part code]+[Material code]
When dialog is dismissed the following is entered in the program
=STR([Part code]+[Material code])
Functions available are as follows
+ add strings together
CELL Retrieve a value from a user defined table
INSTR Find the first instance of the search string within another string searching from left and return position
LEN Return the length of a string
LEFT Return the leftmost characters of a string up to and including the number given.
MID Return a string from the given start position with a length up to that given.
REPLACE Find a string and replace with another string.
RIGHT Return the rightmost characters of a string up to and including the number given.
RINSTR Find first instance of the search string within another string searching from right and return position.
TOLOWER Convert string to lower case.
TOUPPER Convert string to upper case.