How to generate noSeries with A,B,C....,a,b,c...

justeryu

hello guys ,

How to generate noSeries with A,B,C....Z,a,b,c...,z

ex:
SO No.
_______________
SO123A
SO123B
SO123C
.....
SO123Z
SO123a
SO123b
.....
SO123z

Appreciate anyone who can help me!

JY

thankesh

justeryu wrote:

How to generate noSeries with A,B,C....Z,a,b,c...,z

ex:
SO No.
_______________
SO123A
SO123B
SO123C
.....
SO123Z
SO123a
SO123b
.....
SO123z

Hi Justeryu,


May I know why do you need this kind of no. series? In NAV, we can do increment only by integer. So, I do not have any idea about incrementing via char (alphabets). And increment should be done by using integers alone.

What would you do if all the 26 chars (alphabets) i.e) SO123z has been finished? How would you do the next level of increment after SO123z? [-X

justeryu

thankesh wrote:

justeryu wrote:

How to generate noSeries with A,B,C....Z,a,b,c...,z

ex:
SO No.
_______________
SO123A
SO123B
SO123C
.....
SO123Z
SO123a
SO123b
.....
SO123z

Hi Justeryu,


May I know why do you need this kind of no. series? In NAV, we can do increment only by integer. So, I do not have any idea about incrementing via char (alphabets). And increment should be done by using integers alone.

What would you do if all the 26 chars (alphabets) i.e) SO123z has been finished? How would you do the next level of increment after SO123z? [-X

Well, it will be back to whatever+A again!
all i need is a group with 52 items starting from whatever+A to whatever+z.
Thanks,thankesh.

JY

ufuk

Increment is done only in numeric part. Possible solutions are using relationships (not seem feasible in your case) or modification in code. (really worth it?)

Meanwhile I didn't understand exactly what you really want by saying grouping items? If you want to group a total of 52 Item use a structure starting with A01 then ends with A56, B01..B56 etc...

Savatage

perhaps you can play this this:
viewtopic.php?f=5&t=14078

you'll have to add something like

noseries := noseries+t;

test & good luck

justeryu

Savatage wrote:

perhaps you can play this this:
viewtopic.php?f=5&t=14078

you'll have to add something like

noseries := noseries+t;

test & good luck

Hi,Savatage

It solved my question!

Thank you so much.

JY