Software to download Fixed Width Files

G

Guest

I have a software which is very old (Open VMS, Unix Based). I have to do a
lot of formatting after downloading files from this software to Excel. Is
there a way or a software that i can use to download (Fixed Width Ascii
files) from my software to excel so that i don't have to do any formatting
after downloading???


Thankx!
 
W

wjohnson

If your file is actually a fixed width file - and one record fitting on
one line.
Then copy and past the file into excel - it should all paste into
column A and then use as many rows as required.
Then in excel goto "DATA" then Select "TEXT TO COLUMNS" and follow the
directions.
Also you might ask your VM programmer to have the fields "comma" or
"semi-colon", etc. deliminated and then you can still use the above
procedure.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to ASCII Fixed Format 2
How do I create a "fixed-width" datafile? 4
Fixed Width Text Import Settings 4
Repeatable Fixed Width Import 9
fixed-width files 2
Fixed width 4
Downgrading from Windows 11 1
Fixed Length, Text Formatted 2

Top