XMITIP, sending the mainframe data in .CSV format

dharmaraok · New User Joined: 10 Mar 2011 Posts: 45 Location: india

Through XMITIP I am sending the mainframe data in .CSV format.

Eg:

Account
00012

When I opened the execl sheet. I am seeing the Account a "12" instead of "00012".

Could you please let me know how to transmit the data without truncation of leading zeroes through XMIT command.

Bill Woodger · Posted: Fri Aug 21, 2015 4:31 pm

Look at your .CSV file. Are the leading zeros there? Do you know how to "format" a cell in Excel?

dharmaraok · New User Joined: 10 Mar 2011 Posts: 45 Location: india

There are no leading zeroes in the excell cell. I don want to format the cell. It should come as it is .

Nic Clouston · Posted: Fri Aug 21, 2015 4:39 pm

Then make it a text field - excel removes leading zeros from numerics.

dharmaraok · New User Joined: 10 Mar 2011 Posts: 45 Location: india

Thanks Nic,

How to make the field into a text field

Nic Clouston · Posted: Fri Aug 21, 2015 4:45 pm

Put quotes around the data. How else?

dharmaraok · New User Joined: 10 Mar 2011 Posts: 45 Location: india

Thanks

Bill Woodger · Posted: Fri Aug 21, 2015 4:48 pm

I didn't ask about what was in the cell, you already complained about that. I asked about what is in the .CSV. The leading zeros will be there. You can "format" the cell so that it does not suppress the leading zeros.