Hi Russell,
I’m not sure what you exactly want to do, but if you just want to put the
negative lines into a second column in the CSV (comma separated values) file
and you have just one column in the origin file, you can use the following
pattern:
Search pattern: "^(\-{1})([0-9]{1,20}\.{0,1}[0-9]{0,2})“
Replacement pattern: ",\1\2“
(without quotation marks)
(If you want to have tabs instead of commas to separate the columns use "\t“
instead of “,“)
All the negative values will be placed now in a second column, but always in a
separate line.
The output will look like this:
,-2559.82
1168.41
,-12
,-7.21
23
Hope it helps.
Ulrich
> Am 20.05.2021 um 11:47 schrieb Russell B <russ...@bastock.net>:
>
>
> My bank accounts have a save to CSV option in a single Amount column, such as
> the following:
>
> -2559.82
> 1168.41
> -12
> -7.21
> 23
>
> I want to divide this into separate Credit & Debit columns, tab separated,
> such as
>
> Credit | Debit
>
> 1168.41 | 2559.82
>
> I can't create a robust GREP pattern to handle the existence or not of the
> decimal values. Can someone provide a suitable pattern?
> Thanks
>
> --
> 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 <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
> <mailto:bbedit+unsubscr...@googlegroups.com>.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/bbedit/783875e5-c1a0-438c-8071-678d598b71a1n%40googlegroups.com
>
> <https://groups.google.com/d/msgid/bbedit/783875e5-c1a0-438c-8071-678d598b71a1n%40googlegroups.com?utm_medium=email&utm_source=footer>.
--
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/83E4CF01-DF2D-4986-AC8C-179817EC820E%40gmx.de.
