Tabular Text File from Mainframe

[Andy Lee]

Hi all,

I'm trying to import a tabular data from a text file exported from
mainframe. However, the textfile contains a line breaker, a digital
number "1" at the start of centain numbers of rows. How to get rid if
it?

thanks,

andy

 

[John Nurick]

Hi Andy,

Normally you can just open the file in a text editor or word processor
and use the search function to find the offending character and delete
it.

If you want to automate the process, it can be done but you'll have to
give a clearer description. When you say "a line breaker" do you mean a
form feed (page break) character, which is normally Ctrl-L (Chr(12)), or
a line continuation character (indicating that a new line in the
printout is not actually a new record in the data), or what?

Likewise I'm not at all sure what you mean by 'a digital number "1"'.