Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need to modify csv file properties through mainframe.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News
View previous topic :: :: View next topic  
Author Message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Tue Oct 05, 2010 7:33 pm    Post subject: Need to modify csv file properties through mainframe.
Reply with quote

Hi,

We create csv file and then mail it as an attachment by using XMIT command.

I want to know that if there is a way to modify the csv file properties from mainframe code? For ex if I want to make content of one particular cell in csv file as bold, how can I do this?

Just for reference, We use following code to create the file

Content-Disposition: attachment;
filename="ABC.csv"
Content-Type: text/text
<PRE> <FONT FACE="COURIER NEW" SIZE=1>
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1777
Location: Bloomington, IL

PostPosted: Tue Oct 05, 2010 7:45 pm    Post subject:
Reply with quote

Are you creating an actual comma-separated value (CSV) file, or a HTML file? If the latter, you can use the HTML <STRONG> or <B> tags.
Back to top
View user's profile Send private message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Tue Oct 05, 2010 7:48 pm    Post subject:
Reply with quote

We are creating a comma separated file only. Any suggestion for modifying these files??
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 05, 2010 7:48 pm    Post subject:
Reply with quote

AFAIK, not without involving some third party tool/utilities. Because, you cannot send a message from the mainframe and have the body of the message in anything except plain text characters. This is one of the Internet standards not a choice (unless I missed some memo).
Back to top
View user's profile Send private message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Tue Oct 05, 2010 7:54 pm    Post subject:
Reply with quote

Two things:

1. We are sending CSV file as attachement and I need to modify properties of this file.( NOT concerned about body of the mail.)

2. Please let me know if there is any tool available for such a thing.

Thanks.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Oct 05, 2010 7:58 pm    Post subject:
Reply with quote

Look here: https://www.uic.edu/depts/accc/newsletter/adn13/mime.html
And this thread: http://www.ibmmainframes.com/viewtopic.php?t=46976&postdays=0&postorder=asc&start=15
Back to top
View user's profile Send private message
superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4650
Location: Raleigh, NC, USA

PostPosted: Tue Oct 05, 2010 7:59 pm    Post subject: Reply to: Need to modify csv file properties through mainfra
Reply with quote

I'm confused.

What happens to these csv files after you email them? It would seem to me that the potential answer lies in what is done with them at that point. If I were to receive a csv file and open it up on my desktop with Notepad, I don't think I'd be able to see any special formatting.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8165
Location: East Dubuque, Illinois, USA

PostPosted: Tue Oct 05, 2010 8:10 pm    Post subject:
Reply with quote

If you go into Microsoft Excel and get help on CSV files, you will find:
Quote:
CSV (Comma delimited)
This file format (.csv) saves only the text and values as they are displayed in cells of the active worksheet. All rows and all characters in each cell are saved. Columns of data are separated by commas, and each row of data ends in a carriage return. If a cell contains a comma, the cell contents are enclosed in double quotation marks.

If cells display formulas instead of formula values, the formulas are converted as text. All formatting, graphics, objects, and other worksheet contents are lost. The euro symbol will be converted to a question mark.

Note If your workbook contains special font characters such as a copyright symbol (©), and you will be using the converted text file on a computer with a different operating system, save the workbook in the text file format that is appropriate for that system. For example, if you are using Windows and want to use the text file on a Macintosh computer, save the file in the CSV (Macintosh) format. If you are using a Macintosh computer and want to use the text file on a system running Windows or Windows NT, save the file in the CSV (Windows) format.
Since EXCEL only saves the text and values (not the formatting), why are you wanting to create something that Excel won't handle? In other words, it generally is not possible (without writing your own processing program on the PC) to use bold or other attributes in a CSV file.
Back to top
View user's profile Send private message
Keanehelp

New User


Joined: 27 May 2008
Posts: 70
Location: USA, CA.

PostPosted: Tue Oct 05, 2010 8:10 pm    Post subject:
Reply with quote

@ Kevin,

Our Csv file will be opened with excel.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> PC Guides & IT News All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Identifying Interfaces in CICS/mainframe Ashishpanpaliya CICS 5 Fri Oct 13, 2017 3:21 pm
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
This topic is locked: you cannot edit posts or make replies. PS file data should be passed as symb... d_sarlie JCL & VSAM 15 Tue Oct 03, 2017 5:18 am
No new posts Garbage on output file Hervey Martinez SYNCSORT 4 Wed Sep 27, 2017 12:50 am
No new posts Mainframe scheduling tool ddhar Compuware & Other Tools 2 Wed Sep 27, 2017 12:48 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us