Hi ,
I have a file :
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74100.00
CSCH74100.00
I have to put a delimiter( say comma) in between after 6th character:
CSCH74,000.00
CSCH74,000.00
CSCH74,100.00 (2 Replies)
I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated.
I... (4 Replies)
Hi,
I have a fixed width file with some records as given below:
" 1000Nalsdjflj243324jljlj"
"-0300Njfowjljl309933fsf"
" 0010Njsfsjklj342344fsl"
I want to sum-up first field values(i.e from 2nd character to 6th character)of each record.
so for the above file i want to add (1000 - 300+... (2 Replies)
Hi All,
I have created a script which generates FIXED-WIDTH file by executing Oracle query.
SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ
It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe... (5 Replies)
I am trying to determine what would be a fast and simple way to manipulate data that comes in a fixed width format. This data has 6 segments within a record. Each record needs to written out with a header and the 6 segments. Based on the value in column #6 the fields will be defined accordingly.... (4 Replies)
Hi Guys
I am checking the treads to get the answer but i am not able to get the answer for my question.
I have two files. First file is a pattern file and the second file is the file i want to search in it. Output will be the lines from file2.
File1:
P2797f12af 44751228... (10 Replies)
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
I have a fixed with file with header & trailer length having the same length of the detail record file.
The details record length of this file is 24, for Header and Trailer the records will be padded with spaces to match the record length of the file
Currently I am adding 3 spaces in header... (14 Replies)
Discussion started by: ginrkf
14 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)