using field 2 in file2 to complete field 3 in file1
Hello,
I was hoping someone could help me with this work related problem...
basically what I want to do is the following:
file2:
Code:
1 o
2 t
4 f
5 v
7 n
8 e
10 a
file1:
Code:
1 :
2 :
3 :
4 :
5 :
6 :
7 :
8 :
9 :
10 :
Output:
Code:
1 : o
2 : t
3 :
4 : f
5 : v
6 :
7 : n
8 : e
9 :
10 : a
I am using "foreach" to implement this and it works fine when the number of lines is low, but when I hit numbers in the thousands the script becomes really slow.
I am sure there is a faster way of doing this using awk or sed but just dont know the command.
if you could also provide an explanation of the command that implements this I would appreciate it.
Hi All,
I have file1 line below:
$myName$|xxx
Now I need to read the file1 and find for $myName$ in file2 and replace with xxx
file1:
$myName$|xxx
file2:
My name is $myName$
expected output in file2 after executing the script is below:
my name is xxx
Thanks, (8 Replies)
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)
I have very limited coding skills but I'm wondering if someone could help me with this. There are many threads about matching strings in two files, but I have no idea how to add a column from one file to another based on a matching string.
I'm looking to match column1 in file1 to the number... (3 Replies)
Hi Freinds,
i have a file1 as below
file1
1|ndmf|fdd|d3484|34874
2|jdehf|wru7|478|w489
3|dfkj|wej|484|49894
file2 contains lakhs of records and not in sorted order
i want to retrive only the records from file2 by searcing the first field of file 1
i used
grep ^1 file2... (4 Replies)
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)
Dear All,
Need your help..:D
I am not regular on shell scripts..:(
I have 2 files..
Content of file1
cellRef 4};"4038_2_MTNL_KALAMBOLI"
cellRef 1020};"4112_3_RAINBOW_BLDG"
cellRef 134};"4049_2_TATA_HOSPITAL"
cellRef 1003};"4242_3_HITESH_CONSTRUCTION"
cellRef... (6 Replies)
I am trying to use awk to find all the $2 values in file2 which is ~30MB and tab-delimited, that are between $2 and $3 in file1 which is ~2GB and tab-delimited.
I have just found out that I need to use $1 and $2 and $3 from file1 and $1 and $2of file2 must match $1 of file1 and be in the range... (6 Replies)
Trying to use awk to:
update $2 in file2 with the $2 value in file1, if $1 in file1 matches $13 in file2, which is tab-delimeted. The $2values may already be the same so in that case nothing happens and the next line is processed.
There are exactly 4,605 unique $13 values. Thank you :).
... (4 Replies)
In the awk below I am trying to set/update the value of $14 in file2 in
bold, using the matching NM_ in $12 or $9 in file2
with the NM_ in $2 of file1.
The lengths of $9 and $12 can be variable but what is consistent is the start pattern
will always be NM_ and the end pattern is always ;... (2 Replies)
I have two files which are the output of a multiple choice vocab test (60 separate questions) from 104 people (there are some missing responses) and the question list. I have the item list in one file (File1)
Item,Stimulus,Choice1,Choice2,Choice3,Choice4,Correct... (5 Replies)
Discussion started by: samonl
5 Replies
LEARN ABOUT DEBIAN
cbcodec
CBCODEC(1) Quick Database Manager CBCODEC(1)NAME
cbcodec - popular encoders and decoders
SYNOPSIS
cbcodec url [-d] [-br] [-rs base target] [-l] [-e expr] [file]
cbcodec base [-d] [-l] [-c num] [-e expr] [file]
cbcodec quote [-d] [-l] [-c num] [-e expr] [file]
cbcodec mime [-d] [-hd] [-bd] [-part num] [-l] [-ec code] [-qp] [-dc] [-e expr] [file]
cbcodec csv [-d] [-t] [-l] [-e expr] [-html] [file]
cbcodec xml [-d] [-p] [-l] [-e expr] [-tsv] [file]
cbcodec zlib [-d] [-gz] [-crc] [file]
cbcodec lzo [-d] [file]
cbcodec bzip [-d] [file]
cbcodec iconv [-ic code] [-oc code] [-ol ltype] [-cn] [-wc] [-um] [file]
cbcodec date [-wf] [-rf] [-utc] [str]
DESCRIPTION
This manual page documents briefly the cbcodec commands.
cbcodec is a tool to use encoding and decoding features provided by Cabin. This command is used in the above format. file specifies a
input file. If it is omitted, the standard input is read.
OPTIONS
A summary of options is included below. For a complete description, see the file:///usr/share/doc/qdbm-doc/spex.html#cabincli.
-d perform decoding (unescaping), not encoding (escaping).
-br break up URL into elements.
-rs resolve relative URL.
-l output the tailing newline.
-e expr
specify input data directly.
-c num limit the number of columns of the encoded data.
-hd parse MIME and extract headers in TSV format.
-bd parse MIME and extract the body.
-part num
parse MIME and extract a part.
-ec code
specify the input encoding, which is UTF-8 by default.
-qp use quoted-printable encoding, which is Base64 by default.
-dc output the encoding name instead of the result string when decoding.
-t parse CSV. Convert the data into TSV. Tab and new-line in a cell are deleted.
-html parse CSV. Convert the data into HTML.
-p parse XML. Show tags and text sections with dividing headers.
-tsv parse XML. Show the result in TSV format. Characters of tabs and new-lines are URL-encoded.
-gz use GZIP format.
-crc output the CRC32 checksum as hexadecimal and big endian.
-ic code
specify the input encoding, which is detected automatically by default.
-oc code
specify the output encoding, which is UTF-8 by default.
-ol ltype
convert line feed characters, with `unix'(LF), `dos'(CRLF), and `mac'(CR).
-cn detect the input encoding and show its name.
-wc count the number of characters of the input string of UTF-8.
-um output mappings of UCS-2 characters and C strings of UTF-16BE and UTF-8.
-wf output in W3CDTF format.
-rf output in RFC 1123 format.
-utc output the coordinate universal time.
SEE ALSO qdbm(3), cabin(3).
AUTHOR
QDBM was written by Mikio Hirabayashi <mikio@fallabs.com>.
This manual page was written by Fumitoshi UKAI <ukai@debian.or.jp>, for the Debian project (but may be used by others).
Man Page 2005-05-23 CBCODEC(1)