Skip to main content
Solved

Creating a personal ID as 3 letters and 6 numbers


canerakin
Contributor
Forum|alt.badge.img+5

Hey guys,

I checked this post below:

https://knowledge.safe.com/questions/56005/create-a-personalised-id-with-letter-and-number.html

it helped me, but I need to use 3 letters (I will specify) and 6 numbers. I used counter to generate the numbers and used string replacer to add the letters I want. However, I need to add zeros between letters and numbers. I need to something like:

ABC000001

ABC000002

...

...

...

ABC000011

...

ABC012341

Best answer by ebygomm

Take a look at the stringpadder to add the extra zeros to the left of your numbers and then join your letters to the numbers

View original
Did this help you find an answer to your question?

4 replies

erik_jan
Contributor
Forum|alt.badge.img+17
  • Contributor
  • November 2, 2017

After the Counter you can use the StringPadder to add zero's before the number to get it to 6 characters. The Use the StringConcatenator to add the number to the 3 letters for the desired output..


ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • Best Answer
  • November 2, 2017

Take a look at the stringpadder to add the extra zeros to the left of your numbers and then join your letters to the numbers


canerakin
Contributor
Forum|alt.badge.img+5
  • Author
  • Contributor
  • November 2, 2017

Thank you guys,

have a good day!


gio
Contributor
Forum|alt.badge.img+15
  • Contributor
  • November 2, 2017

you can just use stringpadder on the number part.

length 6, pad 0 left.

Then concatenate with your suplied letters.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings