Formating job number

[Jays]

Hi,

first post and a newbe.

How should I go about defining a field with the following format:

123456/78

123456/7

- max nr. of characters is 9 including the slash.

- the slash comes always after 6 characters.

- may end with xxxxxx/[color:red]1 or with xxxxxx/[color:red]12

any pointers appreciated.

[CobaltSky]

first post and a newbe.

Hi Jays - and welcome.

How should I go about defining a field with the following format:

123456/78

123456/7

- max nr. of characters is 9 including the slash.

- the slash comes always after 6 characters.

- may end with xxxxxx/[color:red]1 or with xxxxxx/[color:red]12

I suggest you set the field as an auto-enter calculation (in the FIeld Options dialog), disable the option labelled "Do not replace existing value..." and enter a formula along the lines of:

Replace( Left( Substitute( YourField; "/"; ""); 9 ); 7; 0; "/")

There are various other ways the formula could be constructed to achieve a similar outcome, but the above is probably as good as any. :wink2:

[Jays]

Thanks alot that got me on the right track...