IBM Mainframe Forum

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

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.

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

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