[prev in list] [next in list] [prev in thread] [next in thread]
List: sas-l
Subject: Re: What is the hex code that Excel uses to cause text in a cell to wrap?
From: Mark Keintz <mkeintz () OUTLOOK ! COM>
Date: 2023-06-09 18:13:53
Message-ID: DM4P223MB0519FB7998AD0B472C929FD0B651A () DM4P223MB0519 ! NAMP223 ! PROD ! OUTLOOK ! COM
[Download RAW message or body]
[Attachment #2 (text/plain)]
Nat:
I made a dummy Excel sheet, inserted ALT-ENTER into a text cell (the only way I know \
to interactively create a within-cell line break). It increased the length of the \
text by one byte. Applying the excel UNICODE function on the inserted byte showed it \
to be '0A'x. Probably everybody (but me) already knew this.
But when exporting to CSV, I found that every cell containing the line break produce \
a CSV field with an additional two-bytes -- double quotes were applied to each end of \
the text. The internal '0A'x was not trifled with.
Here's a log showing the within-cell 0A (the first cell in each row had a line \
break).
19 filename x 'c:\temp\t.csv';
20 data _null_;
21 infile x termstr=crlf;
22 input;
23 list;
24 run;
NOTE: The infile X is:
Filename=c:\temp\t.csv,
RECFM=V,LRECL2767,File Size (bytes)D,
Last Modified Jun2023:13:57:07,
Create Time Oct2020:00:37:04
RULE: ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+---
1 CHAR "aaaA.Bbbb",cccCDddd 20
ZONE 26664046662266644666
NUMR 21111A22222C33334444
2 CHAR "eeeE.Ffff",gggGHhhh 20
ZONE 26664046662266644666
NUMR 25555A66662C77778888
NOTE: 2 records were read from the infile X.
The minimum record length was 20.
The maximum record length was 20.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds
From: SAS(r) Discussion <SAS-L@LISTSERV.UGA.EDU> On Behalf Of Nat Wooding
Sent: Friday, June 9, 2023 7:06 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: What is the hex code that Excel uses to cause text in a cell to wrap?
Carl
Thanks. I've tried a couple of the modifiers. I'm on the road and have not had a \
chance to try the code in the usage note that Alan posted. One aspect that I'm \
suspecting is that as I attempt to read the file, the input buffer is seeing the \
control characters before I'm removing them. Nat
On Thursday, June 8, 2023 at 11:36:05 PM EDT, Carl Denney \
<carldenney@comcast.net<mailto:carldenney@comcast.net>> wrote:
You said you were trying to use compress. Are you using the modifiers as well?
=compress(str, , "S");
s or S
adds space characters (blank, horizontal tab, vertical tab, carriage return, line \
feed, form feed, and NBSP ('A0'x, or 160 decimal ASCII) to the list of characters to \
drop.
On 6/7/2023 5:41 PM, Nat Wooding wrote:
Michelle
Thanks
I'v been trying a couple tricks like UE but have not had luck yet. The data come from \
a tool called Navigate which our college uses to manage class data. Given the nature \
of the particular cell, there may be a hard return involved.
Nat
On Wednesday, June 7, 2023 at 05:42:39 PM EDT, M Zunnurain \
<michelle_zunnurain@hotmail.com><mailto:michelle_zunnurain@hotmail.com> wrote:
Hi Nat,
Google hex chart. 0D is carriage return and 0A is line feed. If it's in excel and \
the data was hand entered it's probably 0D from the return key. If you have ultra \
edit, or another editing tool, copy and paste from the individual cell to ultra edit. \
View in hex to verify. Copy to code to use as a delimiter to read in the file,, or \
strip them out before using existing code.
Done this more than a few times.
Michelle
Sent from my Verizon, Samsung Galaxy Tablet
Get Outlook for Android<https://aka.ms/AAb9ysg>
________________________________
From: SAS(r) Discussion <SAS-L@LISTSERV.UGA.EDU><mailto:SAS-L@LISTSERV.UGA.EDU> on \
behalf of Nat Wooding \
<00000a500572f1ba-dmarc-request@LISTSERV.UGA.EDU><mailto:00000a500572f1ba-dmarc-request@LISTSERV.UGA.EDU>
Sent: Wednesday, June 7, 2023 3:50:41 PM
To: SAS-L@LISTSERV.UGA.EDU<mailto:SAS-L@LISTSERV.UGA.EDU> \
<SAS-L@LISTSERV.UGA.EDU><mailto:SAS-L@LISTSERV.UGA.EDU>
Subject: What is the hex code that Excel uses to cause text in a cell to wrap?
We have a situation in which we are trying to read CSVs downloaded from third party \
software and our input lines are being screwed up but what appears to be the line \
wrap command. I assume that if I can identify said character or characters, I can \
remove them prior to actually reading the file but I have not been able to find the \
hex code. Does anyone know this or have a work-around?
Thanks
Nat Wooding
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 15 (filtered medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:"SAS Monospace";
panose-1:2 11 6 9 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple" style="word-wrap:break-word">
<div class="WordSection1">
<p class="MsoNormal">Nat:<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I made a dummy Excel sheet, inserted ALT-ENTER into a text cell \
(the only way I know to interactively create a within-cell line break). It \
increased the length of the text by one byte. Applying the excel UNICODE \
function on the inserted byte showed it to be '0A'x. Probably everybody (but \
me) already knew this.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">But when exporting to CSV, I found that every cell containing \
the line break produce a CSV field with an additional two-bytes -- double quotes were \
applied to each end of the text. The internal '0A'x was not trifled \
with.<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">Here's a log showing the within-cell 0A (the first cell in \
each row had a line break).<o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS Monospace"">19 filename \
x 'c:\temp\t.csv';<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace"">20 data _null_;<o:p></o:p></span></p> <p \
class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS \
Monospace"">21 infile x \
termstr=crlf;<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace"">22 input;<o:p></o:p></span></p> <p \
class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS \
Monospace"">23 list;<o:p></o:p></span></p> <p \
class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS Monospace"">24 \
run;<o:p></o:p></span></p> <p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS \
Monospace""><o:p> </o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace"">NOTE: The infile X is:<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""> \
Filename=c:\temp\t.csv,<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""> RECFM=V,LRECL2767,File Size \
(bytes)D,<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""> Last \
Modified Jun2023:13:57:07,<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""> Create Time \
Oct2020:00:37:04<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""><o:p> </o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace"">RULE: \
----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----+---<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS \
Monospace""><o:p> </o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace"">1 CHAR "aaaA.Bbbb",cccCDddd \
20<o:p></o:p></span></p> <p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS Monospace""> \
ZONE 26664046662266644666<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""> NUMR \
21111A22222C33334444<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""><o:p> </o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace"">2 CHAR "eeeE.Ffff",gggGHhhh \
20<o:p></o:p></span></p> <p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS Monospace""> \
ZONE 26664046662266644666<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""> NUMR \
25555A66662C77778888<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace"">NOTE: 2 records were read from the infile X.<o:p></o:p></span></p> \
<p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS \
Monospace""> The minimum record length was \
20.<o:p></o:p></span></p> <p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS \
Monospace""> The maximum record length was \
20.<o:p></o:p></span></p> <p class="MsoNormal" style="text-autospace:none"><span \
style="font-size:8.0pt;font-family:"SAS Monospace"">NOTE: DATA statement \
used (Total process time):<o:p></o:p></span></p> <p class="MsoNormal" \
style="text-autospace:none"><span style="font-size:8.0pt;font-family:"SAS \
Monospace""> real \
time 0.01 \
seconds<o:p></o:p></span></p> <p class="MsoNormal"><span \
style="font-size:8.0pt;font-family:"SAS \
Monospace""> cpu \
time 0.03 \
seconds</span><o:p></o:p></p> <p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div style="border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in">
<p class="MsoNormal"><b>From:</b> SAS(r) Discussion <SAS-L@LISTSERV.UGA.EDU> \
<b>On Behalf Of </b>Nat Wooding<br>
<b>Sent:</b> Friday, June 9, 2023 7:06 AM<br>
<b>To:</b> SAS-L@LISTSERV.UGA.EDU<br>
<b>Subject:</b> Re: What is the hex code that Excel uses to cause text in a cell to \
wrap?<o:p></o:p></p> </div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Carl<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Thanks. I've \
tried a couple of the modifiers. I'm on the road and have not had a chance to try the \
code in the usage note that Alan posted. One aspect that I'm suspecting is that as I \
attempt to read the file, the input buffer is seeing the control characters before \
I'm removing them.<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif">Nat<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif"><o:p> </o:p></span></p>
</div>
</div>
<div id="ydp9997cb99yahoo_quoted_6447692026">
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">On \
Thursday, June 8, 2023 at 11:36:05 PM EDT, Carl Denney <<a \
href="mailto:carldenney@comcast.net">carldenney@comcast.net</a>> wrote: \
<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<div id="ydp9997cb99yiv9214173490">
<div>
<p><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">You \
said you were trying to use compress. Are you using the modifiers as \
well?<o:p></o:p></span></p> <p><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">=compress(str, \
, "S");<o:p></o:p></span></p> <p><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">s \
or S <br>
adds space characters (blank, horizontal tab, vertical tab, carriage return, line \
feed, form feed, and NBSP ('A0'x, or 160 decimal ASCII) to the list of characters to \
drop. <o:p></o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
<p><span style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
<div id="ydp9997cb99yiv9214173490yqt56371">
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">On \
6/7/2023 5:41 PM, Nat Wooding wrote:<o:p></o:p></span></p> </div>
</div>
</div>
<div id="ydp9997cb99yiv9214173490yqt47505">
<div>
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Michelle<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Thanks<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">I'v \
been trying a couple tricks like UE but have not had luck yet. The data come from a \
tool called Navigate which our college uses to manage class data. Given the nature \
of the particular cell, there may be a hard return involved.<o:p></o:p></span></p> \
</div> <div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Nat<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
</div>
<div id="ydp9997cb99yiv9214173490ydpa04ab02ayahoo_quoted_6194821628">
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">On \
Wednesday, June 7, 2023 at 05:42:39 PM EDT, M Zunnurain <a \
href="mailto:michelle_zunnurain@hotmail.com" \
target="_blank"><michelle_zunnurain@hotmail.com></a> wrote: \
<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<div id="ydp9997cb99yiv9214173490ydpa04ab02ayiv6816220755">
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Hi \
Nat,<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Google \
hex chart. 0D is carriage return and 0A is line feed. If it's in excel \
and the data was hand entered it's probably 0D from the return key. If you have \
ultra edit, or another editing tool, copy and paste from the individual cell to ultra \
edit. View in hex to verify. Copy to code to use as a delimiter to read \
in the file,, or strip them out before using existing code.<o:p></o:p></span></p> \
</div> <div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Done \
this more than a few times. <o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Michelle <o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div id="ydp9997cb99yiv9214173490ydpa04ab02ayiv6816220755ms-outlook-mobile-signature">
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Sent \
from my Verizon, Samsung Galaxy Tablet<br> Get <a href="https://aka.ms/AAb9ysg" \
target="_blank">Outlook for Android</a><o:p></o:p></span></p> </div>
<div class="MsoNormal" align="center" style="text-align:center"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"> \
<hr size="2" width="98%" align="center"> </span></div>
<div id="ydp9997cb99yiv9214173490ydpa04ab02ayiv6816220755yqt69426">
<div id="ydp9997cb99yiv9214173490ydpa04ab02ayiv6816220755divRplyFwdMsg">
<p class="MsoNormal"><b><span style="color:black">From:</span></b><span \
style="color:black"> SAS(r) Discussion <a href="mailto:SAS-L@LISTSERV.UGA.EDU" \
target="_blank"><SAS-L@LISTSERV.UGA.EDU></a> on behalf of Nat Wooding <a \
href="mailto:00000a500572f1ba-dmarc-request@LISTSERV.UGA.EDU" target="_blank"> \
<00000a500572f1ba-dmarc-request@LISTSERV.UGA.EDU></a><br> <b>Sent:</b> \
Wednesday, June 7, 2023 3:50:41 PM<br> <b>To:</b> <a \
href="mailto:SAS-L@LISTSERV.UGA.EDU" target="_blank">SAS-L@LISTSERV.UGA.EDU</a> <a \
href="mailto:SAS-L@LISTSERV.UGA.EDU" \
target="_blank"><SAS-L@LISTSERV.UGA.EDU></a><br> <b>Subject:</b> What is the \
hex code that Excel uses to cause text in a cell to wrap?</span><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"> \
<o:p></o:p></span></p> <div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"> <o:p></o:p></span></p>
</div>
</div>
<div>
<div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">We \
have a situation in which we are trying to read CSVs downloaded from third party \
software and our input lines are being screwed up but what appears to be the line \
wrap command. I assume that if I can identify said character or characters, I can \
remove them prior to actually reading the file but I have not been able to find the \
hex code. Does anyone know this or have a work-around?<o:p></o:p></span></p> </div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Thanks<o:p></o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A"><o:p> </o:p></span></p>
</div>
<div>
<p class="MsoNormal"><span \
style="font-size:10.0pt;font-family:"Helvetica",sans-serif;color:#26282A">Nat \
Wooding<o:p></o:p></span></p> </div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic