Processing entered values

For any data type, you can perform automatic processing of the entered value: remove white spaces, convert letters to uppercase or lowercase, automatically replace specific characters or text. To enable automatic processing of field values, on the Data tab of the field properties dialog box, click the Edit... button to the right of the AutoCorrect options field.

Select the desired automatic processing options.

If Apply AutoCorrect only once after recognition is selected, automatic processing is performed only once after the field value is recognized. Otherwise, automatic processing is performed each time the value in the field changes.

  • To perform automatic replacement of characters in the recognized field value, click the Edit... button to the right of the Replace characters field. In the dialog box that opens you can add characters for automatic replacement. Added values are sorted in alphabetical order. If the specified characters occur in the recognized field value, they will be replaced automatically. You can specify the following replacement parameters:
    1. In the Replace field, enter one or more characters to be replaced.
    2. In the With field enter a character or a string for replacement.
      Note: The string can apply if replacement is done in the whole text. For other options (Prefix, Suffix, Prefix and Suffix), only the first character applies.

Show me the example

  1. In the Where field choose whether to replace specified characters in prefix, suffix, both prefix and suffix or in the whole text.
    If Prefix is selected, all consecutive characters specified in the Replace list will be replaced starting from the beginning of the text. For Suffix, character replacement is done starting from the end of text.
    For example, if you choose to replace " B" with "%" and "AC" with "#" in prefix, the string "ABC ENTERTAC CORP" will be converted to "#%#%ENTERTAC CORP".

Details

  • To perform automatic replacement of the entire recognized field value or separate words in the field value, click the Edit... button to the right of the Replace text field.
    In the dialog box that opens you can add words and expressions for automatic replacement. To replace only whole fields, select Match entire field contents.
    If you enable the option Exact search, the program will search and replace the exact word or expression you have entered, or if you enable Fuzzy search, the program will search and replace a word or expression that is similar to the one you have entered. The number of allowable errors depends on the length of the word.
    Enable the option Match case for case-sensitive replacement words or expressions.
  • Choose one of the method of text letters conversion in the Change capitalization dropdown list:
    1. None without conversion;
    2. UPPER all letters will be changed to uppercase;
    3. lower all letters will be changed to lowercase;
    4. First upper the first letter will be uppercase and the remaining ones - lowercase.
  • Remove excess spaces enable this option if you want to remove whitespaces.

You can also use an autocorrection script for auto-replace: select the Use script option, click Edit... to open the script editor, and type in the code of the script.

11/10/2020 12:08:04 PM


Please leave your feedback about this article