And be careful even with the quotes. For example, if I use a script to
create a csv file containing something like this:
"3390","12E3"
On my Win 10 system, even with the quotes that unit address turns into a
number because Excel apparently thinks it's an exponent representation.
I can fix that by putting an "=" in front such as:
"3390",="12E3"
Often I'll script everything as ="data" because I don't want Excel to be
messing with any field.
On 9/3/2019 12:00 AM, Sean Gleann wrote:
Take special care with date values...
Over here in Leftpondia, date values are (normally) 'dd-mm-yy', or some
variation thereof. This can lead to some difficulties when sending data
from m/f to pc.
As Mike says, surround such values with quotes, thus forcing Excel to treat
them as text strings rather than numerics
Good Luck!
Sean
On Tue, 3 Sep 2019 at 07:31, Mike Schwab <[email protected]> wrote:
Put in quotes and commas to create a CSV file is your best bet. Then
open in excel and save as an excel format.
"field one ","field two ",123456789.12,"field three"
Probably would be better to even put quotes around the number fields.
On Tue, Sep 3, 2019 at 1:13 AM Peter <[email protected]> wrote:
Hi Group
I have been using txt2pdf for a long and I understand it also does
building
CSV files which can be opened using Excel. Is there a way to convert a
text
file into Excel automatically within mainframe as
.XLS prior sending to email server ?
Peter
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
--
Mike A Schwab, Springfield IL USA
Where do Forest Rangers go to get away from it all?
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
----------------------------------------------------------------------
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to [email protected] with the message: INFO IBM-MAIN
