|
|
Posted by ND on 12/07/05 14:31
Hi,
I have the following coding problem:
I have a evaluation form with some questions.
Some of these questions are answered by a textarea (which gives the user the
possibillity to use [enter] and make a new line feed in the answer).
The answers are recorded into a database.
This all works fine, but!
When I want to output my answers to a .csv file, the 'new line feeds' of the
textarea fields are messing up my grid in the csv (excel text file seperated
by semicolon ';').
I write the answers to a file which can be downloaded but the 'new line'
makes an abrupt stop to a line.
Hope somebody understands the problem.
How can I work around this 'little' error?
I've tried the following without any results :-(
$value=ereg_replace('\r\n','',$value);
$value=ereg_replace('\r','',$value);
$value=ereg_replace('\n','',$value);
I'm guessing that since there is no actual \n to be found in the $value
field it does not replace anything.
the nl2br function DOES however recognize the \n but it keeps the \n in the
text:
a combination where \n is replaced by <br /> which is deleted in step2:
$value=nl2br($value);
$value=ereg_replace('<br />','',$value);
But I still get the 'new lines' in my output file. I don't want this!! I
want one continued file with info....
Thanks a million!
Daniel
Navigation:
[Reply to this message]
|