Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Hi All,
I have a file with data as below:
A,FILE1_MYFILE_20130309_1038,80,25.60
B,FILE1_MYFILE_20130309_1038,24290,18543.38
C,FILE1_dsc_dlk_MYFILE_20130309_1038,3,10.10
A,FILE2_MYFILE_20130310_1039,85,110.10
B,FILE2_MYFILE_20130310_1039,10,12.10... (10 Replies)
Hi all I have a need of searching some pattern in file by month and then count unique records
D11
G11
R11 -------> Pattern available in file
S11
Jan$1 to $5 column contains some records in which I want to find unique
for this purpose I have written script like below
awk '/Jan/ ||... (4 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Hi All,
I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record.
For example, let's assume for column D... (9 Replies)
file:
1|12322|tow|
5|23422|pow|
6|23423|cow|
3|34324|how|
deletelines:
12322
23423
My command to delete line
while read NUM
do
awk -F"\|" '$2 !~ /`"$NUM"`/' file >file.back
mv file.back file
done<deletelines (3 Replies)
Hi all,
I have searched and searched, but I have not found a solution that quite fits what I am trying to do.
I have a long list of data in three columns. Below is a sample:
1,10,8
2,12,10
3,13,12
4,14,14
5,15,16
6,16,18
Please use code tags
What I need to do is as follows: If a... (4 Replies)
Discussion started by: bleedingturnip
4 Replies
LEARN ABOUT OPENSOLARIS
etrn
etrn(1M) System Administration Commands etrn(1M)NAME
etrn - start mail queue run
SYNOPSIS
etrn [-b] [-v] server-host [client-hosts]
DESCRIPTION
SMTP's ETRN command allows an SMTP client and server to interact, giving the server an opportunity to start the processing of its queues
for messages to go to a given host. This is meant to be used in start-up conditions, as well as for mail nodes that have transient connec-
tions to their service providers.
The etrn utility initiates an SMTP session with the host server-host and sends one or more ETRN commands as follows: If no client-hosts are
specified, etrn looks up every host name for which sendmail(1M) accepts email and, for each name, sends an ETRN command with that name as
the argument. If any client-hosts are specified, etrn uses each of these as arguments for successive ETRN commands.
OPTIONS
The following options are supported:
-b System boot special case. Make sure localhost is accepting SMTP connections before initiating the SMTP session with server-host.
This option is useful because it prevents race conditions between sendmail(1M) accepting connections and server-host attempting to
deliver queued mail. This check is performed automatically if no client-hosts are specified.
-v The normal mode of operation for etrn is to do all of its work silently. The -v option makes it verbose, which causes etrn to display
its conversations with the remote SMTP server.
ENVIRONMENT VARIABLES
No environment variables are used. However, at system start-up, svc:/network/smtp:sendmail reads /etc/default/sendmail. In this file, if
the variable ETRN_HOSTS is set, svc:/network/smtp:sendmail parses this variable and invokes etrn appropriately. ETRN_HOSTS should be of the
form:
"s1:c1.1,c1.2 s2:c2.1 s3:c3.1,c3.2,c3.3"
That is, white-space separated groups of server:client where client can be one or more comma-separated names. The :client part is optional.
server is the name of the server to prod; a mail queue run is requested for each client name. This is comparable to running:
/usr/lib/sendmail -qR client
on the host server.
EXAMPLES
Example 1 Using etrn
Inserting the line:
ETRN_HOSTS="s1.domain.com:clnt.domain.com s2.domain.com:clnt.domain.com"
in /etc/default/sendmail results in svc:/network/smtp:sendmail invoking etrn such that ETRN commands are sent to both s1.domain.com and
s2.domain.com, with both having clnt.domain.com as the ETRN argument.
The line:
ETRN_HOSTS="server.domain.com:client1.domain.com,client2.domain.com"
results in two ETRN commands being sent to server.domain.com, one with the argument client1.domain.com, the other with the argument
client2.domain.com.
The line:
ETRN_HOSTS="server1.domain.com server2.domain.com"
results in set of a ETRN commands being sent to both server1.domain.com and server2.domain.com; each set contains one ETRN command for each
host name for which sendmail(1M) accepts email, with that host name as the argument.
FILES
/etc/mail/sendmail.cf sendmail configuration file
/etc/default/sendmail Variables used by svc:/network/smtp:sendmail
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsndmu |
+-----------------------------+-----------------------------+
|Interface Stability |Stable |
+-----------------------------+-----------------------------+
SEE ALSO sendmail(1M), attributes(5)
RFC 1985
NOTES
Not all SMTP servers support ETRN.
SunOS 5.11 10 Aug 2004 etrn(1M)