Re: inserting data that contains / or \

Поиск
Список
Период
Сортировка
От Doug Silver
Тема Re: inserting data that contains / or \
Дата
Msg-id 200210031032.51940.dsilver@urchin.com
обсуждение исходный текст
Ответ на inserting data that contains / or \  ("Patrick Hatcher" <PHatcher@macys.com>)
Ответы Re: inserting data that contains / or \  (Garrett Bladow <bbladow@sendit.nodak.edu>)
Список pgsql-novice
On Thursday 03 October 2002 10:02 am, Patrick Hatcher wrote:
> Sorry up front.  I know this has probably been answered 10k times.
> I need to insert data into a field that will look as such:  MC HANCOCK GOLD
> 5PPS S/4
>
> my perl is getting better, but not quite there yet:  I have the following
> regex:
> $fields[$i] =~ s/\// /g;  which now puts a space in place of the /, but I
> would like to the keep the text  as is.  I believe I need to replace the
> single foward slash with 2 forward slashes.  But I'm lost as to how to do
> it
> Should it be this:  $fields[$i] =~ s/\//\///g;?
>
> TIA
>
> Patrick Hatcher
> Macys.Com
>

Try this -- note the use of "#" instead of the normal "/" as the regex
separator, very key when dealing with urls and other things that have the
forward slashes in them.

$fields[$i] =~s#/{1}#//#g;
--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Doug Silver
Network Manager
Urchin Software Corp.    http://www.urchin.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Help creating a function
Следующее
От: Garrett Bladow
Дата:
Сообщение: Re: inserting data that contains / or \