ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

Description:

This command performs the opposite function of MergeRecords.

For each occurrence of Delimiter inside the FieldToParse, one record will be created. If the Delimiter parameter is blank, it will parse on commas, using typical comma-separated values (CSV) rules.

Given the following data:

Name | Interests
  1. Bob | Golf, Computers
  2. Sally | Horses, Rock Climbing

When executing: ParseRecords "Interests"
The following data will exist:

Name | Interests
  1. Bob | Golf
  2. Bob | Computers
  3. Sally | Horses
  4. Sally | Rock Climbing