Switch First and Last Names

[brelis]

I have a huge column of file names.
Washington, George
Lincoln, Abe
Smith, John
etc.

I want to change them in bulk to:
George Washington
Abe Lincoln
etc.

Can this be done with BRU?
Thank you,
Brelis

[Admin]

Hi,

There's a perfect example in the help file, where it swaps "Program Files" to "FIles Program". There's also other examples in this forum.


Jim

[brelis]

I think I understand the notation but where do I put the two expressions on the BRU screen? I find that putting them in Repl. (3) "Replace/With" does not do it, i.e. nothing happens. For my simple example in my initial letter, I am using:

"(.+),\s(.+)" to be replaced by "\2 \1"

Note that the " are not used in the expression on the BRU screen but only shown here for clarity.

Regards, brelis

[Admin]

In the Regular Expressions boxes. The very first ones on the screen left hand side, beneath the "tree").


Jim