Re-Number Command

Changes the point identifiers in the currently open data base.

The Maintenance/Change Identifiers command is selected from the Plan View Utilities task.

Change Identifiers dialog box

Item	Used to
Apply Numeric Part	Nominate that you wish apply a numeric offset to renumber the numeric part of the identifiers, or that you wish to compress the numeric part. Example: Compress option OFF Points currently in data base:- A11, A12, A18, A19 Range: A11..A19 Offset: 6 Result: A17, A18, A24, A25 Example: Compress option ON Points currently in data base:- A11, A12, A18, A19 Range: A11..A19 Result: A11, A12, A13, A14
Renumber	Nominate that you wish to renumber the numeric part of the identifiers. This can also be used to add, remove or modify alpha-numeric prefixes or suffixes at the same time. Please Note: The compress option is always checked for this option. Example: Points currently in data base:- A17, A18, A24, A25 Range: A17..A25 Start: 50 Result: 50, 51, 52, 53 Example: Points currently in data base:- A17, A18, A24, A25 Range: A17..A25 Start: A50 Result: A50, A51, A52, A53 Example: Points currently in data base:- A17, A18, A24, A25 Range:A17..A25 Start: B50C Result: B50C, B51C, B52C, B53C
Add Id Prefix	Nominate that you wish to add an alpha-numeric prefix to the start of the identifiers. Example: Points currently in data base:- 17, 18, 24, 25 Range: 17..25 Prefix: A1 Result: A117, A118, A124, A125
Remove Id Prefix	Nominate that you wish to remove an alpha-numeric prefix from the start of the identifiers. Example: Points currently in data base:- A117, A118, A124, A125 Range: A117..A125 Prefix: A12 Result: A117, A118, 4, 5
Add Id Suffix	Nominate that you wish to add an alpha-numeric suffix to the end of the identifiers. Example: Points currently in data base:- 17, 18, 24, 25 Range: 17..25 Suffix: 3B Result: 173B, 183B, 243B, 253B
Remove Id Suffix	Nominate that you wish to remove an alpha-numeric suffix from the end of the identifiers. Example: Points currently in data base:- 17B, 18B, 24B, 27B Range: 17B..27B Suffix: 7B Result: 1, 18B, 24B, 2
Range:	Key in a range of identifiers to be changed. Use two dots as the separator. e.g. 1..100 indicates a range of 1 to 100. The range entered must have the same prefix and the same suffix. Please Note: If no range is entered then all identifiers will be changed.
Prefix:	Key in an alpha-numeric prefix to be added to or removed from the front of all identifiers in the selected range. This field is only available if the Add Id Prefix or Remove Id Prefix radio button is active.
Offset:	Key in a numeric increment to be added to the numeric part of the selected range. The increment may be negative but an increment that would result in negative identifiers is not allowed. This field is only available if the Numeric Part radio button is active. Any gaps in the numbering will be retained. This field may not be accessed if the compress option is active.
Suffix:	Key in an alpha-numeric suffix to be added to or removed from the end of all identifiers in the selected range. This field is only available if the Add Id Suffix or Remove Id Suffix radio button is active.
Start:	Key in an alpha-numeric that will totally renumber/replace the existing identifiers. This option compresses the identifiers, with the new identifiers starting from what is entered in this field. This field is only available if the Renumber radio button is active. Please Note: If this field is left empty, a default of 1 will be used.
Compress:	Activate the compression option. This option is available if the Apply Numeric Part radio button is active. Selecting OK with this option active will alter the numeric part by removing any gaps starting from the beginning of the range. Activating this check box with the Apply Numeric Part will deactivate the Increment field. This option is always checked when the Renumber radio button is active.
Change:	Change the point identifiers according to the options selected.
Cancel:	Close the dialog box without changing the point identifiers.
Please Note:	During the process a warning dialog may appear that reports on conflicted or duplicate identifiers. The user will have the choice of skipping the point, stopping the process, converting to a non unique database, or cancelling the process. At the end of the process a report editor may appear. It will list all conflicted and duplicated point identifiers that occurred during the process. This report may be saved for future reference. After the report window is closed a dialog will appear that gives the user the chance to continue/finalise the process or cancel the process.
Prefix, Suffix and Numeric Parts Rules:	Numeric part:- The numeric part of the identifier is the number furthest to the right. Prefix:- The alpha-numeric part to the left of the numeric part. Suffix:- The alpha-numeric part to the right of the numeric part. Example: Identifier:- ABC123PQR456XYZ Prefix:- ABC123PQR Numeric:- 456 Suffix:- XYZ.
Range Rules:	The Prefix and Suffix parts are treated as alpha-numeric. When alpha-numeric values are sorted, they are sorted by the first character then the second etc. Also the sort order is 0-9 before A-Z Example: Points currently in data base:- 1/3, 2/3, 100/3, A/3 2B/3, XYZ/3 Sort Order: 1/3, 100/3, 2/3, 2B/3, A/3, XYZ/3 In the above example the 3 is the numeric part, as it is the numeric part of the identifier furthest to the right. Everything else up to and including the / is the prefix of the identifier. Hence an identifier range of 1/3..2/3 will include 1/3, 100/3, 2/3 & 2B/3 as each of these satisfies the criteria of sharing the 3 numeric part and goes from 1 to 2 inclusive.