On Wed, Sep 19, 2018 at 6:34 AM Gabriel Furstenheim Milerud <
[email protected]> wrote:
Maybe that is not possible with numbers? To say in a format something like
> "my numbers have comma as decimal separator and no thousands separators" or
> "my numbers are point separated and have comma as thousands separator"
>
>
Would stripping out the thousand separator, and leaving in the decimal
separator work?
SELECT replace('9,000.34',',','')::numeric;
replace
---------
9000.34
If so, then (conceptually) does this work?
SELECT replace(
replace(my_numeric_string, user_thousand_sep, ''),
user_decimal_sep, system_decimal_sep
)::numeric
Or maybe I'm missing something about this!
Cheers,
Ken
--
AGENCY Software
A Free Software data system
By and for non-profits
*http://agency-software.org/ <http://agency-software.org/>*
*https://demo.agency-software.org/client
<https://demo.agency-software.org/client>*
[email protected]
(253) 245-3801
Subscribe to the mailing list
<[email protected]?body=subscribe> to
learn more about AGENCY or
follow the discussion.
