Great. Wish they were all so simple. ;-) On Fri, 10 Nov 2023 at 13:29, Russell B <russ...@bastock.net> 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 <rus...@bastock.net> 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 "sup...@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+un...@googlegroups.com. >>> 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> ● @kave...@mastodon.social >> <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 "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/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> ● @kaveh1000@mastodon.social <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 "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/CAJ2R9phCrOGSh8raqUHg6TaBS3DOiCiDDRvNaOArKcAanBFrWg%40mail.gmail.com.
