Thanks Ranga.... your command working fine and i redirected to new file.
But in the original file when i press end it is showing as 3001 but in the new generated file it is showing as 3002. Please let me know what could be the reason.
thanks,
Kiran
Last edited by Scrutinizer; 12-21-2012 at 07:17 AM..
Reason: code tags
Hi guys,
I want to use a quick one liner that can copy an entire column, and add it to a new file as another column. I've tried using cat, but that only appends my column to the bottom of the file.
So now, my first file(file1) looks like this:
1995060101 8
1995060102 6
1995060102... (1 Reply)
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Hi,
i have file which contains only one record like below
a|b|c|....
The no of columns is not known. The expected output is as below:
a|a|b|b|c|c|...
Please provide me your suggestions.
OS: unix
Thanks,
Selva (7 Replies)
I want to copy column no 3 to the end of column
example :
alter table RECOVER_USR.MPULKIXD rename to
alter table RECOVER_USR.CS_ADV_PROMO rename to
alter table RECOVER_USR.BCH_HISTORY_TABLE rename to
alter table BILLOPS.HISHAM_DATAPLUS_FINAL rename to
alter table... (8 Replies)
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)
Dear Gurus,
I have a unix file 2 columns (# delimited) with the following data:
ZTXX_CTBR1-ZBRAN1#ZTXX_CTBR1-ZBRAN_DESC#
01#CASH & CARRY#
02#DRUGSTORE - RX#
04#SUPERMARKET#
05#HYPERMARKET#
17#DRUGSTORE - NO RX#
I would like to have a code that will do 2 things:
1. Delete the header... (16 Replies)
I have data of an excel files as given below,
file1
org1_1 1 1 2.5 100
org1_2 1 2 5.5 98
org1_3 1 3 7.2 88
file2
org2_1 1 1 2.5 100
org2_2 1 2 5.5 56
org2_3 1 3 7.2 70
I have multiple excel files as above shown.
I have to copy column 1, column 4 and paste into a new excel file as... (26 Replies)
Discussion started by: dineshkumarsrk
26 Replies
LEARN ABOUT OPENSOLARIS
mailq
mailq(1) User Commands mailq(1)NAME
mailq - print the mail queue
SYNOPSIS
/usr/bin/mailq [-Ac] [-q subarg] [-v]
DESCRIPTION
The mailq utility displays a summary of the mail messages queued for future delivery.
The first line displayed for each mail message shows the internal identifier used on this host for the message, the size of the message in
bytes, the date and time the message was accepted into the queue, and the envelope sender of the message. The second line of the display
shows the error message that caused this message to be retained in the queue. This line will not be displayed if the message is being pro-
cessed for the first time.
The mailq utility used to be identical to sendmail -bp. Now it checks for the authorization attribute, solaris.mail.mailq. If the check for
the invoking user succeeds, sendmail -bp is executed with the remaining argument vector. Otherwise, an error message is printed. This
authorization attribute is by default enabled for all users. It can be disabled by modifying the Basic Solaris User entry in prof_attr(4).
OPTIONS
The following options are supported:
-Ac Like sendmail(1M), this flag tells mailq to use submit.cf rather than sendmail.cf even if the operation mode does
not indicate an initial mail submission. This will result in the client queue /var/spool/clientmqueue being displayed
rather than the default server queue /var/spool/mqueue.
-qp[time] Similar to -qtime, except that instead of periodically forking a child to process the queue, sendmail forks a single per-
sistent child for each queue that alternates between processing the queue and sleeping. The sleep time is given as the
argument. The sleep time default is 1 second. The process will always sleep at least 5 seconds if the queue was empty in
the previous queue run.
-qf Processes saved messages in the queue once and does not fork(), but runs in the foreground.
-qG name Processes jobs in the queue group called name only.
-q[!]I substr Limits processed jobs to those containing substr as a substring of the queue id, or not when ! is specified.
-q[!]R substr Limits processed jobs to those containing substr as a substring of one of the recipients, or not when ! is specified.
-q[!]S substr Limits processed jobs to those containing substr as a substring of the sender, or not when ! is specified.
-v Prints verbose information. This adds the priority of the message and a single character indicator (+ or blank) indicating
whether a warning message has been sent on the first line of the message. Additionally, extra lines may be intermixed with
the recipients that indicate the "controlling user" information. This shows who will own any programs that are executed on
behalf of this message and the name of the alias this command is expanded from, if any.
EXIT STATUS
0 Successful completion.
>0 An error occurred.
FILES
/etc/security/prof_attr local source for execution profile attributes
/var/spool/mqueue default server queue
/var/spool/clientmqueue client queue
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWsndmu |
+-----------------------------+-----------------------------+
SEE ALSO sendmail(1M), prof_attr(4), attributes(5)SunOS 5.11 10 Jul 2002 mailq(1)