Great. Wish they were all so simple. ;-) On Fri, 10 Nov 2023 at 13:29, Russell B <[email protected]> wrote:
> Yes that did the trick. Simple and elegent :-) > > On Friday, November 10, 2023 at 6:49:59 PM UTC+11 Kaveh Bazargan wrote: > >> Would this work: >> Search: ^\- >> Replace: \t >> >> So change "-" at start of line to a tab. Then copy and paste into a >> spreadsheet. See here <https://regex101.com/r/f31LjO/1>. >> >> On Fri, 10 Nov 2023 at 01:28, Russell B <[email protected]> wrote: >> >>> What's the simplest way to split an Amount column into debits and >>> credits using grep? Some of the cells are empty. >>> >>> It has values like: >>> Amount >>> 210 >>> 30.25 >>> -20 >>> -45.77 >>> >>> It is output from a banking web site. There are columns either side. >>> >>> Thanks >>> >>> -- >>> 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/235027e7-b91a-410f-a9fb-ced770e11237n%40googlegroups.com >>> <https://groups.google.com/d/msgid/bbedit/235027e7-b91a-410f-a9fb-ced770e11237n%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> -- >> Kaveh Bazargan PhD >> Director >> River Valley Technologies <http://rivervalley.io> ● Twitter >> <https://twitter.com/rivervalley1000> ● LinkedIn >> <https://www.linkedin.com/in/bazargankaveh/> ● ORCID >> <https://orcid.org/0000-0002-1414-9098> ● @[email protected] >> <https://mastodon.social/@kaveh1000> >> *Accelerating the Communication of Research* >> >> * >> <https://www.linkedin.com/posts/bazargankaveh_ismte-innovation-award-recipient-kaveh-bazargan-activity-7039348552526921728-XAEB/?utm_source=share&utm_medium=member_desktop> >> [image: >> https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/] >> <https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/>* >> > -- > 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/99a60a3e-1d21-49d7-b324-2dacc98de1f6n%40googlegroups.com > <https://groups.google.com/d/msgid/bbedit/99a60a3e-1d21-49d7-b324-2dacc98de1f6n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Kaveh Bazargan PhD Director River Valley Technologies <http://rivervalley.io> ● Twitter <https://twitter.com/rivervalley1000> ● LinkedIn <https://www.linkedin.com/in/bazargankaveh/> ● ORCID <https://orcid.org/0000-0002-1414-9098> ● @[email protected] <https://mastodon.social/@kaveh1000> *Accelerating the Communication of Research* * <https://www.linkedin.com/posts/bazargankaveh_ismte-innovation-award-recipient-kaveh-bazargan-activity-7039348552526921728-XAEB/?utm_source=share&utm_medium=member_desktop> [image: https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/] <https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/>* -- 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/CAJ2R9phCrOGSh8raqUHg6TaBS3DOiCiDDRvNaOArKcAanBFrWg%40mail.gmail.com.
