Dynamic Rename Tool

WeiXiang20010

I am trying to rename a few columns name:

First Name -> (Secondary) First Name

Last Name -> (Secondary) Last Name

First Name and Last Name -> No change

First -> No change

Last -> No change

I used this expression:
REGEX_Replace(
REGEX_Replace(
[_CurrentField_],
"\bFirst \w{4}\b", "(Secondary) First Name"
),
"\bLast \w{4}\b", "(Secondary) Last Name"
)

But I encounter a few issues:

1. There is no parentheses appearing on my output, it is just "Secondary First Name" and "Secondary Last Name"

2. There is change on "First Name and Last Name" to "Secondary First Name and Secondary Last Name"

Is there any other way to get what I plan to have?

First Name and Last Name.yxmd

flying008

Hi, @WeiXiang20010 

Maybe this is your want :

Spoiler

IIF(REGEX_Match([_CurrentField_], '(First|Last)\sName(\s\(.*)?'), '(Secondary) ' + REGEX_Replace([_CurrentField_], '(?<=Name)\s.*$', ''), [_CurrentField_])

(Secondary) First Name	(Secondary) Last Name
A	B
C	D
A	B
C	D