Delimited files

[Byron Welch]

Bob,
  Powerhouse always leaves space for the entire size of a character item.
If your items only use up three characters you could move them to a three
character defined item and then report that item.  There is no default way
to eliminate the leading and/or trailing spaces.

Byron Welch
Manager Consulting Services
Creative Computing, Inc.
100 Middle Street
Lincoln, RI 02865


-----Original Message-----
From: Bob Bushley (Burbank) [mailto:BBushley@burbank.haskel.com]
Sent: Wednesday, December 13, 2000 3: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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.