Re: Splitting Amount into debits and credits

[Kaveh Bazargan]

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

River Valley Technologies ● Twitter ● LinkedIn ● ORCID ● @kave...@mastodon.social

Accelerating the Communication of Research

  

[Russell B]

Yes that did the trick. Simple and elegent :-)

[Kaveh Bazargan]

Great. Wish they were all so simple. ;-)

To view this discussion on the web visit https://groups.google.com/d/msgid/bbedit/99a60a3e-1d21-49d7-b324-2dacc98de1f6n%40googlegroups.com.