AWK Script to Capture Each Line of File As Variable
Hi All,
I'm working on creating a parts database. I currently have access to a manufacturer database in HTML and am working on moving all of the data into a MySQL db. I have created a sed script that strips out the HTML and unnecessary info and separates the script into one line for each field. Now, if each HTML file had the exact same number of fields, this would be a piece of cake, but the problem is that the manufacturer has omitted some fields where they are not applicable or do not have the data and some fields are more than one line, which makes my program a bit harder.
I'm still a newbie with awk, but have spent a few days studying the awk O'Reilly book. My goal is to get each line of the input file into a separate variable (or variable array) in awk so I can then program some logic operators to determine which data belongs in which database field.
I have written the below program which changes the field separator to "\n". I realize this doesn't work as awk is parsing each line one at a time until EOF. My question is how do I get this to work?
Thanks,
Dkr.
Last edited by Franklin52; 06-28-2011 at 03:45 AM..
Reason: Please use code tags for code and data samples, thank you
how to print any required line by its line no using awk and its NR variable
for eg:
------------
121343
adfdafd
21213sds
dafadfe432
adf.adf%adf
---------------
requied o/p if give num=3 it print:
21213sds
-------------------------------------- (2 Replies)
Hi Guyz,
I need to capture first N Bytes from the first line of my file.
Eg. If i have following data in File1
414d51204541495052475731202020204a910846230e420c Hello 3621363663212 Help Required
Then, i want the value of first 48 Bytes to be stored in a variable.
That is, variable... (5 Replies)
Hello ,
I have file with below content :
'165567885',
'165568443',
'165568805',
I need an awk script that would add a prefix zero after first ' .
Like
'0165567885',
'0165568443',
'0165568805',
Please help.
Thanks in advance. (5 Replies)
Dear People,
My query is:
have a file, which looks likes this:
10 20 30 40 50
1 2 3 4 5
100 200 300 400 500
what i need is: "PRINT EACH LINE TO AN UNIQUE FILE"
desired output:
file 1
10 20 30 40 50
file 2
1 2 3 4 5 (3 Replies)
Hi,
I wrote an awk script to analyse file A.
I call the script with files A and B. File A has lines like:
000000033100001
000000036100001
000000039100001
The first 9 characters are interpreted as a line number;
for each line number found I want to output this line number of file B.
... (13 Replies)
Hi Guys,
I'm a DBA and need help on shell scripting.
My Oracle Database is sitting on HP-UX machine.
Anyone has a script that can spool out permission of all oracle binary files in the below directory:
/opt/ora10g/oracle/
Format to be spooled out : chmod <exisiting permission> filename... (10 Replies)
Being new to awk I have a really basic question. It just has to be in the archives but it didn't bite me when I went looking for it.
I've written an awk script, placed it in a file, added the "#!/usr/bin/awk -f" at the top of the script and away I go. "% myAwk <inputfile>" gives me exactly what... (2 Replies)
The bash bash below extracts the oldest folder from a directory and stores it in filename
That result will match a line in bold in input. In the matching line there is an_xxx digit in italics that
(once the leading zero is removed) will match a line in link. That is the lint to print in output.... (2 Replies)
Hi Team. I am trying to capture the last record number from a file using the below command ( assuming abc.txt has 21 records and I want 21 as output )
awk'{c=NR;print c}'abc.txt
But it is printing all the record number. Can someone please help modify the above command? (8 Replies)
Discussion started by: chatwithsaurav
8 Replies
LEARN ABOUT DEBIAN
mysql::diff::database
MySQL::Diff::Database(3pm) User Contributed Perl Documentation MySQL::Diff::Database(3pm)NAME
MySQL::Diff::Database - Database Definition Class
SYNOPSIS
use MySQL::Diff::Database;
my $db = MySQL::Diff::Database->new(%options);
my $source = $db->source_type();
my $summary = $db->summary();
my $name = $db->name();
my @tables = $db->tables();
my $table_def = $db->table_by_name($table);
my @dbs = MySQL::Diff::Database::available_dbs();
DESCRIPTION
Parses a database definition into component parts.
METHODS
Constructor
new( %options )
Instantiate the objects, providing the command line options for database access and process requirements.
Public Methods
o source_type()
Returns 'file' if the data source is a text file, and 'db' if connected directly to a database.
o summary()
Provides a summary of the database.
o name()
Returns the name of the database.
o tables()
Returns a list of tables for the current database.
o table_by_name( $name )
Returns the table definition (see MySQL::Diff::Table) for the given table.
FUNCTIONS
Public Functions
o available_dbs()
Returns a list of the available databases.
Note that is used as a function call, not a method call.
COPYRIGHT AND LICENSE
Copyright (c) 2000-2011 Adam Spiers. 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
mysqldiff, MySQL::Diff, MySQL::Diff::Table, MySQL::Diff::Utils
AUTHOR
Adam Spiers <mysqldiff@adamspiers.org>
perl v5.14.2 2012-04-06 MySQL::Diff::Database(3pm)