Page 1 of 1

Issue with .csv file when sending it through email by JCL

PostPosted: Fri Feb 09, 2018 3:53 pm
by Papya013
Hi Team,

I have a delimited file ( delimiter is "."). When I am trying to send the file by using JCL in .csv format. I am getting all the fields in only one column.

Input
BALESH.123.ABC.789

Expected outcome:

BALESH 123 ABC 789 in four different columns on the .csv file.

Please help me to fix this.

Regards,
Balesh GG

Re: Issue with .csv file when sending it through email by JC

PostPosted: Fri Feb 09, 2018 6:15 pm
by Robert Sample
Your output file will be BALESH.123.ABC.789 -- EXACTLY WHAT THE INPUT DATA SET WAS! It is up to you to MANUALLY open the .csv file in Excel; once you do that and tell Excel to use the period as a field separator you will have the data in 4 columns in Excel.

You provided your expected output, but you did NOT provide any information about the difference between your expected output and the actual output.

Re: Issue with .csv file when sending it through email by JC

PostPosted: Fri Feb 09, 2018 6:24 pm
by Papya013
Hi Robert,

Sorry for not providing the complete information.

Current outcome:

BALESH.123.ABC.789 which is populated in only one column of the .csv file

Expected outcome:

BALESH 123 ABC 789 in four different columns on the .csv file.

Please let me know if this information helps to help me :)

Regards,
Balesh GG

Re: Issue with .csv file when sending it through email by JC

PostPosted: Fri Feb 09, 2018 7:47 pm
by NicC
Have you told Excel that the fields are period-delimited and not comma-delimited?