I have a CSV file which contains number series as one of the fields. Some of the records of the field look like :
079661/3
I have to convert the above series as
079661
079662
079663
and store it as 3 different records.
Looking for help on how to achieve this. Am a newbie at Shell... (10 Replies)
Hi all,
I have a requirement to create a "superset" file out of a number of different sources with some different and some same columns.
We intend to have a manually updateable SuperSetCols.csv which would look like
"ColA","ColB","ColC","ColD","ColE","ColF","ColG"
so someday we may add... (3 Replies)
Hi,
I have a text like the one given below
status="Observation 1"
read1="Source rows not load"
read2="Score drop"
I want to create a csv and mail it out in such a way that all three lines will be in a single cell but as three lines.
For ex
Col C1
... (3 Replies)
I created a script that will go out and so a "/sbin/chkconfig --list | egrep XXX" against a server list that would create an output file like the following example:
----------------------------------------------------------------------------------
SERVER1
RC_Script_1 0:off 1:off 2:off... (4 Replies)
Hi,
i have shell script which compiles n number of test cases and execute them one by one. i want to create report in excel through script in which two columns namely "test id" and "release".second column have two subcolumns namely compiles and excutes. so i want first column should display test... (15 Replies)
Hi All,
I am trying to create a CSV file within a shell script test.ksh and the code snippet is something like below:
#!/usr/bin/ksh
# Set required variables.
. $HOME/.prof
# Output file path
Group1=/tmp/G1.csv
Group2=/tmp/G2.csv
Group3=/tmp/G3.csv
$ORACLE_HOME/bin/sqlplus -s... (2 Replies)
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Hello Unix Shell Script Experts,
I have a script that would mask the columns in .csv file or .txt file.
First the script will untar the .zip files from Archive folder and processes into work folder and finally pushes the masked .csv files into Feed folder.
Two parameters are passed
... (5 Replies)
Hi All ,
I would require your help to generate one output file after post processing of one CSV file as stated below
This file is just a small cut from a big file . Big file is having 20000 lines
PATTERN,pat0,pat1,pat2,pat3,pat4,pat5,pat6,pat7,pat8,pat9... (2 Replies)
Discussion started by: kshitij
2 Replies
LEARN ABOUT DEBIAN
get-oui
GET-OUI(1) General Commands Manual GET-OUI(1)NAME
get-oui - Fetch the arp-scan OUI file from the IEEE website
SYNOPSIS
get-oui [options]
DESCRIPTION
get-oui fetches the Ethernet OUI file from the IEEE website, and saves it in the format used by arp-scan.
The OUI file contains all of the OUIs (Organizationally Unique Identifiers) that have been registered with IEEE. Each OUI entry in the
file specifies the first 24-bits of the 48-bit Ethernet hardware address, leaving the remaining 24-bits for use by the registering organi-
sation. For example the OUI entry "080020", registered to Sun Microsystems, applies to any Ethernet hardware address from
08:00:20:00:00:00 to 08:00:20:ff:ff:ff inclusive. Each OUI assignment represents a total of 2^24 (16,777,216) Ethernet addresses.
Every major Ethernet hardware vendor registers an OUI for their equipment, and larger vendors will need to register more than one. For
example, 3Com have a total of 37 OUI entries. Organisations that only produce a small number of Ethernet devices will often obtain an IAB
registration instead. See get-iab(1) for details.
This script can be used to update the arp-scan OUI file from the latest data on the IEEE website. Most of the Ethernet addresses in use
belong to an OUI registration, so this is the most important of the files that arp-scan uses to decode Ethernet hardware addresses. You
should therefore run get-oui occasionally to keep the arp-scan OUI file up to date.
The OUI data is fetched from the URL http://standards.ieee.org/regauth/oui/oui.txt and the output file is saved to the file ieee-oui.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-oui.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-oui.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-oui.txt.
-u <URL>
Use the specified URL to fetch the raw OUI data from instead of the default http://standards.ieee.org/regauth/oui/oui.txt.
-v Display verbose progress messages.
FILES
ieee-oui.txt
The default output file.
EXAMPLES
$ get-oui -v
Renaming ieee-oui.txt to ieee-oui.txt.bak
Fetching OUI data from http://standards.ieee.org/regauth/oui/oui.txt
Fetched 1467278 bytes
Opening output file ieee-oui.txt
9274 OUI entries written to file ieee-oui.txt
NOTES
get-oui is implemented in Perl, so you need to have the Perl interpreter installed on your system to use it.
get-oui 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-iab(1)arp-fingerprint(1)
http://www.nta-monitor.com/wiki/ The arp-scan wiki page.
March 30, 2007 GET-OUI(1)