How do I insert a new line for export to excel

[ChrisJeff]

Hi,
I have a REXX that scans through a PDS and gathers information to be placed into a another PDS which I then receive from the mainframe as a text file then import to a excel file.
What I need is to have some of the information to be in the same cell but with a line NEWLINE between it.
Can someone please assist with a tip.
This is the current code I am using"
if left(in.recid,1) = "I" then do
incond = incond || substr(in.recid,2,79) || "0A"x

however this does not appear to be working.
Your help is greatly appreciated.

 

[RxUsr]

Have you tried making it a csv file?
'"'||LineOneData||'0A'x||LineTwoData||'"'
Name the file Something.csv
Open it with EXCEL

 

[nclouston]

Isn't newline crlf and therefore '0a0d'x? (unless you are running on *nix)


Nic

 

[nclouston]

In ISPF edit set hex on and insert the hex codes directly into the bytes rather than trying to pass a hex string.


Nic