Set day, month, and year according to format given
Hi,
Can anyone help on how do I set in bartender vbscript to follow as below setup?
Please advise.
Thanks!
-
You will need to get someone to help write a VB script routine to do this for you. I would suggest contacting your regional Seagull Sales team to see if they know anyone who could help with this or else their Professional Services team maybe able to do this.
0 -
Hi Ameer,
I don't know how to setup this in vbscript. But you can easily do it using the transforms tab and object values.
Year:
Drag the clock symbol and create a text that holds only the year (YYYY). Then create another text, but the type needs to be Object Value pointing at the year text, not embedded text.
In the Transforms tab, update the Truncation to "Discard 3 characters on left"
Month:
Similarly, create a text by dragging the clock or create a text and select type as Clock, change the data type custom pattern MM. Create another text and change to object value and point at the clock value.
On this text object, in the transforms tab, there should be a search and replace option. You can use the below xml to import for the months based on your requirements.
I basicially did it manually for 3 months, and then exported xml option. I gave that to ChatGPT and asked it to create for all months based on a screenshot of your table and imported the xml back in.
<Seagull_PCM_Database Ver="1.0">
<PCMCollection>
<PCMData Description="Jan">
<Action>3</Action>
<SearchText>01</SearchText>
<ReplaceText>1</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Feb">
<Action>3</Action>
<SearchText>02</SearchText>
<ReplaceText>2</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Mar">
<Action>3</Action>
<SearchText>03</SearchText>
<ReplaceText>3</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Apr">
<Action>3</Action>
<SearchText>04</SearchText>
<ReplaceText>4</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="May">
<Action>3</Action>
<SearchText>05</SearchText>
<ReplaceText>5</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Jun">
<Action>3</Action>
<SearchText>06</SearchText>
<ReplaceText>6</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Jul">
<Action>3</Action>
<SearchText>07</SearchText>
<ReplaceText>7</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Aug">
<Action>3</Action>
<SearchText>08</SearchText>
<ReplaceText>8</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Sep">
<Action>3</Action>
<SearchText>09</SearchText>
<ReplaceText>9</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Oct">
<Action>3</Action>
<SearchText>10</SearchText>
<ReplaceText>A</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Nov">
<Action>3</Action>
<SearchText>11</SearchText>
<ReplaceText>B</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
<PCMData Description="Dec">
<Action>3</Action>
<SearchText>12</SearchText>
<ReplaceText>C</ReplaceText>
<Encoding>3</Encoding>
<SearchMethod>1</SearchMethod>
<FirstOnly>False</FirstOnly>
</PCMData>
</PCMCollection>
</Seagull_PCM_Database>Similarly, you'd do it for days too. For the XXXX running days, similarly load a new text column and change the text to 0000 then in the transforms tab you'll have Serialization. Use the increment function and preview the sequence. when you want to print, select serial numbers instead of copies and that will serialise for you.
Hope this helps!
0
Please sign in to leave a comment.
Comments
2 comments