Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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: 1753
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: 4648
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: 8004
Location: Bellevue, IA

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 Changing of LRECL of a file abdulrafi DFSORT/ICETOOL 2 Fri Mar 24, 2017 3:25 pm
No new posts splitting a file abdulrafi DFSORT/ICETOOL 4 Fri Mar 24, 2017 11:51 am
No new posts Receive a file using PCOMM macro Harald.v.K IBM Tools 0 Thu Mar 23, 2017 6:50 pm
No new posts FTP from Mainframe to Unix - with CRLF vasanthz All Other Mainframe Topics 7 Thu Mar 23, 2017 5:12 am
No new posts Want to pull the job log into a Mainf... Jishu Mukherjee Compuware & Other Tools 9 Tue Mar 21, 2017 4:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us