Re: Perl with MS Access Weirdness

I'm really confused by all the answers so far.

mlong's got what appears to be a regex problem, and we're all trying to fix his CSV code.

Very noble I'm sure, but the fact remains, doesn't it, that if you really have got what he says is in his sample record, and you do what he says are his regexes, then you shouldn't get that result? I mean, am I being dumb here?

mlong, what happens if you print out, like:


print "here's the current contents of \$descriz: $descriz";
[download]

then check it again afterwards?

The consensus seems to be that your data's coming out wrong, or going in wrong, so that would prove it, right?
--
“Every bit of code is either naturally related to the problem at hand, or else it's an accidental side effect of the fact that you happened to solve the problem using a digital computer.” M-J D

Comment on Re: Perl with MS Access Weirdness Download Code

Replies are listed 'Best First'.
Re: Re: Perl with MS Access Weirdness by mlong (Sexton) on Jan 28, 2003 at 04:31 UTC
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	[reply]

Replies are listed 'Best First'.

Re: Re: Perl with MS Access Weirdness
by mlong (Sexton) on Jan 28, 2003 at 04:31 UTC

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

[reply]