Sponsored Content
Top Forums UNIX for Beginners Questions & Answers Merge Text with space into once cell and send email out Post 303041301 by lpoolfc on Wednesday 20th of November 2019 09:09:31 PM
Old 11-20-2019
Merge Text with space into once cell and send email out

Please help!!

This code works perfect but the only problem I am having is that is treats eg SQL Developer as separate cell/column which makes the formatting bad. I want to put SQL Developer in one cell. I attached a sample of how the output looks like.

report.txt
Code:
USERNAME             OSUSER       MACHINE              PROGRAM                                 COUNT(*)             
-------------------- ------------ -------------------- -------------------------                              ----------             
xxxxxxx                       xxxxxxx      xxxxxxx         	    Toad.exe                                       5             
xxxxxxx                       xxxxxxx      xxxxxxx                     SQL Developer                          4

Code:
awk ' BEGIN {
 print "From: from@x.com"
 print "To: to@x.com"
 print "MIME-Version: 1.0"
 print "Content-Type: text/html"
 print "Subject: Your Subject"
 print "<html><body><table border=1 cellspacing=2 cellpadding=3>"
 print "<tr>"
 print "</tr>"
} {
 print "<tr>"
 print "<td>"$1"</td>";
 print "<td>"$2"</td>";
 print "<td>"$3"</td>";
 print "<td>"$4"</td>";
 print "<td>"$5"</td>";
 print "</tr>"
} END {
 print "</table></body></html>"
} ' report.txt | sendmail -t

Merge Text with space into once cell and send email out-capturepng

Last edited by Scrutinizer; 11-26-2019 at 05:11 PM.. Reason: Additional code tags
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Unable to send eMail from a UNIX-Host ( using mailx ) to a Outlook-email-addres(Win)

Hi A) I am able to send eMail using mailx from a UNIX ( solaris 8 ) host to my Outlook-email-ID : FName.Surname@Citigroup.com ( This is NOT my actual -eMail-ID). But in Outlook the "From :" eMail address is displayed as " usr1@unix-host1.unregistered.email.citicorp.com " .i.e the words... (2 Replies)
Discussion started by: Vetrivela
2 Replies

2. Shell Programming and Scripting

shell script to send email with usage of space in the directory as description :

shell script to send email with usage of space in the directory as description : Please any one help me in writing a script to send email with usage of space in the directory as description . (3 Replies)
Discussion started by: sakthifire
3 Replies

3. UNIX for Dummies Questions & Answers

File need to send to xls as one complete cell

Hi every one, I have a file of ten lines in unix i want to send the file to my mail as .xls and the clause over here is it should send in only one cell .. I am aware of uuencode rest rest.xls | mail -s "testing" mailid But this would send me data into seperate cells (5 Replies)
Discussion started by: rakesh_pagadala
5 Replies

4. Shell Programming and Scripting

Check space of directories and send email if it has reached threshold limit

Hi, I need help in writing unix script for checking space of some directories on the system and also send an email when it reaches the threshold limit. I have written the followng code; #!/bin/ksh ADMIN="me@somewhere.com" # set alert level 80% is default THRESHOLD=80 df | grep -E... (5 Replies)
Discussion started by: jmathew99
5 Replies

5. Shell Programming and Scripting

Script to send email after comparing the folder permissions to a certain permission & send email

Hello , I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them . I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Discussion started by: nairshar
2 Replies

6. UNIX for Dummies Questions & Answers

new to ldap, send email to a ou or group, and see a list from email client

hi, i'm running openldap on ubuntu 10.04, creating new items with apache directory studio (windows version). i use the ldap just as an address book to our small office (email clients are windows live mail 2009, 2011, microsoft outlook 2007 and 2010). a. i cant see a list of the contacts,... (0 Replies)
Discussion started by: V4705
0 Replies

7. Shell Programming and Scripting

How to read specific line of text from a Script and send email notification

Hi ! I am a newbie and never officially wrote a shell script before. The requirement for this script is : 1) Read a file called 'bpm.log' and identify if it has a specific text such as 'this is the text'. Its a static value and that is the only text we need to read. 2) If that... (2 Replies)
Discussion started by: atechcorp
2 Replies

8. UNIX for Dummies Questions & Answers

Need help combining txt files w/ multiple lines into csv single cell - also need data merge

:confused:Hello -- i just joined the forums. I am a complete noob -- only about 1 week into learning how to program anything... and starting with linux. I am working in Linux terminal. I have a folder with a bunch of txt files. Each file has several lines of html code. I want to combine... (2 Replies)
Discussion started by: jetsetter
2 Replies

9. Shell Programming and Scripting

Read a file, add some text and send an email

Hi, If I am asking this question, you must have already figured out , that I am new to Unix, so here it goes I was trying to read a file, add some user defined content to it and send out an email , I did find out a way to achieve this, but looking at the code, it looks a bit crude to me, can... (3 Replies)
Discussion started by: karthikbhuvana
3 Replies

10. Shell Programming and Scripting

Send Disk Space Usage Status via email

Hi Guys, Is there any way I can write a script that sends DISK SPACE USAGE STATUS via email once a week? Thanks, (5 Replies)
Discussion started by: g4v1n
5 Replies
print-service(1M)					  System Administration Commands					 print-service(1M)

NAME
print-service - select, report, import, export active print service on a system SYNOPSIS
print-service [-s service [-m] | -q | -e file | -i file] DESCRIPTION
The print-service utility manages print service selection, as well as export and import of basic print queue configuration. Only a user root privileges or with the Printer Management profile can change the active print service or import print queue configuration. OPTIONS
The following options are supported: -s service Select the active print service for on a host. service can be one of lp or cups. -m Migrate print queue configuration during print service selection. -q Report the active print service on a host. -e file Export basic print queue configuration to a file. -i file Import basic print queue configuration from a file. EXAMPLES
Example 1 Selecting a Print Service The following command selects the CUPS print service as the active print service on a host. # print-service -s cups Example 2 Reporting the Active Print Service The following command reports the active print service on a host. # print-service -q Example 3 Exporting a Print Queue Configuration The following command exports the print queue configuration from the active print service. # print-service -e /tmp/queues Example 4 Importing a Print Queue Configuration The following command imports the print queue configuration to the active print service. # print-service -i /tmp/queues EXIT STATUS
0 Successful completion. non-zero An error occurred. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWpcu | +-----------------------------+-----------------------------+ |Interface Stability |Obsolete | +-----------------------------+-----------------------------+ SEE ALSO
intro(1), attributes(5) NOTES
The print queue configuration saved and restored during export, import, and migration is limited to queue name and device name. It is likely that further configuration changes will be required before imported or migrated print queues become usable. SunOS 5.11 18 Mar 2008 print-service(1M)
All times are GMT -4. The time now is 07:56 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy