Convert Data On Internal Code And Add A Serial Number

Legacy Poster

• February 26, 2015 12:01

Hi all,

 

I'm new on this forum and Software (BarTender 10.1 Automation),

 

We are trying replace our old software codesoft by the Bartender.

 

We have some Questions:

 

Our Serial number contains data, 5 numbers and suffix P (eg. BB00001P)

 

We use a convert table to convert data in letters:

 

2014 - A       January - A

2015 - B       February - B

2016 - C       March - C

2017 - D       ....

2018 - E       December = L

 

We can use bartender to do this?

 

We can save the serial number and for a different label type use the next last used serial number?

 

Many thanks. 

0

• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • March 09, 2015 14:22

  Break up the component parts of the value into separate data sources.  For the first, year code, use a VB script with something like the below expression:

   

  Chr(DatePart("yyyy",Date)-1949)

   

  The same sort of thing cane be done for the month:

   

  Chr(DatePart("m",Date)+64)

   

  For the serial number, using an embedded data source value, you can set it up under the "Transforms" tab serialization option.

  0
• 

  Legacy Poster

  ★ BarTender Hero ★

  • March 30, 2015 15:03

  Manymthanks for your help.

   

  Now i have two Reference data source and i need transform on only one and start serialization is possible? i need put this in Prefix?

   

  Many thanks.

  0
• 

  Ian Cummings

  Moderator

  ★ BarTender Hero ★

  • March 30, 2015 16:04

  Don't use the prefix transform, just create and use a separate data source for each component part.

  0

Please sign in to leave a comment.