I am parsing a database field, that all the lines are like this: 
22009^1^52.90
22010^1^42.90
22011^1^32.90
# Always a empty line at the end...

[download]
I then have the script get the field... in the variable $itDetail Then I have it split it to get the line: 
while($itDetail) {
     (my $_line, $itDetail) = split /\015\012/, $itDetail, 2;
...

[download]
Then inside of that while statement, I am getting each of the 3 details I need... 
    (my $Num, $_line) = split /\^/, $_line, 2;
    my ($Qt, $_trashit) = split /\^/, $_line, 2;
    $_line = ""; # Reset the variable, just for my sake.
    # Do some things....
}

[download]
Now my problem is that $Num has a value of Num^Qt^xx.xx

It is NOT spliting those ones for me, each variable just has the whole value of the orginal $_line

Is there a known problem in trying to split "^"?

I know it's doing that because I inserted a piece of code to have it print each field for me, like this:
open(FH,">>/some/path/debug.txt") or die "could not open file for writ
+ing: $!";
print FH '$Num = ', $Num, "\n";
close(FH);

[download]
That is how I figured out it is having a problem.

Should I just change the ^ to something different? I have tried it escaped and just as ^ in the split // field. Both have the same problem.

Thanks for any advice you have for me.

thx,
Richard

In reply to split problem... by powerhouse

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.