Well if your doing an update, do it column by column and when you do a
date column replace the '.' with '/'=20
-----Original Message-----
From: pgsql-general-owner@[EMAIL PROTECTED]
On Behalf Of Jan Christian
Dittmer
Sent: Wednesday, May 07, 2008 10:16 AM
To: pgsql-general@[EMAIL PROTECTED]
Re: [GENERAL] Im****t German Decimal Numbers
Thank you very much!
You have remind me that the our server runs under Linux and not under=20
Windows as our clients :-)
So indeed I can use a sed-pipe construct to switch '.' and ','.
But wait, there is just another problem then. Our date format is also=20
german :-( "DD.MM.YY" or
"DD.MM.YYYY". So if I just exchange '.' and ',' the date will be=20
unreadable for the im****t :-(
The (current) file is 1.4 GB so it will take ages to let awk chew on it=20
I guess.
Christian
Ken Allen wrote:
> I would replace the ',' with something else such as a '#' first then
> replace the decimal with the ',' then replace the '#' with a decimal
'.'
>
> If you do the ',' with a '.' first then all of them will be '.' and
you
> wont know which ones to change.
>=20=20=20
> Don't know, but you can replace the , to . within the ascii-file (sed,
> awk, ...).
>
>
> Andreas
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--=20
This message has been scanned by MailScanner
--=20
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
|
