IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need to modify csv file properties through mainframe.


IBM Mainframe Forums -> PC Guides & IT News
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Keanehelp

New User


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

PostPosted: Tue Oct 05, 2010 7:33 pm
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: 1788
Location: Bloomington, IL

PostPosted: Tue Oct 05, 2010 7:45 pm
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: 71
Location: USA, CA.

PostPosted: Tue Oct 05, 2010 7:48 pm
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

Superior Member


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

PostPosted: Tue Oct 05, 2010 7:48 pm
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: 71
Location: USA, CA.

PostPosted: Tue Oct 05, 2010 7:54 pm
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

Superior Member


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

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

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

Global Moderator


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

PostPosted: Tue Oct 05, 2010 7:59 pm
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: 8696
Location: Dubuque, Iowa, USA

PostPosted: Tue Oct 05, 2010 8:10 pm
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: 71
Location: USA, CA.

PostPosted: Tue Oct 05, 2010 8:10 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> PC Guides & IT News

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Mainframe openings in Techmahnidra fo... Mainframe Jobs 0
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top