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.
