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



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

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

Postby Papya013 » Fri Feb 09, 2018 3:53 pm

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
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby Robert Sample » Fri Feb 09, 2018 6:15 pm

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.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

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

Postby Papya013 » Fri Feb 09, 2018 6:24 pm

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
Papya013
 
Posts: 35
Joined: Wed Nov 06, 2013 6:53 pm
Has thanked: 0 time
Been thanked: 0 time

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

Postby NicC » Fri Feb 09, 2018 7:47 pm

Have you told Excel that the fields are period-delimited and not comma-delimited?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post