10-14-2008
Investigate writing the file as .csv
Set your write commands, or modify the existing file to put comma's between each field. Also, save the file with a .csv extension. Excel will naturally open a .csv file.
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
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
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
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
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
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
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
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
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
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
: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
LEARN ABOUT DEBIAN
mhmail
MHMAIL(1) [nmh-1.5] MHMAIL(1)
NAME
mhmail - send or read mail
SYNOPSIS
mhmail [addrs ...] [-body text] [-cc addrs ...] [-from addr] [-subject subject] [-version] [-help]
DESCRIPTION
mhmail is intended as a replacement for the standard Berkeley mail program (mail or mailx), which is compatible with nmh. This program is
intended for the use of programs such as cron, which expect to send mail automatically to various users. It is also used by various nmh
commands to mail various error notifications. Although mhmail can be used interactively, it is recommended that comp and send be used
instead to send messages.
When invoked without arguments, it simply invokes inc to incorporate new messages from the user's maildrop. When one or more users is
specified, a message is read from the standard input and spooled to a temporary file. mhmail then invokes post with the name of the tempo-
rary file as its argument to deliver the message to the specified user.
The -subject subject switch can be used to specify the "Subject:" field of the message.
By default, mhmail will read the message to be sent from the standard input. You can specify the text of the message at the command line
with the -body text switch. If the standard input has zero length, mhmail will not send the message. You can use the switch -body "" to
force an empty message.
Normally, addresses appearing as arguments are put in the "To:" field. If the -cc switch is used, all addresses following it are placed in
the "cc:" field.
By using -from addr, you can specify the "From:" header of the draft. Naturally, post will fill-in the "Sender:" header correctly.
FILES
/usr/bin/mh/inc Program to incorporate maildrop into folder
/usr/lib/mh/post Program to deliver a message
/tmp/mhmail* Temporary copy of message
SEE ALSO
inc(1), post(8)
DEFAULTS
None
CONTEXT
If inc is invoked, then inc's context changes occur.
MH.6.8 11 June 2012 MHMAIL(1)