Bev McConnell
New Member
Hello Peggers,
Can anyone help me with importing an excel file into progress? I've converted the excel file into a '.txt' and performed a file transfer from the local drive to unix. The problem is the record length exceeds 80 char. It looks as though progress is interpreting the wrap-around char. as seperate records.
How do I get progress to read in the full 160 char. The logic is as follows:
def var x-input as char format "x(160)".
input from "/home/bmcconne/prn/budgettest.txt".
import UNFORMATTED x-input.
x-entity = string(substring(x-input,1,8)).
x-cc = string(substring(x-input,9,8)).
x-desc = string(substring(x-input,25,22)).
x-mon-budget = integer(substring(x-input,60,12)).
x-mon-budget2 = integer(substring(x-input,73,12)).
x-mon-budget3 = integer(substring(x-input,86,12)).
x-mon-budget4 = integer(substring(x-input,98,12)).
(This is followed by a series of 'string' statements to seperate the fields).
Can anyone help me with importing an excel file into progress? I've converted the excel file into a '.txt' and performed a file transfer from the local drive to unix. The problem is the record length exceeds 80 char. It looks as though progress is interpreting the wrap-around char. as seperate records.
How do I get progress to read in the full 160 char. The logic is as follows:
def var x-input as char format "x(160)".
input from "/home/bmcconne/prn/budgettest.txt".
import UNFORMATTED x-input.
x-entity = string(substring(x-input,1,8)).
x-cc = string(substring(x-input,9,8)).
x-desc = string(substring(x-input,25,22)).
x-mon-budget = integer(substring(x-input,60,12)).
x-mon-budget2 = integer(substring(x-input,73,12)).
x-mon-budget3 = integer(substring(x-input,86,12)).
x-mon-budget4 = integer(substring(x-input,98,12)).
(This is followed by a series of 'string' statements to seperate the fields).