You are here: Integration > Integration Mapping category > Parse Normalize rules > Parse Normalize form - Completing the Infer tab

Parse Normalize form - Completing the Parse tab

  1. About
  2. New
  3. Parse
  4. History

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.

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.