Views:

Product: LABEL MATRIX

Version: All Versions

 

1. Click the A button on the toolbar to add the new rearranged string.

2. On the Data tab, set the Origin drop down to Combination.

3. Once Combination has been selected, click on the Other button.

4. In the Expression Piece window, select String Functions and click OK.

5. Select the Mid function and click OK.

NOTE: A combination of the Left, Right, and Mid functions can be used to complete the rearrangement. Adding a + will tie the functions together.

NOTE: The expression that displays is Mid("Hello",3,10,"x"). This can be broken down to Mid(data, start, length, padwith). This will result in the string that is exactly length characters long. These characters come from the start of the data string and extend to the right. If the data string is shorter that the start + length - 1 character the necessary number of padwith characters are added to the right side of the result. If you do not wish for any padwith characters, this can be deleted from the function all together.

6. If the padwidth field is removed from the Mid function, there are no longer any extra "X" characters added. 

Now, the correct data string needs to be applied to this function. For this example, the Keyboard input named Serial Number will be rearranged.

7. Replace "Hello" by highlighting the text, including the "".
 
8. Click on the data string to replace and click the Use button.

                                          

9. In order to add another function to this, place a + after the closing parenthesis of the Mid function.
 
10. Click Other again.

11. Select the String Functions option.
 
12. This time, select the Right - Right Portion and click OK.

Below is what should display now. Right("Hello",3) is broken down to Right(data, length). This will result in the string that is exactly length characters long. These characters come from the right-most characters of the data string. The padwith discussed in the Mid function can also be applied to the Right function.

The Serial Number needs to replace "Hello" again:

13. Highlight "Hello", including the "".
 
14. Click on Serial Number and click Use.

                       

15. In order to add another function to this place a + after the closing parenthesis of the Mid function.
 
16. Click Other again.

17. Select the String Functions.
 
18. This time select the Left - Left Portion and click OK.

Below is what should display. Left("Hello",3) can be broken down to Left(data, length). This will result in the string that is exactly length characters long. These characters come from the left-most characters of the data string. The padwith discussed in the Mid function can also be applied to the Left function.

The Serial Number needs to replace "Hello" again.

19. Highlight Hello, including the "".
 
20. Click on Serial Number and then click Use.

                          

Now that the Serial Number has been rearranged it is ready to be placed on the label.

21. In the lower right hand corner, underneath the sample, click Place.

The resulting field will be placed on the label.

 

Keywords: concatenation, combine values, combine displayed value, alter value, label matrix customization