Hi Howard,
BBEdit has a nice option to help rearrange columns in CSV files
<https://en.wikipedia.org/wiki/Comma-separated_values>:
BBEdit > menu Edit > Columns > Rearrange Columns…
Once the columns are in the desired order, if required you can remove the
commas with a find/replace.
HTH
Jean Jourdain
On Friday, February 4, 2022 at 2:50:37 AM UTC+1 ThePorgie wrote:
> 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/5008573f-a53d-41dc-94de-f913bc521595n%40googlegroups.com.
