Splitting Text Blocks 

Use

Sometimes, you may want to split a text block into multiple text block records based on a particular delimiter that appears in the text block, while duplicating all of the links to the original text block to each of the new text blocks.

When you use the Split Text Block command to split a text block by a delimiter, MDM does the following:

●      The text block is scanned for each occurrence of the delimiter.

●      Two or more Returns in a row (even when separated by white space) are removed and the text block split into two at that point.

●      For delimiters other than Return, two delimiters in a row includes the delimiter in the resulting text block instead of splitting at that point.

●      After splitting, all resulting text blocks are trimmed of leading and trailing white space.

●      The original text block is deleted after the split, unless referenced by a single-valued field, in which case the original text block is retained.

●      Multi-valued text block lookup fields are relinked to each split text block; single-valued fields are not affected by the split.

Procedure

To split each of one or more text blocks into multiple text block records:

       1.      In the Records pane, select all of the text blocks you want to split.

       2.      Right-click on one of the records and choose Split Text Block from the context menu, or choose Objects ® Split Text Block from the main menu.

       3.      Choose the delimiter by which you want to split each text block from the cascading menu:

○       |

○       \

○       Return

MDM splits the selected text block records and duplicates all text block lookup field values that reference any of the split text blocks.