Delimited files
Jones Allen (Van)
Allen.Jones@vpgroup.com
Wed, 13 Dec 2000 12:38:41 -0800
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C06544.AF4AF1F0
Content-Type: text/plain;
charset="iso-8859-1"
It would help if you could send the source code if it's not too complicated,
or the minimum code required to reproduce the problem, together with a
description of the input. We're guessing what the possible cause is.
-----Original Message-----
From: Knox, Dave (Dallas, TX) [mailto:knoxda01@unisourcelink.com]
Sent: Wednesday, December 13, 2000 12:32 PM
To: 'Bob Bushley (Burbank)'; 'powerh-l@lists. swau. edu (E-mail)'
Subject: RE: Delimited files
Do you have headings forcing the extra spacing perhaps ?
Try SET NOHEAD ?
-----Original Message-----
From: Bob Bushley (Burbank) [SMTP:BBushley@burbank.haskel.com]
Sent: Wednesday, December 13, 2000 2:03 PM
To: 'powerh-l@lists. swau. edu (E-mail)'
Subject: Delimited files
Follow up Wed 12/13/2000 11:55 AM
I have in my report 'set report spacing 0' and the dat file has the
extra 5
characters. How do I get rid of the extra 5 characters without tabing? It is
doing this on every element in the report statement.
Thank You!
Bob Bushley
Haskel International Inc.
Burbank, Ca.
Original message Tue 12/12/2000 3:40 PM
Fellow Listservers
I am using a dat subfile to export semicolon delimited text file to
Excel.
My problem is a have a character field of 8 bytes and when I import it into
Excel the field has 5 leading characters in it. This only happens on text
general characters fields not on numeric general text fields. Can someone
explain way or how to stop the extra 5 blank left justified characters from
appearing in my field.
Thank You!
Bob Bushley
Haskel International Inc.
Burbank, Ca.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.
------_=_NextPart_001_01C06544.AF4AF1F0
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: Delimited files</TITLE>
<META content="MSHTML 5.50.4134.600" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=730253620-13122000><FONT face="Bookman Old Style"
color=#000080>It would help if you could send the source code if it's not too
complicated, or the minimum code required to reproduce the problem, together
with a description of the input. We're guessing what the possible cause
is.</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Knox, Dave (Dallas, TX)
[mailto:knoxda01@unisourcelink.com]<BR><B>Sent:</B> Wednesday, December 13,
2000 12:32 PM<BR><B>To:</B> 'Bob Bushley (Burbank)'; 'powerh-l@lists. swau.
edu (E-mail)'<BR><B>Subject:</B> RE: Delimited files<BR><BR></FONT></DIV>
<P><FONT face=Arial color=#0000ff size=2>Do you have headings forcing the
extra spacing perhaps ?</FONT> </P>
<P><FONT face=Arial color=#0000ff size=2>Try SET NOHEAD ?</FONT> </P>
<UL>
<P><FONT face=Arial size=1>-----Original Message-----</FONT> <BR><B><FONT
face=Arial size=1>From: </FONT></B> <FONT face=Arial size=1>Bob
Bushley (Burbank) [SMTP:BBushley@burbank.haskel.com]</FONT> <BR><B><FONT
face=Arial size=1>Sent: </FONT></B> <FONT face=Arial
size=1>Wednesday, December 13, 2000 2:03 PM</FONT> <BR><B><FONT face=Arial
size=1>To: </FONT></B> <FONT face=Arial
size=1>'powerh-l@lists. swau. edu (E-mail)'</FONT> <BR><B><FONT face=Arial
size=1>Subject: </FONT></B> <FONT
face=Arial size=1>Delimited files</FONT> </P>
<P><FONT face=Arial size=2>Follow up Wed 12/13/2000 11:55 AM</FONT> </P>
<P><FONT face=Arial size=2>I have in my report 'set report spacing 0' and
the dat file has the extra 5</FONT> <BR><FONT face=Arial size=2>characters.
How do I get rid of the extra 5 characters without tabing? It is</FONT>
<BR><FONT face=Arial size=2>doing this on every element in the report
statement.</FONT> </P>
<P><FONT face=Arial size=2>Thank You!</FONT> </P>
<P><FONT face=Arial size=2>Bob Bushley</FONT> <BR><FONT face=Arial
size=2>Haskel International Inc.</FONT> <BR><FONT face=Arial size=2>Burbank,
Ca.</FONT> </P>
<P><FONT face=Arial size=2>Original message Tue 12/12/2000 3:40 PM</FONT>
<BR><FONT face=Arial size=2>Fellow Listservers</FONT> </P>
<P><FONT face=Arial size=2>I am using a dat subfile to export semicolon
delimited text file to Excel.</FONT> <BR><FONT face=Arial size=2>My problem
is a have a character field of 8 bytes and when I import it into</FONT>
<BR><FONT face=Arial size=2>Excel the field has 5 leading characters in it.
This only happens on text</FONT> <BR><FONT face=Arial size=2>general
characters fields not on numeric general text fields. Can someone</FONT>
<BR><FONT face=Arial size=2>explain way or how to stop the extra 5 blank
left justified characters from</FONT> <BR><FONT face=Arial size=2>appearing
in my field.</FONT> </P>
<P><FONT face=Arial size=2>Thank You!</FONT> </P>
<P><FONT face=Arial size=2>Bob Bushley</FONT> <BR><FONT face=Arial
size=2>Haskel International Inc.</FONT> <BR><FONT face=Arial size=2>Burbank,
Ca.</FONT> <BR><FONT face=Arial size=2>= = = = = = = = = = = = = = = = = = =
= = = = = = = = = = = = = = = = = = =</FONT> <BR><FONT face=Arial
size=2>Subscribe: "subscribe powerh-l" in message body to
majordomo@lists.swau.edu</FONT> <BR><FONT face=Arial size=2>Unsubscribe:
"unsubscribe powerh-l" in message to majordomo@lists.swau.edu</FONT>
<BR><FONT face=Arial size=2>This list is closed, thus to post to the list,
you must be a subscriber.</FONT> </P></UL></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C06544.AF4AF1F0--
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.