Delimited files

Knox, Dave (Dallas, TX) knoxda01@unisourcelink.com
Wed, 13 Dec 2000 15:31:36 -0500


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_01C06543.B401A116
Content-Type: text/plain

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_01C06543.B401A116
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">



RE: Delimited files



Do you have headings = forcing the extra spacing perhaps ?

Try SET NOHEAD = ?

------_=_NextPart_001_01C06543.B401A116-- = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 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.