Concatenate values
I need to concatenate a serialized value on the label with a field from the database. Are there VB script examples I can look at to achieve this?
-
You may not need to use VB for this, have you tried adding a new sub-string to your field, such as below where I have added a date field to a an Embedded Data text field:
0 -
Hi Peter - Thank you for the feedback. Below is what I have ended up with, I need to have the fields highlighted in yellow as one string with the ";" to separate them. All but the Tag Id are on a database (excel) and I have formatted them ready, I just need to have the Tag Id and the ; delimiter in front of them. I followed the wizard and get the string outlined in red. The Tad Id is a unique serialized number generated at print time.
0 -
Me again! Since writing the previous response I managed to get the tag id portion correct. I just need to get the delimited to be ; (apostrophe), I got an error when I tried.
0 -
If the other fields come from the database then you can reference them directly as a Database type substring and then could add a Transforms>Suffix>; to the end of them. For the Tag field as that is not a database field I would suggest you make a note of the Text number of the Tag field and then link the concatenated substring as a Object Value item and link that to the tag text number (text 9 in my image below).
Note: As I am using Named Data Sources for the other fields I have added a separate string from the ; rather than adding as a suffix as if I did it would become part of the main text field too.
0 -
Thank you for all the tips, mission accomplished!
0
Please sign in to leave a comment.
Comments
5 comments