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
RBASH(1) General Commands Manual RBASH(1)
NAME
rbash - restricted bash, see bash(1)
RESTRICTED SHELL
If bash is started with the name rbash, or the -r option is supplied at invocation, the shell becomes restricted. A restricted shell is
used to set up an environment more controlled than the standard shell. It behaves identically to bash with the exception that the follow-
ing are disallowed or not performed:
o changing directories with cd
o setting or unsetting the values of SHELL, PATH, ENV, or BASH_ENV
o specifying command names containing /
o specifying a file name containing a / as an argument to the . builtin command
o specifying a filename containing a slash as an argument to the -p option to the hash builtin command
o importing function definitions from the shell environment at startup
o parsing the value of SHELLOPTS from the shell environment at startup
o redirecting output using the >, >|, <>, >&, &>, and >> redirection operators
o using the exec builtin command to replace the shell with another command
o adding or deleting builtin commands with the -f and -d options to the enable builtin command
o using the enable builtin command to enable disabled shell builtins
o specifying the -p option to the command builtin command
o turning off restricted mode with set +r or set +o restricted.
These restrictions are enforced after any startup files are read.
When a command that is found to be a shell script is executed, rbash turns off any restrictions in the shell spawned to execute the script.
SEE ALSO
bash(1)
GNU Bash-4.0 2004 Apr 20 RBASH(1)