Includes or excludes incoming fields by prefix, suffix, or pattern. You can use this option to select fields that you renamed earlier in the data flow. When you enter the field selection criteria details, you can select a prefix, suffix, or pattern, and define the rule to use.

When you select the prefix option or suffix option, you enter the text to use as the prefix or suffix. For example, to find all fields that start with the string, "Cust," enter

Cust

as the prefix.

When you select the pattern option, you can enter a regular expression or you can use a parameter for the pattern. The expression must use perl compatible regular expression syntax. For example, to find all fields that start with the strings "Cust" or "Addr," enter the pattern

Cust.*|Addr.*

. To find all fields that contain the string "Cust" or "CUST" anywhere in the field name, enter the pattern

.*Cust.*|.*CUST.*

. For more information about perl compatible regular expression syntax, see the help for the REG_EXTRACT function in

Function Reference

.