Error importing qif files from Capitalone

[Rob Hymns]

2009/2/3 Derek Atkins <warlord at mit.edu>

> Ahh..   The £ is illegal -- the importer cannot handle that character.
> Remove that from all your data and the importer should be able to
> pull it in.
>
> -derek


Sorry to be dense but how do I open it (or with what) in order to remove the
pound signs?
Rob




>
>
> Quoting Rob Hymns <hymnsie at gmail.com>:
>
>  Thanks Charles
>> Here's what I get:
>>
>> Line 3: Some characters have been converted according to your locale.
>> Converted to: -£35.00
>> Line 11: Some characters have been converted according to your locale.
>> Converted to: -£56.50
>> Line 19: Some characters have been converted according to your locale.
>> Converted to: -£65.00
>> Line 27: Some characters have been converted according to your locale.
>> Converted to: -£56.50
>> Line 35: Some characters have been converted according to your locale.
>> Converted to: £295.48
>> Line 43: Some characters have been converted according to your locale.
>> Converted to: -£30.00
>> Line 51: Some characters have been converted according to your locale.
>> Converted to: -£56.50
>> Line 59: Some characters have been converted according to your locale.
>> Converted to: -£105.00
>> Line 67: Some characters have been converted according to your locale.
>> Converted to: -£29.00
>> Line 75: Some characters have been converted according to your locale.
>> Converted to: -£44.00
>> Line 83: Some characters have been converted according to your locale.
>> Converted to: -£30.00
>> Line 91: Some characters have been converted according to your locale.
>> Converted to: -£42.01
>> Line 99: Some characters have been converted according to your locale.
>> Converted to: -£48.50
>> Line 107: Some characters have been converted according to your locale.
>> Converted to: -£48.50
>> Transaction amount: Unrecognized or inconsistent format.
>>
>> Rob
>>
>>
>>
>> 2009/2/3 Charles Day <cedayiv at gmail.com>
>>
>>  On Tue, Feb 3, 2009 at 2:39 AM, Rob Hymns <hymnsie at gmail.com> wrote:
>>>
>>>  I'm just getting started on Gnucash and having entered some transactions
>>>> manually, I thought I'd try to import from my Capitalone credit card's
>>>> webpage.
>>>> Downloaded the qif file ok but after following the import procedure, I
>>>> got
>>>> a
>>>> few lines with characters converted but with the final the error
>>>> message:
>>>> "Transaction amount: Unrecognized or inconsistent format."
>>>> Anyone familiar with this or got some suggestions?
>>>>
>>>>
>>> Does the QIF importer state a line number? If so, could you find the
>>> offending line and post it here?
>>>
>>> Cheers,
>>> Charles
>>>
>>>
>>>  Rob
>>>> _______________________________________________
>>>> gnucash-user mailing list
>>>> gnucash-user at gnucash.org
>>>> 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.
>>>>
>>>>
>>>
>>>  _______________________________________________
>> gnucash-user mailing list
>> gnucash-user at gnucash.org
>> 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.
>>
>>
>
>
> --
>      Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
>      Member, MIT Student Information Processing Board  (SIPB)
>      URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
>      warlord at MIT.EDU                        PGP key available
>
>