11-20-2013
Quote:
Originally Posted by
nikki1200
okay Sir Akshay Hegde i will try and keep you posted.
Thanks,
-nik
---------- Post updated at 12:24 PM ---------- Previous update was at 12:20 PM ----------
Hi Sir Akshay,
May i know where in this code is the 6th field of file 1?
$ awk -F, 'FNR==NR{A[$6]=$0;next}($6 in A){$0=A[$6] FS $8}A[$6]' inputfile2 inputfile1
$ awk -F, 'FNR==NR{A[$6]=$8;next}($6 in A){$0=$0 FS A[$6]}A[$6]' inputfile1 inputfile2
Please advise,
Thanks,
-nik
Red color represents
6th column of inputfile1
This User Gave Thanks to Akshay Hegde For This Post:
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Admins
Pls. assist me to update a new field having 40 rows to a file.
Test1.output
LV Space %free Space_used_04_15
dev 500 7 67%
dev1 800 7 75%
dev2 800 7 75%
dev3 900 7 ... (2 Replies)
Discussion started by: maestrohero
2 Replies
2. Shell Programming and Scripting
hello
I have a number of lines that need to be added at the end of a file each time I add a field in another file (let's name it file2)
file2 has this format:
filed1:field2:path1:path2:path3:path...
Whenever I add a path field, I should add to file1 these lines:
<Location path1>... (0 Replies)
Discussion started by: melanie_pfefer
0 Replies
3. Shell Programming and Scripting
Dear All,
I want to decode the one of the file field.
Input file:
9393939393|999|2009-02-20 00:00:01|2||4587|2007-02-28 00:00:01|0
9393939393|2001|2009-02-20 00:00:01|2||4587|2007-02-28 00:00:01|0
9393939393|1500|2009-02-20 00:00:01|2||4587| 2007-02-28 00:00:01|0... (1 Reply)
Discussion started by: hanu_oracle
1 Replies
4. Shell Programming and Scripting
"355"|""|"NJ"|"A0A 1W0"|"V"|""|""|""|"N"
I've the above sample data seperated with pipe delimeter and in the file I want to replace a space with "|" to the 4th field so the result would be like below. So it would change from 9 fields to 10 fields.
"355"|""|"NJ"|"A0A"|"1W0"|"V"|""|""|""|"N"
... (3 Replies)
Discussion started by: rudoraj
3 Replies
5. Shell Programming and Scripting
I have a csv file which has three columns
mem no. name surname
1234 John Smith
12345 John Doe
I want to change the mem no. to add TF to the mem no. field i.e.
mem no. name surname
1234TF John Smith
12345TF John Doe
How do you do this for all records in the file? (3 Replies)
Discussion started by: Pablo_beezo
3 Replies
6. Shell Programming and Scripting
Hi, I need to edit a file Protein Data Bank (pdb) and then open that file with the program VMD but when I edit the file with awk, it changes pdb format and the VMD program can not read it.
I need to subtract 34 to field 6 ($ 6).
this is a pdb file :
ATOM 918 N GLY B 103 -11.855 8.675... (8 Replies)
Discussion started by: bio_
8 Replies
7. UNIX for Dummies Questions & Answers
i need to add a new field in a pipe delimited line. the field will be the current date today.
aa|a|s|w|1
as|oiy|oiy|oiy|2
given that all lines are uniformed in the number of fields
i want it to look like this:\
aa|a|s|w|1|20120126
as|oiy|oiy|oiy|2|20120126
please help :) (3 Replies)
Discussion started by: kokoro
3 Replies
8. UNIX for Dummies Questions & Answers
Hello Sir/Madam,
I'm new to UNIX and wondering if I can process a find & add using AWK command in UNIX?
requirements: I have to find *.JPG field for each line in the input file and add it as a separate field for each line.. for ex:
0000684631,E,3088017,7... (10 Replies)
Discussion started by: V1l1h1
10 Replies
9. Shell Programming and Scripting
I am trying to add a tab after the last digit in $3 in the input. The grep below is all I can think off. Thank you :)
sed -n 's/:/&/p' input
input
chr1 955542 955763AGRN-6|gc=75
chr1 957570 957852AGRN-7|gc=61.2
chr1 976034 976270AGRN-9|gc=74.5
desired output
chr1... (5 Replies)
Discussion started by: cmccabe
5 Replies
10. UNIX for Beginners Questions & Answers
hi,
would you help me?
i have file total.csv
"a","e23","f"
"b,"34d","g"
"c","45f","f"
"d","45s","f"
count.csv
3
i do this :
paste -d',",' total.csv count.csv
but the result like this:
"a,"e23","f" 3
"b,"34d","g" (1 Reply)
Discussion started by: kivale
1 Replies
LIBBASH(7) libbash Manual LIBBASH(7)
NAME
libbash -- A bash shared libraries package.
DESCRIPTION
libbash is a package that enables bash dynamic-like shared libraries. Actually its a tool for managing bash scripts whose functions you may
want to load and use in scripts of your own.
It contains a 'dynamic loader' for the shared libraries ( ldbash(1)), a configuration tool (ldbashconfig(8)), and some libraries.
Using ldbash(1) you are able to load loadable bash libraries, such as getopts(1) and hashstash(1). A bash shared library that can be loaded
using
ldbash(1) must answer 4 requirments:
1. It must be installed in $LIBBASH_PREFIX/lib/bash (default is /usr/lib/bash).
2. It must contain a line that begins with '#EXPORT='. That line will contain (after the '=') a list of functions that the library
exports. I.e. all the function that will be usable after loading that library will be listed in that line.
3. It must contain a line that begins with '#REQUIRE='. That line will contain (after the '=') a list of bash libraries that are
required for our library. I.e. every bash library that is in use in our bash library must be listed there.
4. The library must be listed (For more information, see ldbashconfig(8)).
Basic guidelines for writing library of your own:
1. Be aware, that your library will be actually sourced. So, basically, it should contain (i.e define) only functions.
2. Try to declare all variables intended for internal use as local.
3. Global variables and functions that are intended for internal use (i.e are not defined in '#EXPORT=') should begin with:
__<library_name>_
For example, internal function myfoosort of hashstash library should be named as
__hashstash_myfoosort
This helps to avoid conflicts in global name space when using libraries that come from different vendors.
4. See html manual for full version of this guide.
AUTHORS
Hai Zaar <haizaar@haizaar.com>
Gil Ran <ril@ran4.net>
SEE ALSO
ldbash(1), ldbashconfig(8), getopts(1), hashstash(1) colors(1) messages(1) urlcoding(1) locks(1)
Linux Epoch Linux