Text file from mainframe system

Giganews Newsgroups
Subject: Text file from mainframe system
Posted by:  Laura G (LGBeac…@yahoo.com)
Date: Wed, 15 Oct 2003

We are working on extracting a data file from an IBM
mainframe system to merge it into a .csv Excel file.  The
options for saving the file are either ASCII or carriage-
return indicator at the end of each line.  What is Excel
looking for at the end of each line for it to merge the
data into the spreadsheet correctly?  We have tried both
options and it merges all info into one row.

Replies