From: | Doug Silver <dsilver(at)urchin(dot)com> |
---|---|
To: | "Patrick Hatcher" <PHatcher(at)macys(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: inserting data that contains / or \ |
Date: | 2002-10-03 17:32:29 |
Message-ID: | 200210031032.51940.dsilver@urchin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From | Date | Subject | |
---|---|---|---|
Next Message | Garrett Bladow | 2002-10-03 17:46:46 | Re: inserting data that contains / or \ |
Previous Message | Tom Lane | 2002-10-03 17:12:42 | Re: Help creating a function |