01-21-2008
match field between 2 files
I would like to do the following in bash shell.
file a
a:1
b:2
c:3
file b
a:work:apple
b:baby:banana
c:candy:cat
d:desk:dog
I would like to match field 1 in file a to file b, if there's a match I would like
to append field 2 in file a to field 3 in file b.
Thank you.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
Thanks for your help in advance
I am parsing a log file where the first field of each line can have the same key value but not more than 3 times in a row. Varying value of that first field changes as you go through the log but it either appears 3 times or two and sometimes only once.... (1 Reply)
Discussion started by: dragrid
1 Replies
2. Shell Programming and Scripting
Hi,
I want to get script or command in Sun Unix which matches first fields of both the files and print the feilds of one files, example may make it more clear.
InputFile1
==================
Alex,1,fgh
Menthos,45454,toto
Gothica,855,ee
Zenie4,77,gg
Salvatore,66,oo
Dhin,1234,papapa... (3 Replies)
Discussion started by: indian.ace
3 Replies
3. Shell Programming and Scripting
Hello,
I have two files that have the date field as a common. I request your help with some script that divide the value of the file1 by the value in the file2 only when the field date are the same between both files and create a new text file.
This is a sample of the files
file1... (1 Reply)
Discussion started by: csierra
1 Replies
4. Shell Programming and Scripting
First, thanks for the help in previous posts... couldn't have gotten where I am now without it!
So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following:
If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies
5. UNIX for Dummies Questions & Answers
Hi !
I have a tab-delimited file, file.tab:
Column1 Column2 Column3
aaaaaaaaaa bbtomatoesbbbbbb cccccccccc
ddddddddd eeeeappleseeeeeeeee ffffffffffffff
ggggggggg hhhhhhtomatoeshhh iiiiiiiiiiiiiiii
... (18 Replies)
Discussion started by: lucasvs
18 Replies
6. Shell Programming and Scripting
hello,
i have a little problem, i want match the complete field ($1 or $2) with a complete word in another variable.
example:
i have a file with either one or two words per lane:
hsa-mir-4449
hsa-mir-4707
hsa-mir-4707* hsa-mir-4707
novelMiR_3551 novelMiR_3563
novelMiR_4330... (4 Replies)
Discussion started by: ace13
4 Replies
7. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
8. Shell Programming and Scripting
Hello,
I have a text file in the below format:
Source Destination State Lag Status
CQA02W2K12pl:D:\CAQA ... (10 Replies)
Discussion started by: pocodot
10 Replies
9. Shell Programming and Scripting
In the awk below I use $2 of filet to search filea for a match. If the values in $2 are exact match this works great. However, that is not always the case, so I need to perform the search using a range of + or - 2. That is if the value in filea $2 is within + or - 2 of filet $2 then it is matched.... (6 Replies)
Discussion started by: cmccabe
6 Replies
10. Shell Programming and Scripting
I am trying to look for $2 of file1 (skipping the header) in $2 of file2 (skipping the header) and if they match and the value in $10 is > 30 and $11 is > 49, then print the line from file1 to a output file. If no match is foung the line is not printed. Both the input and output are tab-delimited.... (3 Replies)
Discussion started by: cmccabe
3 Replies
ANNO(1) [nmh-1.5] ANNO(1)
NAME
anno - annotate messages
SYNOPSIS
anno [+folder] [msgs] [-component field] [-inplace | -noinplace] [-date | -nodate] [-draft] [-append] [-list] [-delete] [-number [num|all]]
[-preserve | -nopreserve] [-version] [-help] [-text body]
DESCRIPTION
Anno manipulates header fields or annotations in messages. Header fields consist of a field name and an optional field body as defined by
RFC-2822. The -component option specifies the field name, and the -text option specifies the field body.
The messages are either the msgs in the named folder, or the draft if invoked with the -draft option.
Usually, annotation is performed by the commands dist, forw, and repl, if they are given the -anno switch. This allows you to keep track
of your distribution of, forwarding of, and replies to a message.
By using anno, you can perform arbitrary annotations of your own. Each message selected will be annotated with the lines
field: date
field: body
The -nodate switch inhibits the date annotation, leaving only the body annotation.
By default, anno prepends the annotations to the message. Annotations are instead appended if the -append option is specified.
If a -component field is not specified when anno is invoked, anno will prompt the user for the name of field for the annotation.
The field specified must be a valid 2822-style message field name, which means that it may only consist of alphanumerics and dashes, The
body specified is arbitrary text.
Normally anno does the annotation inplace in order to preserve any links to the message. You may change this by using the -noinplace
switch.
The -list option produces a listing of the field bodies for header fields with names matching the specified component, one per line. The
listing is numbered, starting at 1, if the -number option is also used. A tab character separates the number and the field body. The
field body is treated as if it is a file name, and only the final path name component is listed. The complete field body is listed if the
-text option is used, the contents of the text are ignored.
The -delete option removes header fields from messages. The first header field whose name matches the component is deleted if no other
options are specified. If the -text option is used in conjunction with the -delete option, the first header field whose name matches the
component and whose body matches the text is deleted. The text is treated as if it was a file name; if it begins with a slash, the entire
field body must match the text, otherwise just the last path name component of the field body must match. If the -number option is used in
conjuction with the -delete option, header field num whose name matches the component is deleted. The number matches that which is pro-
duced by the -list option. The special value all can be used for the number, and causes all components that match the name to be deleted.
By default, anno changes the last-accessed and last-modified times on annotate messages to the time at which the annotation occurs. Anno
preserves the original times if the -preserve option is used. A matching -nopreserve option exists that allows time preservation to be
turned off if enabled in the profile.
FILES
$HOME/.mh_profile The user profile
PROFILE COMPONENTS
Path: To determine the user's nmh directory
Current-Folder: To find the default current folder
SEE ALSO
dist(1), forw(1), repl(1)
DEFAULTS
`+folder' defaults to the current folder
`msgs' defaults to cur
`-inplace'
`-date'
CONTEXT
If a folder is given, it will become the current folder. The first message annotated will become the current message.
MH.6.8 11 June 2012 ANNO(1)