Parse Normalize form - Completing the Parse tab

Use the Parse tab to identify the normal form of a text value and to list the values that the normal form will replace.

After you save the Parse Normalize form, click the Run toolbar button to test the rule. Complete a pop-up dialog by pasting or typing in source text, Then execute the rule to see the result.

Note: For Parse Normalize rules created and last saved in releases before PRPC Version 5.4, the layout of this tab differs slightly, but the rules operate as expected. If you update or copy these older rules, the tab changes to the previous format.

Text replacement

Field Description
Enter zero or more rows to define search-and-replace operations on the source text value. Order is significant.
Look For Enter a text value to search for in the source text string. To include one or more leading or trailing space characters, surround the search text string with double quotes. (Use only spaces and characters with printable glyphs. You cannot use \z notation in this field.)
Whole Word Select if substitution of the normal form for a text entry on this list is to occur only at word boundaries, including white space (tabs, spaces), line termination, or string termination.

For example, if the list contains lack and the source text contains blackstone, substitution does not occur if you selected this check box.

Ignore Case Select to match text in the source string with list entries regardless of case, so that Here matches HERE and hErE.
Replace with Enter a replacement value for a match. To include one or more leading or trailing space characters, surround the search text string with double quotes. (Use only spaces and characters with printable glyphs. You cannot use \z notation in this field.)

Text cleanup

Optionally, specify additional operations to be applied to the result of the search-and-replacement operations defined in the above array.

Field Description
Text Cleanup  
Leading Spaces Select to delete any leading space characters from the result.
Trailing Spaces Select to delete any trailing space characters from the result.
Spaces Between Words Select to delete all space characters except leading and training spaces.
Tabs, Newlines, Carriage Returns Select to delete tab characters, newline characters, and carriage return characters.
Numeric Digits Select to delete all digit characters 0 to 9.
All Punctuation Select to delete punctuation characters, such as a comma, period, or hyphen. (All characters other than letters, numbers, and white space are treated as punctuation.)
Case Conversion  
Conversion Options Select:
  • Don't Convert Case — No case conversion changes.
  • Uppercase All Text
  • Lowercase All Text
  • Convert to Proper Case — Convert the first letter of each word to uppercase and other consecutive letters to lowercase.