Profile number substitutions are used on machines that require a special format (e.g. due to limited character length, special characters and letters).

Enter profile numbers

  • On the home screen, click "CNC" and select "CNC company standard":
  • Right-click the machine for which you want to adjust the profile numbers.
  • In the context menu, select "Substitutions" > "Profile numbers":
  • In the next window, click "Add" to enter a new profile number substitution:
  • Select a supplier.
  • Enter the variable for the original profile number and define the substitution rule. The following use cases will show you how to proceed.
  • Click the green check mark at the end of the selected line or press the Enter key to confirm the selection.

Use cases

In order to shorten complex profile numbers, they must be divided into sections. The individual sections contain letters, numbers, special characters and spaces. These are defined by the following variables:

Variable Designation Description
! The exclamation mark in front of the variables and substitutions is mandatory to initiate the substitution process!
– D no digit a letter
– d digit a number
– s whitespace a space
– w word character a letter, number, or underscore
– W no word character a character that is not a letter, a number, or an underscore

Use case 1: Change first digit

  • Under "Original", enter the common initial digits of the profile numbers that you want to change in the further process. Replace the remaining number with an asterisk symbol (*). This selects all profile numbers for change that begin with the entered digits before the asterisk.
  • Under "Substitution", enter the new first digit, the second digit of the original number, and an asterisk symbol to change the first digit of the respective profile numbers.

Example: ORG 1926514 (Original)

  • Original: 19*
  • Substitution: 99*

-> New, modified profile number: ORG 9926514

Use case 2: Remove first digit

  • Under "Original", enter the common initial digits of the profile numbers that you want to change in the further process. Replace the remaining number with an asterisk symbol (*). This selects all profile numbers for change that begin with the entered digits before the asterisk.
  • Under "Substitution", enter the second digit of the original number and an asterisk symbol to remove the first digit of the respective profile numbers.

Example: ORG 1926514 (Original)

  • Original: 19*
  • Substitution: 9*

-> New, shortened profile number: ORG 926514

More examples

Example: ORG 605685.C4
The profile number is divided into the following sections:

Section Description Profile number Variable Substitution
1 Supplier code ORG (\w+) $1
2 Space  (\s+) $2
3 Digits 605685  (\d+) $3
4 Full stop .  (\W+) $4
5 Letter C  (\w+) $5
6 Last digit 4 (\d+) $6

Use case 3: Remove full stop

Example: ORG 605685.C4 (Original / 13 characters)

  • Original: !(\w+)(\s+)(\d+)(\W+)(\w+)(\d+)
  • Substitution: !$1$2$3$5$6 (omitting the substitution "$4")

-> New, modified profile number: ORG 605685C4 (Substitution / 12 characters)

Use case 4: Remove space

Example: ORG 605685.C4 (Original / 13 characters)

  • Original: !(\w+)(\s+)(\d+)(\W+)(\w+)(\d+)
  • Substitution: !$1$3$4$5$6 (omitting the substitution "$2")

-> New, modified profile number: ORG605685. C4 (Substitution / 12 characters)

Use case 5: Remove letter “C”

Example: ORG 605685.C4 (Original / 13 characters)

  • Original: !(\w+)(\s+)(\d+)(\W+)(\w+)(\d+)
  • Substitution: !$1$2$3$4$6 (omitting the substitution "$5")

-> New, modified profile number: ORG 605685.4 (Substitution / 12 characters)

Use case 6: Remove supplier code and full stop

Example: ORG 605685.C4 (Original / 13 characters)

  • Original: !(\w+)(\s+)(\d+)(\W+)(\w+)(\d+)
  • Substitution: !$2$3$5$6 (omitting the substitutions "$1" and "$4")

-> New, modified profile number: 605685C4 (Substitution / 9 characters)

Use case 7: Remove supplier code and space

Example: ORG 605685.C4 (Original / 13 characters)

  • Original: !(\w+)(\s+)(\d+)(\W+)(\w+)(\d+)
  • Substitution: !$3$4$5$6 (omitting the substitutions "$1" and "$2")

-> New, modified profile number: 605685.C4 (Substitution / 9 characters)

Use case 8: Remove supplier code, space and full stop

Example: ORG 605685.C4 (Original / 13 characters)

  • Original: !(\w+)(\s+)(\d+)(\W+)(\w+)(\d+)
  • Substitution: !$3$5$6 (omitting the substitutions "$1", "$2" and "$4")

-> New, modified profile number: 605685C4 (Substitution / 8 characters)

Use case 9: Remove supplier code, space, full stop and letter “C”

Example: ORG 605685.C4 (Original / 13 characters)

  • Original: !(\w+)(\s+)(\d+)(\W+)(\w+)(\d+)
  • Substitution: !$3$6 (omitting the substitutions "$1", "$2", "$4" and "$5")

-> New, modified profile number: 6056854 (Substitution / 7 characters)

Use case 10: Remove the first digit from a substitution previously performed

Some older machines can read a maximum of 6 characters of a profile number. For these machines, profile numbers that have already been shortened must be shortened again by further simple substitutions (see use case 2).

  • Perform the complex substitution according to use case 9 (substitution 1).
  • Enter another substitution under the complex substitution (substitution 2):

Example: Already shortened profile number "6056854" (7 characters) from use case 9

  • Original: 60*
  • Substitution: 0*

-> New, modified profile number: 056854 (Substitution 2 / 6 characters)

Use case 11: Change the first digit from a substitution previously performed

If the profile number should not start with a 0, a 3rd substitution can be performed, which converts the 0 into another digit (see use case 1).

  • Perform the complex substitution according to use case 9 (substitution 1).
  • Under the complex substitution, enter another substitution according to use case 10 (substitution 2).
  • Perform another substitution according to use case 1 to replace the first digit (substitution 3):

Example: Profile number shortened twice "056854" (6 characters) from use case 10

  • Original: 0*
  • Substitution: 9*

-> New, modified profile number: 956854 (Substitution 3 / 6 characters)