iNTERFACEWARE™ Inc.

Concatenating Repeating Fields

You can use Python to create a single field from a collection of repeating fields. To do this, create the following segment inbound script:

value = ''

for LineIndex in range(0, field.count_of_repeat()):
    if value <> "":
        value = value + ','
    value = value + field.repeat_field(LineIndex).value

This creates a single value from the collection of repeating fields. In the created value, the fields are separated by commas.

For example, this script can be used to convert a collection of repeated phone numbers:

(157)983-3296~(157)983-3297~(157)983-3298

After this script is executed, the field becomes:

(157)983-3296,(157)983-3297,(157)983-3298

You can now use Chameleon's Message Grammar window to map this field from the segment to your data table.