Delimited files

[Mark Stewart]

Bob,

Try this:

PROBLEM_FIELD = "     TEST"

DEFINE D_PROBLEM_FIELD         CHAR*9 = PACK(PROBLEM_FIELD)



REPORT SUMMARY &
   ... &
   ";" &
   D_PROBLEM_FIELD &
   ";" &
   etc

SET SUBFILE NAME FIXED KEEP PORTABLE NODICT

You can also format date and currency fields for your portable data file by adding /'s for dates and doller signs where applicable and Excel will automatically format the character fields the appropriate data type.


On Tue, 12 December 2000, "Bob Bushley (Burbank)" wrote:

> 
> 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.


__________________________________________________________
Get your FREE personalized e-mail at http://www.canada.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.