|
|
 |
 |
|
| |
How do I print an incrementing series of numbers that re-starts after a certain point? |
|
| |
- CycleNumber(): Use CycleNumber() to cycle through a series of numbers. The format is: CycleNumber( first_number, last_number [, increment, copies] ) parameters: first_number (required) is the number printed on the first label in the series. last_number (required) is the last number printed in the cycle, before re-starting. Increment (optional) is how much to increment each number. If not specified, then 1 is used. However, if first_number is greater than last_number, then -1 is the default (i.e. decrement by 1). Copies (optional) specifies how many copies of each number to print before incrementing to the next number. The default value is 1.
Examples: CycleNumber ( 1, 3 ) will print: 1 2 3 1 2 3 1 2 3 ...CycleNumber ( 100, 110, 2 ) will print: 100 102 104 106 108 110 102 104 106 108 110 ...CycleNumber ( 10, 1 ) will print: 10 9 8 7 6 5 4 3 2 1 10 9 8 7 6 ...Cycle Number ( 1, 3, 1, 2 ) will print: 1 1 2 2 3 3 1 1 2 2 3 3 1 1 2 2 3 3 ...
- CycleChar(): Use CycleChar() to cycle through a series of characters, such as A to Z. The format is: CycleChar( first_character, last_character [, increment, copies] ) parameters: first_character (required) is the character printed on the first label in the series; this character should be surrounded by double quotes. last_character (required) is the last character printed in the cycle, before re-starting; this character should be surrounded by double quotes. Increment (optional) is how much to increment each character. If not specified, then 1 is used. However, if first_character is greater than last_character, then -1 is the default (i.e. decrement by 1). Copies (optional) specifies how many copies of each character to print before incrementing to the next character. The default value is 1.Examples: CycleCharacter ( "A", "C" ) will print: A B C A B C A B C... CycleCharacter ( "C", "A" ) will print: C B A C B A C B A ...CycleChar ( "A", "C", 1, 2 ) will print: A A B B C C A A B B C C …
- CycleString(): Use CycleString() to cycle through a series of words or phrases. The format is: CycleString( word_list ) parameters: word_list (required) is a list of words (separated by semi-colons) to be printed on a series of labels; this list should be surrounded by double quotes. Examples: CycleString ("Red;Blue;Green" ) will print: Red, Blue, Green, Red, Blue, Green, ... CycleString ( "Mon;Tue;Wed;Thu;Fri" ) will print: Mon, Tue, Wed, Thu, Fri, Mon, Tue, Wed, Thu, Fri, ...CycleString (A;B;C;D;E;F;G;H;J;K;L;M;N;P;Q;R;S;T;U;V;W;X;Y;Z" )this is an example for printing shelf-labels where we want to use all letters of the alphabet except O and I. NB: Any parameter used in ANY link function can be a literal value (e.g. "Red"), a field name (eg. SHIFTCODE) or another link function (e.g. CycleNumber(A, (mult(A,20) )
|
|
|
|
