SSN_FIND_IN Function

Description: This function is used during normalization to locate the Social Security Number (SSN) or Employer Identification Number (EIN) within a string. It should be used during inbound normalization and is paired with the SSN_FIND_OUT function for outbound normalization. SSN_FIND_IN returns 9 digits. All special editing characters such as dashes and spaces are removed. The formatted SSN or EIN should then be disguised using the preferred disguise technique. The SSN_FIND_IN function will search the source text for the known formats of SSN or EIN, but only the first SSN/EIN will be found. Any number of non-numeric characters can precede or follow the value; these characters can be immediately adjacent to the SSN/EIN and spaces are not required.

Parameters: String

• Source text: String containing the source value (SSN or EIN).

Return: String containing only the 9 digits of the SSN or EIN. If the source value does not contain an SSN or EIN, an empty string will be returned. Valid formats for SSN are 123456789, 123-45-6789, and 123 45 6789. Valid formats for EIN are 123456789, 12-3456789, and 12 3456789.

Syntax: SSN_FIND_IN(<source text>)

Example: Provide a normalization expression on the Comment data element to find the SSN and remove any formatting from the SSN before processing.