Page 1 of 1

Extracting data from spreadsheet

PostPosted: Fri Sep 17, 2010 6:23 pm
by joinshashank
Can anybody suggest a solution for following issue?

I have numbers in the spreadsheet in row 1
1.1234 2564 2654
2 1245 2654 2564
3 5564 1244 2144
4 8544 2354 2650
5 8595 2313 1484
6 7841 1844 1441
7 1547 1541 0124
8 5414 2654 4424

i want to pull the number one by one as I hit enter when i will put this this data to mainframe i should pool it as 1234 2564 2654

with next key eg F1 i should able to pull the second 1245 2654 2564 in mainframe could it be possible to link it ???

Re: Extracting data from spreadsheet

PostPosted: Fri Sep 17, 2010 8:21 pm
by Robert Sample
Why are you posting problems with a SPREADSHEET on a mainframe forum? You're not likely to find any answers here.

When I need to transfer data to / from a spreadsheet, I use the comma-delimited format and the mainframe handles them as text files just fine.