Re: Re: Re: Parsing user input into CSV table

Further investigation shows that the problem is in fact not commas or html tags etc. Rather newlines.

So whats the "help the noobie" suggestion for stripping the newline characters from the scaler?

Lance

Kia Kaha, Kia Toa, Kia Manawanui!
Be Strong, Be Brave, Be perservering!

Comment on Re: Re: Re: Parsing user input into CSV table

Replies are listed 'Best First'.
Re: Re: Re: Re: Parsing user input into CSV table by William G. Davis (Friar) on Apr 14, 2004 at 18:30 UTC
The "help the noobie" suggestion is to use some already-existing CSV module and let it handle this for you :) Unfortunately, Text::CSV doesn't handle newlines at all. It could escape them, but for some reason, it doesn't--it just silently fails when passed newlines. Our fellow Monk Tilly has written Text::xSV, which offers a much better interface to CSV than Text::CSV does. It can handle commas and newlines, and provides more file-oriented routines to store the resulting CSV and load it later on: http://search.cpan.org/dist/Text-xSV. Great solution.	[reply]
Re: Re: Re: Re: Parsing user input into CSV table by lwicks (Friar) on Apr 14, 2004 at 12:58 UTC
I think I found the answer here 84423 Opinions? Kia Kaha, Kia Toa, Kia Manawanui! Be Strong, Be Brave, Be perservering!	[reply]