On 2020-09-30 17:40, John Ralls wrote:
On Sep 30, 2020, at 11:49 AM, ToddAndMargo via gnucash-user
<gnucash-user@gnucash.org> wrote:
On 9/30/20 4:51 AM, ToddAndMargo via gnucash-user wrote:
Hi Geoff,
The current game plane is to
1) learn how to import a CSV into GnuCash
2) take my data that I was going to place in the clipboard
and instead write it to a standard CSV file and location
the GnuCash can easily and consistently see
Since I will be the one handling the dat, I should be able to
handle the pitfalls of CSV.
One of my customers had me write a filter between two
program the used a CSV to transfer data between the two
of them. Things go a little interesting when the
importing program thought the quote mark they were
using for inches was the field terminator. It was
a bug in the receiving program as the field terminator
is a quote and then a comma. The end of line is a quote
and a return. My solution was to find where they were
using a quote sign for inches and replace it with "in".
I do use single quotes to denote cable feet and I may
have a few double quotes in my part descriptions that
I have to deal with. It all depends on how well done
GnuCash's import function is written. I will find out.
-T
On 2020-09-30 06:40, Adrien Monteleone wrote:
Sounds like a good case for using UTF8, prime and double-prime, either
originally when typing, or in substitution while processing. That would
also be typographically correct.
Regards,
Adrien
Here is a CSV exported from Libre Office Calc that
will blow a parcers mind, especially the second line
Inches,Feet
3”,0.25 ‘
"6”, strap","0.5’, strap"
Believe it or not, Calc actually reads it back correctly
Of course it does. Why wouldn't it?
Regards,
John Ralls
It would be a wonderful world if all software worked properly.
It is great the Calc read it correctly
_______________________________________________
gnucash-user mailing list
gnucash-user@gnucash.org
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
