08-20-2012
You can use awk to read the mapping file, storing each unique key (4th column) in an array. Then read the source file and print the line only if the 4th column is a key in the array.
Regards,
Alister
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi there,
I have written a script called "compare" (see below) to make comparison between 2 files namely test_put.log and Output_A0.log
#!/bin/ksh
while read file
do
found="no"
while read line
do
echo $line | grep $file > /dev/null
if
then
echo $file found
found="yes"
break
fi... (3 Replies)
Discussion started by: lweegp
3 Replies
2. Shell Programming and Scripting
I want to deal with several data, i.e., data.*.txt with following structure
MSG|20010102|123 125 4562 409|SEND
MSG|20010102|120 230|SEND
MSG|20010102|120 204 5071|SEND
MSG|20010103|2 11 1098 9810|SEND
......
index file index.txt is
11
201
298
100
......
What I want to do is:
1)... (0 Replies)
Discussion started by: zhynxn
0 Replies
3. Shell Programming and Scripting
This is shell programming assignment.
It needs to create a file called .std_dbrc contains
STD_DBROOT=${HOME}/class/2031/Assgn3/STD_DB
(which includes all my simple database files)
and I am gonna use this .std_dbrc in my script file (read the data from the database files)
like this: .... (3 Replies)
Discussion started by: ccwq
3 Replies
4. Shell Programming and Scripting
Hi there
I would like to create a shell script to do the following:
- delete a line in file1 if it contains the data string in file2
eg: file1
1 100109942004051510601703694 0.00 0.00
2 100109942004051510601702326 0.00 0.00
3 ... (1 Reply)
Discussion started by: earth_goddess
1 Replies
5. Shell Programming and Scripting
i need to delete the lines is match from file data 1 & data 2
please help?
data 1
4825307
4825308
4825248
4825309
4825310
4825311
4825336
data 2
4825248 0100362210 Time4Meal 39.00 41.73 MO & MT MT SMS
4825305 0100367565... (2 Replies)
Discussion started by: ooilinlove
2 Replies
6. Shell Programming and Scripting
Hi.. I'm into a bump after trying to solve this prob.. i've a file with contents like below.
<blankline>
'pgmId' : 'UNIX',
'pgmData' : 'textfile',
'author' : 'admin',
.......
Now i'm trying to insert a new data after pgmId. so the final output will be... (7 Replies)
Discussion started by: arjun_arippa
7 Replies
7. Shell Programming and Scripting
I have a list of DNS servers I need to look up information on. Each of these servers has a master and a slave database. Essentially what I need to do is create two text files for each server. One with the Master view and one with the Slave view. There's 20 servers, in the end I should have 40 text... (4 Replies)
Discussion started by: spartan22
4 Replies
8. UNIX for Dummies Questions & Answers
Hello,
:wall:
I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books.
I know this does not work
/^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d
Any ideas?
Thanks
Please... (2 Replies)
Discussion started by: Chris Eagleson
2 Replies
9. UNIX for Dummies Questions & Answers
Hi All,
i have a requirement where i need to format the input RAW file ( which is CSV) by using another mapping file(also CSV file). basically i am getting feed file with dynamic headers by using mapping file (in that target field is mapped with source filed) i have to convert the raw file into... (6 Replies)
Discussion started by: ravi4informatic
6 Replies
10. Shell Programming and Scripting
Hi
How to compare the source definition file in unix with the data file .
Please can you share me example if some one has done it before (3 Replies)
Discussion started by: Raj4fusion
3 Replies
LEARN ABOUT DEBIAN
alzabo::foreignkey
Alzabo::ForeignKey(3pm) User Contributed Perl Documentation Alzabo::ForeignKey(3pm)
NAME
Alzabo::ForeignKey - Foreign key (relation) objects
SYNOPSIS
use Alzabo::ForeignKey;
foreach my $fk ($table->foreign_keys)
{
print $fk->cardinality;
}
DESCRIPTION
A foreign key is an object defined by several properties. It represents a relationship from a column or columns in one table to a column
or columns in another table.
This relationship is defined by its cardinality (one to one, one to many, or many to one) and its dependencies (whether or not table X is
dependent on table Y, and vice versa).
Many to many relationships are not allowed. However, you may indicate such a relationship when using the Alzabo::Create::Schema->add_rela-
tion method method, and it will create the necessary intermediate linking table for you.
METHODS
table_from
table_to
Returns the relevant "Alzabo::Table" object.
columns_from
columns_to
Returns the relevant "Alzabo::Column" object(s) for the property as an array.
column_pairs
Returns an array of array references. The references are to two column array of "Alzabo::Column" objects. These two columns correspond in
the tables being linked together.
cardinality
Returns a two element array containing the two portions of the cardinality of the relationship. Each portion will be either '1' or 'n'.
from_is_dependent
to_is_dependent
Returns a boolean value indicating whether there is a dependency from one table to the other.
is_one_to_one
is_one_to_many
is_many_to_one
Returns a boolean value indicating what kind of relationship the object represents.
is_same_relationship_as ($fk)
Given a foreign key object, this returns true if the two objects represent the same relationship. However, the two objects may represent
the same relationship from different table's points of view.
id
Returns a string uniquely identifying the foreign key.
comment
Returns the comment associated with the foreign key object, if any.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::ForeignKey(3pm)