Splitting Customer Data Parser Input Lines - trillium_discovery - trillium_quality - 17.2

Trillium Control Center
Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:56:48.630530

The Splitting Lines function enables you to split lines during the parsing process. You would do this when two logical address lines are stored in one physical line; splitting them into two physical lines usually produces better results.

Note: If an address has ten lines, and a split line operation is performed, then the last line will be dropped.
Example
Line 1: WILLIAM MURPHY
Line 2: 60 ORCHARD RD WILMINGTON OH

The Parser would not be able to parse line 2 correctly because it contains both street and geographic information. If line 2 is split like the following, then the Parser would be able to parse the lines correctly.

Line 1: WILLIAM MURPHY
Line 2: 60 ORCHARD RD
Line 3: WILMINGTON OH

After you create Join/Split/Set rules, you can delete or arrange them in the desired execution order. The rules are processed from top to bottom in the order shown in the list.

When you delete Join/Split/Set rules, they are not removed entirely from the process. Deleting will simply remove the rule from the condition associated with it so that the rule will not be executed. A "deleted" rule still exists in the process and can be reused by using the Add > Existing option. If you want to remove transformation rules completely from the process, you must use the Remove Unused Operations option.

To split CDP input lines 

  1. From the Navigation or Project View, right-click the Customer Data Parser process and select Edit Process.
  2. Select the Options menu option.
  3. Click Advanced and select the Join/Split/Set option. The Join/Split/Set window opens, listing all previously defined operations.
  4. Right-click anywhere in the Join/Split/Set window and select Add > New > Split Lines. The Split Parser Input Lines window opens.
  5. In the Description field, enter a brief but meaningful description for the split lines operation. The description is used to identify the operation so you can refer to it in the Join/Split/Set window.
  6. From the drop-down lists, select the line numbers you are splitting (in the Split Line and To Line fields).
  7. For the Split Line field, enter the character string that must appear at the point where you want to split the line. This would be the last word you want to stay on this line.
  8. Select its type (Literal or Mask).
  9. Repeat steps 7 and 8 for the second line in the split operation, this time specifying the beginning value of the second line. This would be the first word of the section you are splitting.

    Example

    Line 1: WILLIAM MURPHY
    Line 2: 60 ORCHARD RD WILMINGTON OH

    In this example you would enter values as follows:

    Split Line: 2 Where end value is: RD Type: Literal
    To Line: 3 Where start value is: WILMINGTON Type: Literal

    The result would be as follows:

    Line 1: WILLIAM MURPHY
    Line 2: 60 ORCHARD RD
    Line 3: WILMINGTON OH
  10. If there is more than one match in the line for the values you specified in steps 7 through 9, select whether you want the split to occur on the first occurrence or the last occurrence.
  11. Click Finish. The newly created Split operation appears in the Join/Split/Set window, and will be executed when you run the CDP process.

     

Related tasks