How can i generate next increment number for alphanumeric serial . i.e first cheractor is alphabet and next four cherectors are numeric. ( N1125 )
PM312
30
Junior Poster in Training
Recommended Answers
Jump to Post"N" & format$(val(right$(SerialNo,4))+1,"0000")
All 2 Replies
ChrisPadgham
113
Posting Whiz
"N" & format$(val(right$(SerialNo,4))+1,"0000")
debasisdas
580
Posting Genius
Featured Poster
1.try using ascii value of the character.
2.increment the number part till max value
3.increment the ascii value by 1(one) and repeat step-2
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.