https://bugs.kde.org/show_bug.cgi?id=473322
Jack <ostrof...@users.sourceforge.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
See Also| |https://bugs.kde.org/show_b
| |ug.cgi?id=473381
--- Comment #9 from Jack <ostrof...@users.sourceforge.net> ---
The problem is that Formatted is not a numeric field, it is explicitly text,
and formatting of currency amounts can reasonably include decimal and thousands
separators. It also turns out it will likely be significantly more difficult
to make that change than I first thought - I was thinking about a different
part of the program. I won't rule it out, but it probably won't happen soon.
I have opened a separate wishlit so it doesn't get forgotten. See
https://bugs.kde.org/show_bug.cgi?id=473381
I wasn't asking if you could explicitly parse out the commas, I was asking if
there was an existing function to convert text to number, recognizing the
commas, just so you don't need to parse them out. In my reading (I don't
commonly use sqlite, so I'm not really familiar with it) it seems you should
relatively easily be able to write a function in some other language (where the
parsing and/or conversion would be easier) that you can then call directly from
sqlite.
--
You are receiving this mail because:
You are the assignee for the bug.
