This dialog appears when you are creating or editing an edit profile. If you have an edit defined (Partial Edit, Full Edit, or Always Edit), and select Extended Edit Options from the Edit Profile - Edit Type popup you see this dialog.
You can use this dialog to replace selected characters in a data field with other characters during editing. Replacement occurs immediately after the field is validated, either during or after scanning. You can define a maximum of four replacement operations per edit. The replacement operations occur in the same order as you define them in the list below.
For each replacement operation, you must define the range of valid responses to check (From/To), the type of replacement you want (leading, trailing, all, none), and the individual characters to use for replacement.
Enter in these two text boxes alphanumeric characters indicating the range of valid responses for the field. If this is a numeric field, a digit must be entered for each character in the field. Example: The field is four characters long. The values "4" and "12" should be entered as 0004 and 0012. (Enter the same number of characters as the defined length of the field.)
This area of the dialog box appears only for date fields. It is used with the Value Range entries for a full edit on a date field that is a six-character date with a two-character year (mm/dd/yy). This is NOT USED on an eight-character date with a four-character year. Valid values are 0-99. The number you enter determines the breaking point between the twentieth and twenty-first century.
The millennium cutoff value is used both during scanning and later during editing, and performs identically for both actions. During scanning range checking of dates is done to see if a field passes or fails the edit; if it fails, it is flagged for editing. During editing, the same range and rules are used again, so that dates can be corrected if needed.
NOTE: The millennium cutoff allows you to continue using your forms that have two-character year grids. We encourage you to plan to move to four-character year grids with your next re-print or new forms design. If you do not move to four-character year grids, you may have to keep resetting this millennium cutoff value each year, or as appropriate for your processing needs.
The millennium cutoff interacts with the From and To dates a bit differently, depending on if both From and To dates are actually entered, rather than being left blank, and on which year date is a higher number. The following describes all possible cases and is followed by a table showing examples of these cases. The cases are described below,.
When the From and To years:
Years equal to and greater than the millennium cutoff are considered the twentieth century, 19xx.
Years less than the millennium cutoff are considered the twenty-first century, 20xx.
From year is considered to be 19xx, and the To year is considered 20xx, and the millennium cutoff must equal the From year.
The From year is determined according to the first case listed above; years equal to and greater than the millennium cutoff are considered the twentieth century, 19xx. Years less than the millennium cutoff are considered the twenty-first century, 20xx.
The To year during scanning is calculated by subtracting one from the cutoff value. Once the year is calculated, the month and date used are 12/31/xx. When cutoff = 0, To date becomes 12/31/1999.
The From year during scanning is determined as the same year as the cutoff value, using the twentieth century; so the year is calculated as 19xx where xx = cutoff. The month and date used are 01/01/xx.
The To year is determined according to the first case listed above; years equal to and greater than the millennium cutoff are considered the twentieth century, 19xx. Years less than the millennium cutoff are considered the twenty-first century, 20xx.
|
Millennium cutoff value NOT ENTERED (left blank) |
||||||
|
No millennium cutoff entered, both dates entered |
||||||
|
Millennium Cutoff |
From year |
To year |
Results |
|||
|
Not used (blank) |
01/01/00 |
12/31/99 |
From year = 01/01/1900 To year = 12/31/1999 Valid if From is less than To Error if From is greater than To
|
|||
|
No millennium cutoff entered, From date entered, To date left blank |
||||||
|
Millennium Cutoff |
From year |
To year |
Results |
|||
|
Not used (blank) |
01/01/00 |
|
From year = 01/01/1900 To year is open ended, no calculations made. The date of 02/29/00 is assumed to be 02/29/1900, and is not accepted as valid.
|
|||
|
No millennium cutoff entered, To date entered, From date left blank |
||||||
|
Millennium Cutoff |
From year |
To year |
Results |
|||
|
Not used (blank) |
|
12/31/99 |
From year is open ended, no calculations made To year = 12/31/1999 The date of 02/29/00 is assumed to be 02/29/1900, and is not accepted as valid.
|
|||
|
No millennium cutoff entered, no From and no To date entered, all left blank This case only validates dates, no range checking is performed. The date of 02/29/00 is assumed to be 02/29/1900, and is not accepted as valid. |
||||||
|
Millennium Cutoff value ENTERED |
||||||
|
From year = To year, both dates entered |
||||||
|
Millennium Cutoff |
From |
To |
Results |
|||
|
50 |
mm/dd/60 |
mm/dd/60 |
Both are greater than cutoff From year = 1960 To year = 1960
|
|||
|
50 |
mm/dd/30 |
mm/dd/30 |
Both are less than the cutoff From year = 2030 To year = 2030
|
|||
|
From year is less than To year, both dates entered |
||||||
|
Millennium Cutoff |
From |
To |
Results |
|||
|
50 |
mm/dd/50 equal cutoff |
mm/dd/99 greater than cutoff |
From year =1950 To year = 1999
|
|||
|
50 |
mm/dd/00 less than the cutoff |
mm/dd/30 less than the cutoff |
From year = 2000 To year = 2030
|
|||
|
50 |
mm/dd/00 less than cutoff |
mm/dd/50 equal cutoff |
ERROR CONDITION From year = 2000 To year = 1950 Any To year equal to or greater than the cutoff produces an error message.
|
|||
|
From year is greater than To year, both dates entered Cutoff must equal the From year |
||||||
|
Cutoff 50 equal From |
From mm/dd/50 equal cutoff |
To mm/dd/30 |
Results From year = 1950 To year = 2030
|
|||
|
Only From date entered, To left blank |
||||||
|
Cutoff 30 |
From mm/dd/30 |
To calculated as cutoff - 1. |
Results From year = 1930 To year = 2029 To date = 12/31/2029 |
|||
|
30 |
mm/dd/00 |
calculated as cutoff - 1.
|
From year = 2000 To year = 2029 To date = 12/31/2029
|
|||
|
0 |
mm/dd/01 |
calculated as 12/31/1999 |
From year = 1901 To year = 1999 To date = 12/31/1999
|
|||
|
Only To date entered, From left blank |
||||||
|
Cutoff 50 |
From uses cutoff for year, with 19xx |
To mm/dd/99 |
Results From date = 01/01/1950 To year = 1999 |
|||
|
0 |
uses cutoff for year, with 19xx
|
mm/dd/99 |
From date = 01/01/1900 To year = 1999 |
|||
|
Only cutoff entered, From and To dates blank, not entered This validates dates within a 100 year range. The Cutoff value determines the break between 19xx and 20xx. |
||||||
|
Cutoff 50 |
From |
To |
Results 01/01/1950 - 12/31/2049 |
|||
|
0 |
|
|
01/01/1900 - 12/31/1999 |
|||
If you enter a value for the millennium cutoff, you receive a confirmation message when you use the OK button to exit the Extended Edit Options dialog. The confirmation message shows "This is the range of valid dates that will be used during scanning". The From and To dates using the millennium cutoff entered are translated into the appropriate 8-character date so you can confirm this is the range you wanted. Example message: "All dates from 02/01/1950 to 03/01/2030" "Is this an acceptable range?" Yes and No buttons are provided with the message. If you agree with the range and select Yes, you exit the Extended Edit Options dialog. If you do not want the range and select No, you return to the Extended Edit Options dialog where you can continue to enter values.
Use the fields in this group box to specify characters within the range to be replaced with other characters. The replacement character area is case sensitive. For example, if you enter a lower-case "m", only that character will be used, not the upper-case "M".
Replacement of characters during editing occurs for different records based on the edit mode specified in the Edit Options, as follows.
ScanTools character replacement during post-scan editing is performed in the following sequence:
For Scantron Use Only.
|
See Help on Help for additional information on using this help file. See Scantron Technical Support for additional information on technical support and training options. See the ScanTools Suite System Requirements for further details on hardware and software requirements. ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:
|
Scantron Corporation
Customer Service (forms, products, and services): 1-800-SCANTRON (722-6876) Technical Support: 1-800-445-3141 |
|
|
Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation. LINKS TO THIRD PARTY SITES This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators. |
||