I have a flat file and need to count no of records in the file less the header and the trailer record.
I would appreciate any and all asistance
Thanks
Hadi Lalani (2 Replies)
Hi,
Am having files with many records, i need to count and display the number of records based on the keyword in one of the column of the records.
for e.g THE FILE CONTAINS TWO RECORDS LIKE.
200903031143150 0 1236060795054357lessrv1 BSNLSERVICE1 BSNLSERVICE1 ... (4 Replies)
Hi,
I have a pipe seperated file
I want to write a code to display count of lines that have 20th field not null.
nawk -F"|" '{if ($20!="") print NR,$20}' xyz..txt
This displays records with 20th field also null.
I would like output as: (4 Replies)
1. if the 1st row IDs of input1 (ID1/ID2.....) is equal to any IDNames of input2
print all relevant values together as defined in the output.
2. A bit tricky part is IDno in the output. All we need to do is numbering same kind of
letters as 1 (aa of ID1) and different letters as 2 (ab... (4 Replies)
Hello Friends,
I have a file(InputFile.csv) with the following columns(the columns are pipe-delimited):
ColA|ColB|ColC|ColD|ColE|ColF
Now for this file, I have to get those records which fulfil the following condition:
If "ColB" is NOT NULL and "ColD" has values one of the following... (9 Replies)
Hi everyone,
I have a file result.txt with records as following and another file mirna.txt with a list of miRNAs e.g. miR22, miR123, miR13 etc.
Gene Transcript miRNA
Gar Nm_111233 miR22
Gar Nm_123440 miR22
Gar Nm_129939 miR22
Hel Nm_233900 miR13
Hel ... (6 Replies)
The below awk will filter a list of 30,000 lines in the tab-delimited file. What I am having trouble with is adding a condition to SVTYPE=CNV
that will only print that line if CI= must be >.05 .
The other condition to add is if SVTYPE=Fusion, then in order to print that line
READ_COUNT must... (3 Replies)
I am trying to use awk to update the below tab-delimited file based on 5 different rules/conditions. The final output is also
tab-delimited and each line in the file will meet one of the conditions. My attemp is below as well though I am not very confident in it. Thank you :).
Condition 1: The... (10 Replies)
I have two files and would need to filter out records based on certain criteria, these column are of variable lengths, but the lengths are uniform throughout all the records of the file. I have shown a sample of three records below. Line 1-9 is the item number "0227546_1" in the case of the first... (15 Replies)
I have been reading old posts and trying to come up with a solution for the below: Use a tab-delimited input file to assign
point to variables that are used to update a specific field, Rank. I really couldn't find too much in the way of assigning points
to variable, but made an attempt at an awk... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT OSF1
refile
refile(1) General Commands Manual refile(1)NAME
refile - file message in other folders (only available within the message handling system, mh)
SYNOPSIS
refile [msgs] [+folder] [options]
OPTIONS
Refiles the draft message, or the current message in your +drafts folder, if you have one set up. You cannot give a msgs argument when you
use this option. Moves a file into a folder. This option takes a file from its directory and places it in the named folder, as the next
message in the folder. The file must be formatted as a legal mail message. This means that the message must have the minimum header fields
separated from the body of the message by a blank line or a line of dashes. Prints a list of the valid options to this command. Keeps a
copy of the message in the source folder. Normally, refile removes the messages from the original folder when it refiles them. The -link
option keeps a copy in the original folder, as well as filing a copy in the new folder. Preserves the number of a message in the new
folder. Normally, when a message is refiled in to another folder, it is set to the next available number in that folder. The -preserve
option keeps the number of the message the same in the new folder as it had been in the old.
You cannot have two messages with the same number in one folder, so you should use this option with care. Specifies the source
folder to take messages from. Normally, messages are refiled from the current folder into another folder. However, you can take mes-
sages from a different folder by using the -src +folder option to specify the alternative source folder.
DESCRIPTION
Use the refile command to move the specified message from the current folder to another folder. You can refile messages in more than one
folder by giving multiple folder names as arguments.
If you do not specify a message, the current message is refiled. You can refile a message other than the current message by giving its num-
ber as a msgs argument. You can also refile more than one message at a time by specifying more than one message number, or a range of mes-
sage numbers, or a message sequence. See mark(1) for more information on sequences.
The current folder remains the same unless the -src option is specified; in that case, the source folder becomes current. Normally, the
last message specified becomes the current message. However, if the -link option is used, the current message is not changed.
If the Previous-Sequence: entry is set in the file, in addition to defining the named sequences from the source folder, refile will also
define those sequences for the destination folders. See mh_profile(4) for information concerning the previous sequence.
PROFILE COMPONENTS
Path: To determine your Mail directory
Folder-Protect: To set protections when creating a new folder
rmmproc: Program to delete the message
EXAMPLES
The following example refiles messages 3 and 5 in the folder +records: % refile 3 5 +records The next example files the current message
into two folders: % refile +jones +map The next example takes message 13 in the current folder and refiles it in the +test folder. The mes-
sage remains in the current folder as well as appearing in the +test folder. % refile -link 13 +test The next example takes a message from
the folder +test when it is not the current folder, and places it in the folder +outbox: % refile 3 -src +test +outbox
FILES
The user profile.
SEE ALSO folder(1), mark(1), mh_profile(4)refile(1)