[GNC] clip board paste across catagories

[ToddAndMargo]

On 2020-09-30 17:40, John Ralls wrote:
> 
> 
>> On Sep 30, 2020, at 11:49 AM, ToddAndMargo via gnucash-user <gnucash-user at 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