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/676b2949-855d-4afc-9545-a9aa1658bb1en%40googlegroups.com.
