Facing Issue while sending a delimited mainfr file to CSV
Posted: Sat Oct 22, 2016 4:38 am
Hello everyone,
It will be great if anyone could suggest me on my below query.
I have a jcl which is sending a delimited (delimited by , ) mainframe PS file as .CSV in email.
What happening is one of the field of file is have , within it, so in excel it getting separated bcz it is treated as delimiter but actually it is not. I need whole record together
of that fields.
I have attached my delimited mainframe file and the screenshot of excel which actually I am getting and I have also attached what I am expecting, that screenshot will more clear it actually what my concern is.
Thanks for looking into this.
It will be great if anyone could suggest me on my below query.
I have a jcl which is sending a delimited (delimited by , ) mainframe PS file as .CSV in email.
What happening is one of the field of file is have , within it, so in excel it getting separated bcz it is treated as delimiter but actually it is not. I need whole record together
of that fields.
I have attached my delimited mainframe file and the screenshot of excel which actually I am getting and I have also attached what I am expecting, that screenshot will more clear it actually what my concern is.
Thanks for looking into this.