Copyframe mainframe txt to excel 2003

[bigcat48]

All,

I am using the Jolly Giant software for the mainframe.

I need to use a script to copy text to excel.

There's a list of functions to use but there is no function to just copy data to the clipboard. Only appendtodisk which is copy the screen text to a file.

I am a little lost. Please help.

Thanks.

 

[SkipVought]

Hi,

Copy the text to a file.

Then in Excel, Data > Import External Data... to open the file and import and parse the data into columns.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bigcat48]

Is there a way to copy two groups or rows of text and place those in one row in two separate cells?

What I mean is the following:
Copy Group text A to Cell A1 & Copy Group text B to Cell B1

 

[SkipVought]

Copy

EDIT (F2) the cell

Paste.

Format the cell alignment using Word Wrap.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bigcat48]

well what happens is when the txt is copied to excel,
the line 1 copy from the mainframe is in cell A1,
then the line 2 copy is A2.

I want to automate this somehow to get the line 1 txt in A1 and line 2 txt in B1.

Can this work with a macro?

 

[SkipVought]

Can you explain the business case for having two value in one cell?

BTW, This could happen in ANOTHER cell, referencing, for instance A1 & A2, like...
[tt]
=A1&A2
[/tt]
or, if you need a space...
[tt]
=A1&" "&A2
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bigcat48]

I need to automate this task to have mainframe data copied in excel for reporting.

Using Jolly Giant Software for my mainframe emulator.

I can somewhat automate the task by concatenating the text copies and then manually copy the values to values and then removing the duplicate row.

After all of this is copied then I would need to copy & paste into a general reporting spreadsheet.

 

[SkipVought]

did you try the concatenate process?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bigcat48]

yes. it worked. but too many steps. thinking I should create a macro.

maybe just a complaint and a little whining.

 

[SkipVought]

You only have to do that concatenation ONCE, and then drop new data into the source area.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}