05-06-2014
Compare 2 colums in two files
Hi ,
I am trying to write a part in shell script. I have two files with one column each and would like to output it to a new file giving the records which are different.Pls help experts.
HTML Code:
File1
Column name
11
12
13
14
18
File2
Column name
11
12
14
17
19
20
File 3
Column Name Column name
13 17
14 19
18 20
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi,
i have little pb, i would like make a colums, but my server not recongize "\t" or i write wrong.... and iam little noobs and no know awk...
#!/bin/ksh
#----------------------------------------------------------------------------
# Fichiers : ctrl.sh et ctrl2005.txt ... (6 Replies)
Discussion started by: parola
6 Replies
2. Shell Programming and Scripting
hi all ,
i have three files that contain numbes as the first column .
i want to add these files together so the numbers from the first file is in the first column ; the numbers from the second file in the second column; and the numbers from the third file in the third column .
as an... (5 Replies)
Discussion started by: ppass
5 Replies
3. Shell Programming and Scripting
I've got two large csv text table files with different number of columns each.
I have to compare them based on first two columns and create resulting file
that would in case of matched first two columns include all values from first one and all values (except first two colums) from second one. I... (5 Replies)
Discussion started by: agb2008
5 Replies
4. Shell Programming and Scripting
Hi Everybody.
I need an urgent help, it would be great if somebody will help me out in this regard. See below sample file
1525 805 26 2036 219644. 2598293.
1525 805 126 2327
1525 805 226 ... (6 Replies)
Discussion started by: syahmed
6 Replies
5. Shell Programming and Scripting
I have four files, I need to compare these files together.
As such i know "sdiff and comm" commands but these commands compare 2 files together. If I use sdiff command then i have to compare each file with other which will increase the codes.
Please suggest if you know some commands whcih can... (6 Replies)
Discussion started by: nehashine
6 Replies
6. Shell Programming and Scripting
I want to rearrange some of my columns in my dat file; how do i do this using a script
Suppose, I have an input file like this:
BASENAME STREETTYPE PREFIX SUFFIX HOUSENUMBER BUILDUP ORDER8 ORDER2 ORDER1 ISOCOUNTRYCODE POSTALCODE
SILVER LAKE RD NW 1135 NEW BRIGHTON RAMSEY MINNESOTA USA 55112... (4 Replies)
Discussion started by: ramky79
4 Replies
7. Shell Programming and Scripting
Need help to convert the following data
Account name: admin
Role: admin
Description: Administrator
Enabled: Yes
to
Account Name Role Description Enabled
admin admin Administrator Yes
Perl or AWK?
Thanks
San (9 Replies)
Discussion started by: sanguy
9 Replies
8. Shell Programming and Scripting
Hi all,
I have a text file that has (4) columns. There are about 300 lines on this file. It is a plain text file. I am looking to write a simple script that will read each line from the file and generate another text file. The file looks something like this:
These are the columns:
... (4 Replies)
Discussion started by: adamw
4 Replies
9. UNIX for Dummies Questions & Answers
Sample Input File
2014/10/09 CDE876172588765 00:09:45 00:10:10 200 200 11.7093
2014/10/09 CDE366134588757 01:04:34 01:04:54 210 210 9.8898
2014/10/09 CDE765172345745 03:05:46 03:06:01 100 100 10.0601
2014/10/09 ... (8 Replies)
Discussion started by: rpm120
8 Replies
10. UNIX for Dummies Questions & Answers
HI,
I need to filter my data based on 3 different columns.
Two of the columns are unique so it worked if u use something like
grep 'PASS.*HIGH|HIGH.*PASS' file.tsv
However the other column is not unique ..
So basically I want to extract out lines that match only match these 3... (4 Replies)
Discussion started by: janshamsani
4 Replies
LEARN ABOUT DEBIAN
alzabo::column
Alzabo::Column(3pm) User Contributed Perl Documentation Alzabo::Column(3pm)
NAME
Alzabo::Column - Column objects
SYNOPSIS
use Alzabo::Column;
foreach my $c ($table->columns)
{
print $c->name;
}
DESCRIPTION
This object represents a column. It holds data specific to a column.
METHODS
table
Returns the table object to which this column belongs.
name
Returns the column's name as a string.
nullable
Returns a boolean value indicating whether or not NULLs are allowed in this column.
attributes
A column's attributes are strings describing the column (for example, valid attributes in MySQL are 'UNSIGNED' or 'ZEROFILL'.
This method returns a list of strings of such strings.
has_attribute
This method can be used to test whether or not a column has a particular attribute. By default, the check is case-insensitive.
It takes the following parameters:
* attribute => $attribute
* case_sensitive => 0 or 1 (defaults to 0)
It returns a boolean value indicating whether or not the column has this particular attribute.
type
Returns the column's type as a string.
sequenced
The meaning of a sequenced column varies from one RDBMS to another. In those with sequences, it means that a sequence is created and that
values for this column will be drawn from it for inserts into this table. In databases without sequences, the nearest analog for a
sequence is used (in MySQL the column is given the AUTO_INCREMENT attribute, in Sybase the identity attribute).
In general, this only has meaning for the primary key column of a table with a single column primary key. Setting the column as sequenced
means its value never has to be provided to when calling "Alzabo::Runtime::Table->insert".
Returns a boolean value indicating whether or not this column is sequenced.
default
Returns the default value of the column as a string, or undef if there is no default.
default_is_raw
Returns true if the default is intended to be provided to the DBMS as-is, without quoting, fore example "NOW()" or "current_timestamp".
length
Returns the length attribute of the column, or undef if there is none.
precision
Returns the precision attribute of the column, or undef if there is none.
is_primary_key
Returns a boolean value indicating whether or not this column is part of its table's primary key.
is_numeric
Returns a boolean value indicating whether the column is a numeric type column.
is_integer
Returns a boolean value indicating whether the column is a numeric type column.
is_floating_point
Returns a boolean value indicating whether the column is a numeric type column.
is_character
Returns a boolean value indicating whether the column is a character type column.
This is true only for any columns which are defined to hold text data, regardless of size.
is_date
Returns a boolean value indicating whether the column is a date type column.
is_datetime
Returns a boolean value indicating whether the column is a datetime type column.
is_time
Returns a boolean value indicating whether the column is a time type column.
is_time_interval
Returns a boolean value indicating whether the column is a time interval type column.
is_blob
Returns a boolean value indicating whether the column is a blob column.
This is true for any columns defined to hold binary data, regardless of size.
generic_type
This methods returns one of the following strings:
integer
floating_point
character
date
datetime
time
blob
unknown
definition
The definition object is very rarely of interest. Use the "type()" method if you are only interested in the column's type.
This methods returns the "Alzabo::ColumnDefinition" object which holds this column's type information.
comment
Returns the comment associated with the column object, if any.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Column(3pm)