I have the below file ...where some of the column values should replaced with desired values ....below file u can find that 3 column where ever 'AAA' comes should replaced with ' CC '
NOTE : we have to pass the column number ,AAA,CC (modified value) as the parameters to the code.
... (6 Replies)
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Hello,
I have a file with four columns and I would like to replace values in the second column only.
An arbitrary example is:
100 A 105 B
200 B 205 C
300 C 305 D
400 D 405 E
500 E 505 F
I need to replace the second column as shown below:
... (4 Replies)
Dear all,
I have a file1.pdb in pdb format and a dat file2 containing values, corresponding to the atoms in the pdb file. these values (file2.dat) need to be in the column instead of the 0.00 (file1) values for each atom in file1.pdb .(the red values must be replaced by the blue ones,in order)... (11 Replies)
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
I have one file as it has the following format
File1
S No Site IP Address
1 Australia 192.168.0.1/26
2 Australia 192.168.0.2/26
3 Australia 192.168.0.3/26
I need awk/sed command to replace the column2 value ( under Site) with some other... (8 Replies)
I'm trying to make an awk script to compare values I've set as var1, var2, and var3 earlier in the script to the values in the userinputted column of four text files called Node1.txt, Node2.txt, Node3.txt, and Node4.txt and then replace the values in that userinputted column with either ttt or gcc,... (8 Replies)
Hi All,
I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7
I tried
awk '{gsub("8","7",$35)}1' infile > outfile ----> not working
sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies
LEARN ABOUT DEBIAN
alzabo::create::columndefinition
Alzabo::Create::ColumnDefinition(3pm) User Contributed Perl Documentation Alzabo::Create::ColumnDefinition(3pm)NAME
Alzabo::Create::ColumnDefinition - Column definition object for schema creation
SYNOPSIS
use Alzabo::Create::ColumnDefinition;
DESCRIPTION
This object holds information on a column that might need to be shared with another column. The reason this class exists is that if a col-
umn is a key in two or more tables, then some of the information related to that column should change automatically in multiple places
whenever it changes at all. Right now this is only type ('VARCHAR', 'NUMBER', etc) and length/precision information. This object also has
an 'owner', which is the column which created it.
INHERITS FROM
"Alzabo::ColumnDefinition"
Note: all relevant documentation from the superclass has been merged into this document.
METHODS
new
This method takes the following parameters:
* owner => "Alzabo::Create::ColumnDefinition" object
* type => $type
It returns a new "Alzabo::Create::ColumnDefinition" object.
alter
See the "Alzabo::Column->alter()" method for details.
type
Returns the object's type as a string.
set_type ($string)
Sets the object's type.
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
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.
set_length
This method takes the following parameters:
* length => $length
* precision => $precision (optional)
Sets the column's length and precision. The precision parameter is optional (though some column types may require it if the length is
set).
Throws: "Alzabo::Exception::Params", "Alzabo::Exception::RDBMSRules"
owner
Returns the "Alzabo::Create::Column" object that owns this definitions (the column that created it).
perl v5.8.8 2007-12-23 Alzabo::Create::ColumnDefinition(3pm)