Find: ([^,\r]+), (.+) Replace: \2 \1 ([^,\r]+)//finds everything but a comma or return , //finds the comma space (.+)//finds everything after the comma space //Parentheses capture the two groups
\2 //Replace with found group 2 follow by a space \1//Replace with found group 1 On Thursday, February 3, 2022 at 8:12:54 PM UTC-5 Howard wrote: > *Here is a sample of the data I have in a column:* > Guerrero Jr., Vladimir > Perez, Salvador > Machado, Manny > Bichette, Bo > Goldschmidt, Paul > Devers, Rafael > Judge, Aaron > Freeman, Freddie > > *Desired output* > For each name, I need all the characters after each comma moved to the > start of the name followed by a space and the comma removed so that the > names appear this way: > Vladimir Guerrero Jr. > Salvador Perez > Manny Machado > Bo Bichette > Paul Goldschmidt > Rafael Devers > Aaron Judge > Freddie Freeman > > Thanks in advance for any help you can provide, > Howard > > -- This is the BBEdit Talk public discussion group. If you have a feature request or need technical support, please email "[email protected]" rather than posting here. Follow @bbedit on Twitter: <https://twitter.com/bbedit> --- You received this message because you are subscribed to the Google Groups "BBEdit Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/331e0090-fe50-4ee1-99c6-3f275c82f4f0n%40googlegroups.com.
