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 "supp...@barebones.com" 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 bbedit+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/a20533b2-e686-45e1-a7b4-d2ab6e64ae8dn%40googlegroups.com.

Reply via email to