Am 1. Apr. 2019, 18:01 +0200 schrieb Lee Hinde <[email protected]>: > I have a CSV file where the 2nd column contains names that are being provided > all caps. I'd like to title case that column. > > First column is a number, always, so: > > 123,HUMAN RESOURCES,.... > 124,PUBLICATIONS,.... > > I'd like to convert that to: > > 123,Human Resources,.... > 124,Publications,.... > > Is that doable with RegEx? A quick google didn't provide anything I > understood. (low bar) The problem with this example data is, that you have a variable number of words that need to be „case-transformed“. Regular expressions are a bit of a head scratcher when it comes to variable occurrences of targets. If you wanted to „sentence-case“ that column it would be rather easy: search: ^(.+?),(.)(.+?), replace: \1,\u\2\L\3, Check BBEdit Help > Grep > Writing Replacement Patterns for the \u\U\l\L\E specifiers.
But that would give you "123,Human resources,….“ instead of "123,Human Resources,….“ You could add more search-replace operations searching for a space and a lowercase character but that is kind of unsatisfying. As „title case“ is not a grep option (at least not to my knowledge) you have two options: a) getting ambitious and thinking about scripting solution or b) walk down the pragmatic way. That would be: 1. Open the file in a spreadsheet app 2. Copy the second column to BBEdit 3. Text > Change Case > Title Case 4. Paste it back into the spreadsheet Also: the younger incarnations of BBEdit give you some support for working with columns. With the cursor in (any) column 2 of your text: Edit > Columns > New Document with Columns. As above: change the case and copy the text back using a vertical insertion selection and Columns > Rearrange Roland -- 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 to the group. Follow @bbedit on Twitter: <https://www.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 post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/bbedit.
