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

[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

[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.

[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

[NicC]

Have you told Excel that the fields are period-delimited and not comma-delimited?