I think that some of he other answers have merit because
they provide possible other ways of doing it, but you're
right they don't answer the specific question.

In answer to your question, the output is very strange.
The output looks just like the input except the RATED PG
part and all of the line breaks (which appear to be
CR/LFs) are gone. Now I do want to remove the line
breaks, but need the "RATED PG" part. It gets stored in
another part of my database.

Meanwhile, though, I've set up a MySQL instance on my
windows machine and I am opening a database handle to
both Access and My SQL at the same time. This is far
more tedious, but I am able to move the values from one
database to the other using straight SQL. I can then
export from the local MySQL instance and upload that to
my Linux server. It's a pain, but I didn't have time to
wait for an answer.

Thanks for your help. If you have any other suggestions,
I think that the input is actually like this if you were
to see the actual CR/LFs:

RATED PG-\r\n
\r\n
Former co-stars of the TV sitcom Head of the Class 
teamed up to write the story and script for this teen 
comedy. When junior high school student Jason Shepherd 
(Frankie Muniz) realizes th <...snip...>\r\n
\r\n

Thanks again.

-Matt

In reply to Re: Re: Perl with MS Access Weirdness by mlong
in thread Perl with MS Access Weirdness by mlong

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.