Any way to get join to include the non-matching line ???
Hi,
Need guidance if I should totally abandon join and use something else instead. I found several other options when searching for merge files in UNIX.com
Below are the test files to join:
Running
gives
Is there no way to get the E row from a.txt
Running
. Is there no way to get the B row from a.txt printed?
Hi All,
I need a shell script to join a line to the line that follows it. But I shouldn't do it for all the lines. I need to join a line having the character say '&' at the end of the line & need to join the line that follows it.
E.g
Input
1. This is the first line &
2. and the second... (6 Replies)
another question that could possibly be answered with awk...
#cat filename
ab cd ef:ghi:jk lm:nop qrs
ab cd ef:ghi:jk lm:nop qrs
ab cd ef:ghi:jk lm:nop qrs
ab cd ef:ghi:jk lm:nop qrs
# for x in `awk 'sub($1" +"$2" +","",$0) ' filename`; do echo $x; done
ef:ghi:jk ... (8 Replies)
Hello,
Did anyone know how to write a perl script to merge the multi-line into a single line where each line with start at timestamp
Input-->
timestamp=2009-11-10-04.55.20.829347;
a;
b;
c;
timestamp=2009-11-10-04.55.20.829347;
aa;
bb;
cc; (5 Replies)
Dear Forum,
Full title of the topic would be: "Join 3 or more files using matching column without full list in any of these columns"
I have several, typically 3 or 4 files which I need to join, something like FULL JOIN in slq scripts, all combinations of matches should be printed into an... (3 Replies)
Hi
I had two files like below.
file-1
101001234567890
101001234567891
101001234567892
101001234567893
101001234567894
101001234567895
101001234567896
101001234567897
101001234567898
101001234567899
file-2 (6 Replies)
I am trying to Join all the lines matching similar pattern.
Example ;
I wanted to join all the lines which has sam to a single line.
In next line, i wanted to have all the lines with jones to a single line....etc
> cat sample.txt
sam 2012/11/23
sam 2012/12/5
sam 2012/12/5
jones... (2 Replies)
Hi, I have text file:
Name: xyz
Gender: M
Address: "120_B_C; ksilskdj; lsudlfw"
Zip: 20392
Name: KLM
Gender: F
Address: "65_D_F; wnmlsi;lsuod;,...."
Zip:90233I want to insert 2 new lines before the 'Address: ' line deriving value from this Address line value
The Address value in quotes... (1 Reply)
Hi,
I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it.
Basically my data looks like this, with the TICKER columns matching up in each file
File1
TICKER,column 1, column, 2, column, 3, column 4
... (6 Replies)
Hello,
I have two files file 1 and file 2 each having result of a query on certain database tables and need to compare for Col1 in file1 with Col3 in file2, compare Col2 with Col4 and output the value of Col1 from File1 which is a) not present in Col3 of File2 b) value of Col2 is different from... (2 Replies)
Hi guys I am trying to figure out how to match a pattern with a regex up to a full blank line. I will show you what I mean with this example:
example A
movie name: ted
movie name: TMNT
movie name: Jinxed
example B
movie names:
Gravity
Faster
Turbo
song titles:
dont
hello
problem (8 Replies)
Discussion started by: acoding
8 Replies
LEARN ABOUT DEBIAN
get-iab
GET-IAB(1) General Commands Manual GET-IAB(1)NAME
get-iab - Fetch the arp-scan IAB file from the IEEE website
SYNOPSIS
get-iab [options]
DESCRIPTION
get-iab fetches the Ethernet IAB file from the IEEE website, and saves it in the format used by arp-scan.
The IAB file contains all of the IABs (Individual Address Blocks) that have been registered with IEEE. Each IAB entry in the file speci-
fies the first 36-bits of the 48-bit Ethernet hardware address, leaving the remaining 12-bits for use by the registering organisation. For
example the IAB entry "0050C2003", registered to Microsoft, applies to any Ethernet hardware address from 00:50:c2:00:30:00 to
00:50:c2:00:3f:ff inclusive. Each IAB assignment represents a total of 2^12 (4,096) Ethernet addresses.
Major Ethernet hardware vendors typically use an OUI registration rather than an IAB registration. See get-oui(1) for details.
This script can be used to update the arp-scan IAB file from the latest data on the IEEE website. It is relatively rare to see Ethernet
addresses from IAB registrations, so the IAB file is not as important as the OUI file.
The IAB data is fetched from the URL http://standards.ieee.org/regauth/oui/iab.txt and the output file is saved to the file ieee-iab.txt in
the current directory. The URL to fetch the data from can be changed with the -u option, and the output file name can be changed with the
-f option.
The ieee-iab.txt file that is produced by this script is used by arp-scan to determine the Ethernet card vendor from its hardware address.
The directory that arp-scan will look for the ieee-iab.txt file depends on the options used when it was built. If it was built using the
default options, then it will look in /usr/local/share/arp-scan.
OPTIONS -h Display a brief usage message and exit.
-f <fn>
Write the output to the specified file instead of the default ieee-iab.txt.
-u <URL>
Use the specified URL to fetch the raw IAB data from instead of the default http://standards.ieee.org/regauth/oui/iab.txt
-v Display verbose progress messages.
FILES
ieee-iab.txt
The default output file.
EXAMPLES
$ get-iab -v
Renaming ieee-iab.txt to ieee-iab.txt.bak
Fetching IAB data from http://standards.ieee.org/regauth/oui/iab.txt
Fetched 230786 bytes
Opening output file ieee-iab.txt
1535 IAB entries written to file ieee-iab.txt
NOTES
get-iab is implemented in Perl, so you need to have the Perl interpreter installed on your system to use it.
get-iab uses the LWP::Simple Perl module to fetch the data from the IEEE website. You must have this module installed on your system for it
to work. This module is available on most distributions, often called libwww-perl. It is also available in source form from CPAN.
You can use a proxy server by defining the http_proxy environment variable.
AUTHOR
Roy Hills <Roy.Hills@nta-monitor.com>
SEE ALSO arp-scan(1)get-oui(1)arp-fingerprint(1)
http://www.nta-monitor.com/wiki/ The arp-scan wiki page.
March 30, 2007 GET-IAB(1)