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

On Fri, 10 Nov 2023 at 13:29, Russell B <[email protected]> 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 <[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
> <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> ● @[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/CAJ2R9phCrOGSh8raqUHg6TaBS3DOiCiDDRvNaOArKcAanBFrWg%40mail.gmail.com.

Reply via email to