Correction to *Sample Output*. It should look like this:
*Sample Output* *Column 1 Column 2* 9/4/57 9/3/57 9/2/57 2 On Tuesday, 31 May 2022 at 9:54:59 am UTC-4 Howard wrote: > I have a column in Excel with data like this: > > 9/4/57 > 9/3/57 > 1957-09-02 (2) > 8/23/57 > 8/23/57 > 8/17/57 > 8/16/57 > 1957-08-13 (2) > 1957-08-13 (2) > 1957-08-02 (1) > 1957-07-28 (2) > > In BBEdit, I would like to extract all the numbers in parentheses -- (1) > and (2) -- and > put them in a second column without the parentheses. Then, I would like to > convert all the dates in Column 1 that are in *yyyy-mm-dd* format to > *mm/dd/yy* format so that I can copy the BBEdit result and paste it into > Excel as two columns (See *Sample Output*). > > *Sample Output* > > *Column 1 Column 2* > 9/4/57 > 9/3/57 > 1957-09-02 2 > > How can I do this in BBEdit? > 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/a20533b2-e686-45e1-a7b4-d2ab6e64ae8dn%40googlegroups.com.
