Re: Import German Decimal Numbers
От | Jan Christian Dittmer |
---|---|
Тема | Re: Import German Decimal Numbers |
Дата | |
Msg-id | 4821AB86.9020008@web.de обсуждение исходный текст |
Ответ на | Re: Import German Decimal Numbers ("Ken Allen" <KenA@BarrettXplore.com>) |
Ответы |
Re: Import German Decimal Numbers
Re: Import German Decimal Numbers |
Список | pgsql-general |
Thank you very much! You have remind me that the our server runs under Linux and not under 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 german :-( "DD.MM.YY" or "DD.MM.YYYY". So if I just exchange '.' and ',' the date will be unreadable for the import :-( The (current) file is 1.4 GB so it will take ages to let awk chew on it 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. > > Don't know, but you can replace the , to . within the ascii-file (sed, > awk, ...). > > > Andreas
В списке pgsql-general по дате отправления: