I am generating an CSV and want a couple of fields to have soft
returns in them. I went into Excel and added a couple of soft returns to
a couple of different fields and then saved the modified file back to a
CSV.
I opened in a editor and reviewed what was there. What I saw
was:
"xxxxxxxxxxx(lf) # shows as LF verses the std end of line for
windows of CR/LF
Yyyyyyyyyyyy(lf)
"
I left the editor and double clicked again and brought into
Excel. The data had the soft returns.
So I added the following to my processing:
for ( @MyWorka ) {
if ( /\^/ ) {
s/\^/\x0a/g; # I have tried the \r and even
\n and when opened in
# Excel always has the
graphic explained below....
}
}
Whereever there is a ^ replace with a hex A which to me is a
LineFeed ( incorrectly as I have read ). I run and create my csv. I
double click the file and it opens in Excel. It appears to be working,
but where each linefeed is you get a little graphic with a question mark
inside a circle. In a way it is doing the soft returns, but obviously
not correctly.
Any thoughts on what I am doing incorrectly??
Thanks.
Wags ;)
David R. Wagner
Senior Programmer Analyst
FedEx Services
1.719.484.2097 Tel
1.719.484.2419 Fax
1.408.623.5963 Cell
http://Fedex.com/us
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
