Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Perl Question - Split using |

Re: Perl Question - Split using |

From: <lembark_at_wrkhors.com>
Date: Fri, 05 Jul 2002 07:20:09 -0800
Message-ID: <F001.00490427.20020705072009@fatcity.com>

> After seeing the e-mails about "Perl for Oracle-DBAs",
> I presume, my question wouldn't be completely
> inappropriate for this list.
> So if you Oracle Gurus, can help me with this Perl
> problem, I would greatly appreciate it.
> I have a problem with "split" when my delimiter is
> "|".
> I know that if I escape the pipe, split should work,
> that is only when it is a literal like
> split(/\|/, "abc|def|123)
>
> But when my delimiter is to be dynamically read from a
> file, I have it in a variable. Then this escaping
> stuff doesn't work......
> eg:
> my $HeaderAttributes = "abc|defgh|123";
> print "$HeaderAttributes\n";
> my $Delimiter = "\|";
> (@Fields) = split(/$Delimiter/, $HeaderAttributes);
> print "Delimiter = $Delimiter.... Field[0] =
> $Fields[0]\n";

Look up the '\Q' metachar (e.g., perldoc perlre and search for \Q).

--
Steven Lembark                              2930 W. Palmer
Workhorse Computing                      Chicago, IL 60647
                                           +1 800 762 1582
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: lembark_at_wrkhors.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Jul 05 2002 - 10:20:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US