Sponsored Content
Top Forums Shell Programming and Scripting How to convert the data into excel sheet and send mail using 'mailx' command Post 302246877 by sanbabu on Tuesday 14th of October 2008 03:37:34 PM
Old 10-14-2008
Hi Joeyg

Thanks for the reply but the stored proc is not generating any file, it's just a report that is directly mailed using mailx command. I want to create an excel file with that output and mail the same using mailx command.

any thoughts on this

thanks
sanbabu
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

how to read the data from an excel sheet and use those data as variable in the unix c

I have 3 columns in an excel sheet. c1 c2 c3 EIP_ACCOUNT SMALL_TS_01 select A.* from acc; All the above 3 col shoud be passed a variable in the unix code. 1.How to read an excel file 2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies

2. Shell Programming and Scripting

Problem with Mailx command to send mail with attachment

Hi, I am using mailx command to send a mail with attachment. It's working fine, but with attachment I am getting one extra attachment like (ATT00131.txt). I have tried to use unix2dos command also. But still I am getting the extra attachment. I am using the following code: subject="temp... (5 Replies)
Discussion started by: viswanatharv
5 Replies

3. UNIX for Dummies Questions & Answers

Unable to send e-mail using mailx command

Hi All, Can you please help me in solving this. I am facing some problem sending mails. If I use like this, I am able to send mail the mail echo "This is an automated e-mail; please do not reply." | mailx -s "Good Morning ." 'abc@xys.com' But if I use like this, then I am unable to send... (1 Reply)
Discussion started by: manas6
1 Replies

4. Shell Programming and Scripting

mail a csv file as an excel sheet!

Hi, The result of a script is a csv file in the following format: cat $file_name DATA_USAGE_FACT,YES_NO_FLG,TARGET_TABLE,YES_NO_FLG,1,0,15,0 DATA_USAGE_FACT,DATE_OF_CREATION,TARGET_TABLE,DATE_OF_CREATION,29,9,19,0 DATA_USAGE_FACT,UPDATION_DATE,TARGET_TABLE,UPDATION_DATE,29,9,19,0... (3 Replies)
Discussion started by: dips_ag
3 Replies

5. Shell Programming and Scripting

Perl : not capturing all the data from excel sheet

Hi folks, I am working on assignment that captures all the records(2 columns one column contains names and other contain date of birth) from excel sheet stored in a directory and checks for current date and month. If it matches current date and month then the matched records are printed as... (1 Reply)
Discussion started by: giridhar276
1 Replies

6. Shell Programming and Scripting

Mailx command - send mail as table format

I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong. Intended Output in mail body: Col1 Col2 Col3 ------ ... (2 Replies)
Discussion started by: qwertyu
2 Replies

7. Shell Programming and Scripting

Not able to send the mail using mail and mailx command

Hi All, I am trying to send a mail from linux server but could'nt able to send the mail. I tried the below syntax's so far but no luck. mail -s “Hello world” abc@xyz.com < /usr/g/txt.log cat "txt.log" | mailx -s "Hello world" abc@xyz.com mailx -s “Hello world” abc@xyz.com <... (2 Replies)
Discussion started by: scriptscript
2 Replies

8. UNIX for Dummies Questions & Answers

Load UNIX data into excel sheet

Hi, i have some data in a temporary file in Unix (the data is taken from the result of an SQL query). Now i want to dump that data into an excel sheet. How to do that. Someone please advise. Thanks Regards, Vinit (3 Replies)
Discussion started by: vinit raj
3 Replies

9. Shell Programming and Scripting

Summing up the data from different excel sheet into one excel sheet

Hi Folks, Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are 1excel.xslx 2excel.xslx 3excel.xslx now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Discussion started by: punpun66
3 Replies

10. Shell Programming and Scripting

Need to convert text file into Excel sheet

:cool:Hi, Iam new to this Scripts and forum too. Plz excuse if may i ask silly questions now and further.. Prob: i need to convert txt files data into excel sheet. Suppose if i have hour-wise data in txt file1 and file2 like file1 file2 00: 140 00: 235 01: 160 01:415... (1 Reply)
Discussion started by: mrudula
1 Replies
uuencode(1)						      General Commands Manual						       uuencode(1)

NAME
uuencode, uudecode - Encodes or decodes a binary file SYNOPSIS
uuencode [file] remotefile uudecode [file...] STANDARDS
Interfaces documented on this reference page conform to industry standards as follows: uudecode: XCU5.0 uuencode: XCU5.0 Refer to the standards(5) reference page for more information about industry standards and associated tags. DESCRIPTION
The uuencode and uudecode commands are used to send a binary file via uucp or other mail. This combination can be used over indirect mail links even when uusend is not available. The uuencode command takes the named file (default standard input) and produces an encoded version on the standard output. The encoding uses only printing ASCII characters, and includes the mode of the file and the name for re-creation on the remote system, specified by remotefile. The uudecode command reads an encoded file, strips off any leading and trailing lines added by mailers, and recreates the original file with the specified mode and name. Filter the encode through the uudecode program. Filtering the file causes the original file to be auto- matically recreated. This is possible on the uucp network by using sendmail or by making rmail be a link to mailx. In each case, an alias must be created in a master file to get the automatic invocation of uudecode. If neither of the preceding facilities is available on a user's system, uudecode can be applied to the file manually by editing the file with any text editor, removing the trailing and leading lines, and changing the mode or remote system name. The encoded file is an ordinary text file. EXAMPLES
In the following example, the ex1 file is encoded; the output is also redirected to the ex1.out file: prompt> uuencode ex1 ex1.en > ex1.out If the source ex1 file is as follows: This example shows how to encode a file using uuencode and how to decode a file using uudecode. The encoded ex1.out file would be as follows: begin 644 ex1.en M5&AI<R!E>&%M<&QE('-H;W=S"G1H92!H;W<@=&@96YC;V1E"F$@9FEL92!U M<VEN9PIU=65N8V]D90IA;F0@:&]W('1O"F1E8V]D92!A(&9I;&4*=7-I;F<@ *=75D96-O9&4N"F]D ` end In the following example, the ex1.out file is decoded: prompt> uudecode ex1.out In this example, the uudecode command decodes the file and puts the output in ex1.en. To package up a source tree using tar, com- press it, uuencode it, and mail it to a user on another system, enter: tar cf - src_tree | compress | uuencode src_tree.tar.Z | mail sys1!sys2!user1 (Enter the command entirely on one line, not on two lines as shown above.) When uudecode is run on the target system, the src_tree.tar.Z file is created; it may then be uncompressed and dearchived with tar. SEE ALSO
Commands: ct(1), cu(1), mailx(1), Mail(1), rmail(1), sendmail(8), tip(1), uucico(8), uucleanup(8), uucp(1), uulog(1), uuname(1), uupick(1), uusched(8), uusend(1), uustat(1), uuto(1), uux(1) Standards: standards(5) uuencode(1)
All times are GMT -4. The time now is 02:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy