How can i set a variable field delimiter using awk??
I wanna do something like this ,but i canīt get the correct syntaxis :
VARI=TEST
echo "0121212TESTxvcshaashd"|awk 'FS="$VARI" {print $2}'
Thanks. (2 Replies)
Hello,
I had posted earlier about printing fields using AWK, but now I have a slightly different problem. I have text files in the format:
1*2,3,4,5
and wish to print the first, third, and fifth fields, including the asterisk and commas. In other words, after filtering it should look... (1 Reply)
Hello,
I need an awk script to receive a variable that's an decimal value such as 009 or 031 and then convert this value to an ascii character to use as the FS (field separator for the input file).
For example,
009 should be converted to an ascii tab
031 should be converted to an ascii... (1 Reply)
Dear All,
1.txt (tab in between each value in a line)
a b c
a b c
a c d
you can see below, why with ~ i can output with tab, but = cannot?
# awk -F'\t' '$2 ~ /b/' 1
a b c
a b c
# awk -F'\t' '$2 = "b"' 1
a b c
a b c
a b d
... (1 Reply)
Hi All,
I wanted to find 200th field value in delimiter file using awk.?
awk '{print $200}' inputfile
I am getting error message :-
awk: The field 200 must be in the range 0 to 199.
The source line number is 1.
The error context is
{print >>> $200 <<< }
using... (4 Replies)
Hello, I am using awk to match text in a tab separated field and am able to do so when matching the exact word. My problem is that I would like to match any sequence of text in the tab-separated field without having to match it all. Any help will be appreciated. Please see the code below.
awk... (3 Replies)
hi,
just wanted to make a shortcut of this one
a="a b c"
b=`echo $a | awk '{print $2}'`
echo "the middle is $b"
why can't i do this:
a="a b c"
echo "the middle is ${`echo $a | awk '{print $2}'`}" <- bad substitution :wall:
thanks (6 Replies)
Hi Experts,
i need to change delimiter from tab to ","
sample test file
cat test
A0000368 A29938511 072569352 5 Any 2 for Ģ1.00 BUTCHERS|CAT FOOD|400G Sep 12 2012 12:00AM Jan 5 2014 11:59PM Sep 7 2012 12:00AM M 2.000 group 5
... (2 Replies)
We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below.
Current file (file.csv)
----------------------
empname,date_of_join,dept,date_of_resignation
ram,08/09/2015,sales,21/06/2016
"akash,sahu",08/10/2015,IT,21/07/2016
... (6 Replies)
I will start with an example of what I'm trying to do and then describe how I am approaching the issue.
File
PS028,005
Lexeme HRS # M #
PhraseType 1(1:1) 7(7)
PhraseLab 501 503
ClauseType ZYq0
PS028,005
Lexeme W # L> # BNH # M #... (17 Replies)
Discussion started by: jvoot
17 Replies
LEARN ABOUT FREEBSD
mailq
MAILQ(1) General Commands Manual MAILQ(1)NAME
mailq - print the mail queue
SYNOPSIS
mailq [-Ac] [-q...] [-v]
DESCRIPTION
Mailq prints a summary of the mail messages queued for future delivery.
The first line printed for each message shows the internal identifier used on this host for the message with a possible status character,
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 shows the error message that caused this message to be retained in the queue; it will not be present if the message is being
processed for the first time. The status characters are either * to indicate the job is being processed; X to indicate that the load is
too high to process the job; and - to indicate that the job is too young to process. The following lines show message recipients, one per
line.
Mailq is identical to ``sendmail -bp''.
The relevant options are as follows:
-Ac Show the mail submission queue specified in /etc/mail/submit.cf instead of the MTA queue specified in /etc/mail/sendmail.cf.
-qL Show the "lost" items in the mail queue instead of the normal queue items.
-qQ Show the quarantined items in the mail queue instead of the normal queue items.
-q[!]I substr
Limit processed jobs to those containing substr as a substring of the queue id or not when ! is specified.
-q[!]Q substr
Limit processed jobs to quarantined jobs containing substr as a substring of the quarantine reason or not when ! is specified.
-q[!]R substr
Limit processed jobs to those containing substr as a substring of one of the recipients or not when ! is specified.
-q[!]S substr
Limit processed jobs to those containing substr as a substring of the sender or not when ! is specified.
-v Print 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 indicating 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 expanded from, if any. Moreover, status messages for each recipient are printed if
available.
Several sendmail.cf options influence the behavior of the mailq utility: The number of items printed per queue group is restricted by
MaxQueueRunSize if that value is set. The status character * is not printed for some values of QueueSortOrder, e.g., filename, random,
modification, and none, unless a -q option is used to limit the processed jobs.
The mailq utility exits 0 on success, and >0 if an error occurs.
SEE ALSO sendmail(8)HISTORY
The mailq command appeared in 4.0BSD.
$Date: 2013-11-22 20:51:55 $ MAILQ(1)