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_01C06546.92D8ED20 Content-Type: text/plain; charset="iso-8859-1" Are you using HP3000 system? Do you have ROBELLE software? Are you creating a simple delimited file? If your answer is YES to all my questions, the simplest way and fastest way to do it is by using SUPRTOOL and then use STEXPORT.PUB.ROBELLE to create a delimited file. You can even set you delimiter to what ever you want (example : comma, tabs, |, and to what ever you want). Joyce Bleza -----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. ------_=_NextPart_001_01C06546.92D8ED20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">RE: Delimited files Are you using HP3000 system? Do you have ROBELLE = software?
Are you creating a simple delimited file?If your answer is YES to all my questions, the = simplest way and fastest way to do it is by using SUPRTOOL and then use = STEXPORT.PUB.ROBELLE to create a delimited file. You can even set you = delimiter to what ever you want (example : comma, tabs, |, and to what = ever you want).
Joyce Bleza
-----Original Message-----
From: Bob Bushley (Burbank) [mailto:BBushley@burbank.hask= el.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 ListserversI 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
------_=_NextPart_001_01C06546.92D8ED20-- = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = 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.
Haskel International Inc.
Burbank, Ca.
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D = =3D =3D =3D =3D =3D =3D =3D
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.