It may have to do something how you are opening the file handler of CSV file.
The data you seen in the csv file may depend on which encoding you
have used while creating the file.
Couple of questions:
1. I believe currently you are view the file on Windoze, when you view
the file on Unix, do you still see the graphics.
2. Is graphics visible on most of the editors or have you used only 1 editor?
Cheers,
Parag
On Tue, Jan 4, 2011 at 3:56 PM, Wagner, David --- Senior Programmer
Analyst --- CFS <david.wag...@fedex.com> wrote:
> 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/
>
>
>
--
To unsubscribe, e-mail: beginners-unsubscr...@perl.org
For additional commands, e-mail: beginners-h...@perl.org
http://learn.perl.org/
