Hi, I have to change a tab delimited file to a fixed length file. For text fields I need to left justify and NULL fill to the right and for number fields I need to right justify and zero fill to the left. If there are spaces between words in a text field I need to keep them as spaces. I am using... (14 Replies)
If someone out there could help me out with this problem. I would really appreciate it.
I am trying to convert xml into text file(fixed length) using Unix Borne shell scripts.
My xml file:
<root>
<header_rec recordtype="00">
<record_id>00</record_id>
... (0 Replies)
Newbie
Looking for a script to convert my input file to delimited text file. Not familier with AWK or shell programing. Below is sample record in my input file and the expected output format. My OS is HPUX 11.23.
Thanks in advance for your assistance.
tbtbs
input file:... (12 Replies)
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
Hello gurus,
I have a file containing 5 columns delimited by '#' as shown in the example below:
HRP1000-PLVAR#HRP1000-OTYPE#HRP1000-OBJID#HRP1000-BEGDA#HRP1000-ENDDA#
99991231#AU7129#000000000#1 PROCTER & GAMBLE#
99991231#TT4283#1000013883#21111 LAUNDRY#
99991231#TT4283#1000013884#21121 DISH... (3 Replies)
Hi All,
I need to convert a fixed length file to a delimited file with , (comma). But not all columns, some of the columns in the fixed files are used as fillers and I do not need that in the output file.
test_fixed_len.txt
I 0515 MR 394
I 0618 MR & MRS 942
I 0618 MR & MRS... (7 Replies)
Hi Team,
I have an issue to split the file which is having special chracter(German Char) using awk command.
I have a different length records in a file. I am separating the files based on the length using awk command.
The command is working fine if the record is not having any... (7 Replies)
Hi - this is a generic question .... is there any utility which can convert a fixed width file format to a delimited file (any given character delimited) ? (5 Replies)
Discussion started by: i4ismail
5 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)