[GNC] What determines the order of transaction is CSV file?

David H hellvee at gmail.com
Fri Dec 23 17:48:28 EST 2022


Dave,

Exporting transactions to csv means you get a lot of extraneous crap
with it :-)  Depending on how much detail you need, it might be easier to
run a transaction report, filter on dates required, sort into required
order and then copy and paste into LibreOffice ???

Cheers David H.

On Sat, 24 Dec 2022 at 07:25, Dr. David Kirkby <
drkirkby at kirkbymicrowave.co.uk> wrote:

> I exported a list of transactions, then opened them in the LibraOffice
> spreadsheet. The transactions seem to be in a random order. Since they are
> split across multiple lines, it would not be possible to just sort them on
> the date column. I'm sure there must be some logic to it, but I can't see
> it. Below is a list of the dates of the transactions. Is there a way to get
> them saved in chronological order?
>
> 01/03/2022
>
> 25/02/2022
>
> 25/02/2022
>
> 28/02/2022
>
> 28/02/2022
>
> 28/02/2022
>
> 01/03/2022
>
> 01/03/2022
>
> 01/03/2022
>
> 01/03/2022
>
> 02/03/2022
>
> 02/03/2022
>
> 02/03/2022
>
> 03/03/2022
>
> 25/02/2022
>
> 28/02/2022
>
> 01/03/2022
>
> 01/03/2022
>
> 25/02/2022
>
> 25/02/2022
>
> 25/02/2022
>
> 28/02/2022
>
> 01/03/2022
>
> 01/03/2022
>
> 02/03/2022
>
> 02/03/2022
>
>
> 25/02/2022
>
> 01/03/2022
>
> Dr David Kirkby Ph.D
> Email: drkirkby at kirkbymicrowave.co.uk Web:
> https://www.kirkbymicrowave.co.uk/
> Kirkby Microwave Ltd (Tel 01621-680100 / +44 1621-680100)
> Stokes Hall Lodge, Burnham Rd, Chelmsford, Essex, CM3 6DT.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>


More information about the gnucash-user mailing list