02-02-2010
Need Help on a "simple" awk
Hello all,
I'm a quite absolute beginner on awk and I will appreciate any help to solve the following problem.
I have two different files, each of these with three columns.
File A (A1, A2, A3) and File B (B1, B2, B3)
The syntax would be as follows:
If A1 == B1 and A2 == B2, then print A1, A2, A3, B4
If not, do nothing
Thank you very in advance for the help you can provide me.
regards
Luca
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi Friends,
Can any of you explain me about the below line of code?
mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`
Im not able to understand, what exactly it is doing :confused:
Any help would be useful for me.
Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies
2. Shell Programming and Scripting
hi,
i have a file having datas like that
./a.txt
12344
12345
12346
12347
.....
.....
...
i want to save this datas to another file like that
./b.txt
12344 12345 12346 12347 ... ... ...
i think awk can make this but how? :) waiting for ur help. (3 Replies)
Discussion started by: mercury
3 Replies
3. Shell Programming and Scripting
hi All,
cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'
Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies
4. Shell Programming and Scripting
Input file:
2 aux003.net3.com error12
6 awn0117.net1.com error13
84 aux008 error14
29 aux001.ha.ux.isd.com error12
209 aux002.vm.ux.isd.com error34
21 alx0027.vm.net2.com error12
227 dux001.net5.com error123
22 us008.dot.net2.com error121
13 us009.net2.com error129Expected Output:
2... (4 Replies)
Discussion started by: sQew
4 Replies
5. Shell Programming and Scripting
Hi,
I have line in input file as below:
3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL
My expected output for line in the file must be :
"1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL"
Can someone... (7 Replies)
Discussion started by: shis100
7 Replies
6. Shell Programming and Scripting
logs:
"/home/abc/public_html/index.php"
"/home/abc/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
"/home/xyz/public_html/index.php"
how to use "cut" or "awk" or "sed" to get the following result:
abc
abc
xyz
xyz
xyz (8 Replies)
Discussion started by: timmywong
8 Replies
7. Post Here to Contact Site Administrators and Moderators
Majority of the questions are pertaining file/string parsing w.r.t
sed
or
awk
It would be nice to have these two as their own sub category under shell-programming-scripting which can avoid lot of duplicate posts. (1 Reply)
Discussion started by: jville
1 Replies
8. Shell Programming and Scripting
Hi Experts,
I have a string with colon delimited, want 2nd colon to be changed to a pipe.
data:
101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:
I am trying with sed, but can change only 1 occurance:
echo "101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:" | sed 's/:/|/2'... (5 Replies)
Discussion started by: rveri
5 Replies
9. UNIX for Dummies Questions & Answers
How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address
and column 3 contains “cc” e-mail address to include with same email.
Sample input file, email.txt
Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies
10. Shell Programming and Scripting
Hello.
System : opensuse leap 42.3
I have a bash script that build a text file.
I would like the last command doing :
print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt
where :
print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies
LEARN ABOUT MOJAVE
file::spec::vms5.18
File::Spec::VMS(3pm) Perl Programmers Reference Guide File::Spec::VMS(3pm)
NAME
File::Spec::VMS - methods for VMS file specs
SYNOPSIS
require File::Spec::VMS; # Done internally by File::Spec if needed
DESCRIPTION
See File::Spec::Unix for a documentation of the methods provided there. This package overrides the implementation of these methods, not the
semantics.
The default behavior is to allow either VMS or Unix syntax on input and to return VMS syntax on output unless Unix syntax has been
explicity requested via the "DECC$FILENAME_UNIX_REPORT" CRTL feature.
canonpath (override)
Removes redundant portions of file specifications and returns results in native syntax unless Unix filename reporting has been enabled.
catdir (override)
Concatenates a list of file specifications, and returns the result as a native directory specification unless the Unix filename
reporting feature has been enabled. No check is made for "impossible" cases (e.g. elements other than the first being absolute
filespecs).
catfile (override)
Concatenates a list of directory specifications with a filename specification to build a path.
curdir (override)
Returns a string representation of the current directory: '[]' or '.'
devnull (override)
Returns a string representation of the null device: '_NLA0:' or '/dev/null'
rootdir (override)
Returns a string representation of the root directory: 'SYS$DISK:[000000]' or '/'
tmpdir (override)
Returns a string representation of the first writable directory from the following list or '' if none are writable:
/tmp if C<DECC$FILENAME_UNIX_REPORT> is enabled.
sys$scratch:
$ENV{TMPDIR}
Since perl 5.8.0, if running under taint mode, and if $ENV{TMPDIR} is tainted, it is not used.
updir (override)
Returns a string representation of the parent directory: '[-]' or '..'
case_tolerant (override)
VMS file specification syntax is case-tolerant.
path (override)
Translate logical name DCL$PATH as a searchlist, rather than trying to "split" string value of $ENV{'PATH'}.
file_name_is_absolute (override)
Checks for VMS directory spec as well as Unix separators.
splitpath (override)
($volume,$directories,$file) = File::Spec->splitpath( $path );
($volume,$directories,$file) = File::Spec->splitpath( $path,
$no_file );
Passing a true value for $no_file indicates that the path being split only contains directory components, even on systems where you can
usually (when not supporting a foreign syntax) tell the difference between directories and files at a glance.
splitdir (override)
Split a directory specification into the components.
catpath (override)
Construct a complete filespec.
abs2rel (override)
Attempt to convert an absolute file specification to a relative specification.
rel2abs (override)
Return an absolute file specification from a relative one.
COPYRIGHT
Copyright (c) 2004 by the Perl 5 Porters. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
See File::Spec and File::Spec::Unix. This package overrides the implementation of these methods, not the semantics.
An explanation of VMS file specs can be found at <http://h71000.www7.hp.com/doc/731FINAL/4506/4506pro_014.html#apps_locating_naming_files>.
perl v5.18.2 2014-01-06 File::Spec::VMS(3pm)