You can rename fields individually or in bulk. When you rename fields individually, you select the fields you want to rename from a list of incoming fields. Then you specify the name for each of the selected fields.

When you rename in bulk, you can rename all fields by adding a prefix, suffix, or pattern. When you rename fields with a prefix or suffix, you enter the text string to use as a prefix or suffix. For example, you can specify to rename all fields as

FF_<field name>

.

When you rename fields by pattern, you enter a regular expression to represent the pattern or use a parameter to define the pattern in the task. You can create a simple expression to add a prefix or suffix to all field names or you can create an expression to replace a particular pattern with particular text.

To replace a pattern with text use a regular expression in the following syntax, where a forward slash separates the pattern to match and the text the pattern will be replaced with:

<pattern to match>/<replacement text>

The following table provides a few examples of using regular expressions when you rename fields in bulk:

Goal	Expression
Replace all occurrences of Inc with LLC.	Inc/LLC
Replace occurrences of Inc that occur at the end of a field name with LLC.	Inc$/LLC
Replace occurrences of Loc that occur at the beginning of a field name with Branch.	^Loc/Branch
Remove all occurrences of A/C.	A\/C(.*)/$1 When a character in a field name is a regular expression metacharacter, escape the character with a backslash to show that it is a literal. In this example, the forward slash is a metacharacter.
Add a prefix of FF and a suffix of _in to all fields.	FF_$0_in

The following image shows the

Configure Field Rules

dialog box with the Pattern bulk renaming option selected and a pattern specified to use:

Carefully construct field renaming rules to ensure that the rules do not introduce issues such as field name conflicts. If a field renaming rule causes field name conflicts, you can edit the rule.