Re: Splitting Amount into debits and credits

40 views
Skip to first unread message

Kaveh Bazargan

unread,
Nov 10, 2023, 2:49:59 AM11/10/23
to bbe...@googlegroups.com
Would this work:
Search: ^\-
Replace: \t

So change "-" at start of line to a tab. Then copy and paste into a spreadsheet. See here.

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.


--
Kaveh Bazargan PhD
Director
Accelerating the Communication of Research
  https://rivervalley.io/gigabyte-wins-the-alpsp-scholarly-publishing-innovation-award-using-river-valleys-publishing-technology/

Russell B

unread,
Nov 10, 2023, 8:29:49 AM11/10/23
to BBEdit Talk
Yes that did the trick. Simple and elegent :-)

Kaveh Bazargan

unread,
Nov 10, 2023, 11:23:28 AM11/10/23
to bbe...@googlegroups.com
Great. Wish they were all so simple. ;-)

Reply all
Reply to author
Forward
0 new messages