Formatting text-number-text

[Edwik]

Hi all.

I have text field with mask:

X\XXXX-X
(x are digits), for example - 4\001-1, 4\001-2...

I need find field with text beginning 4\001 and max of last symbol. Last symbol +1, then again convert to text field. For example:
for example 4\001-1, 4\001-2,4\001-3 - must find 4\001-3 , then 3+1=4 and 4\001-4 format again to text.

Please, help me with formatting.
Thank You in advance.

 

[exotericist]

a high level problem, simply stated, with no code.

hmm, smells like homework to me.

so, what your tutor is trying to make you learn is normalisation.

http://en.wikipedia.org/wiki/Database_normalization

if you really need a hint, this is not one field but two and possibly three.

good luck.

 

[Bat17]

and what happens when you reach 4\001-9 +1?

peter

 

[Edwik]

4\001-9 +1? = 4\001-10

 

[Bat17]

I have text field with mask:

X\XXXX-X

but 4\001-10 will no longer fit your mask!

Anyway, I would recommend splitting this field as suggested by the exotericist.
you can join it up again to display it. You can then use dmax() + 1 to get your new number. There have been quite a few posts in the forum about managing custom id's

Peter

 

[Edwik]

Than You Exotericist, Bat17! I will try to learn normalization!