Cleaning up a text import

Поиск
Список
Период
Сортировка
От Bob Pawley
Тема Cleaning up a text import
Дата
Msg-id 51CDBB9C.6000500@shaw.ca
обсуждение исходный текст
Ответы Re: Cleaning up a text import  (Adrian Klaver <adrian.klaver@gmail.com>)
Список pgsql-general
Дерево обсуждения
Hi

I imported some text using the Quantum GIS dxf2postgis which somehow became distorted through the import.

What should have been imported was TK-208.

What I got was %%UTK-208%%U.

Perhaps I did something wrong while using dxf2postgis?

Otherwise, I can trim the text using - select trim (both '% U' from '%%UTK-208%%U') .

However I would need to know what it is that needs to be trimmed from future imports, which isn't always possible.

I would appreciate any suggestions on how to resolve this.

Many thanks in advance.

Bob

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: AFTER triggers and constraints
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: AFTER triggers and constraints