12-07-2010
Thanks a lot. I am getting correct data.
However title for new columns is coming as key1,10. I expect it as key, value. Is there a way to get correct column title too.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I want to select the first column from a daily file called foo.csv. The result is written to file foo.txt. Currently the following script is used for that:
cut -d, -f 1 foo.csv > foo.txt
A typical result would yield :
A12
A45
B11
B67
What needs to happen in addition is that two columns... (5 Replies)
Discussion started by: figaro
5 Replies
2. Shell Programming and Scripting
not required this time (36 Replies)
Discussion started by: Sandeep_Malik
36 Replies
3. UNIX for Dummies Questions & Answers
Hi everybody,
I've got two simples file1 like:
aaa aaa aaa
bbb bbb bbb
ccc ccc ccc
and file2 like:
111 111 111
222 222 222
333 333 333
I need to:
1) add a line say "new line" as the first line of the file
2)add a column from file2 (say column3) to file1; the new column should... (14 Replies)
Discussion started by: zajtat
14 Replies
4. Shell Programming and Scripting
Hi I am trying to write a bash script to add a line of text to the middle of a file.
The way I worked it out was to calculate the number of lines and divide by 2. The file I am using is called newfile and it just contains lines of data.
The new file I have created I have called midfile and... (7 Replies)
Discussion started by: BundBash
7 Replies
5. Shell Programming and Scripting
Good afternoon to everyone,
I have some input and output from various widgets that I am trying to get to play nicely together. Basically I would like to stay out of excel and be able to automate the entire process. I have read some posts here about how to use awk, nawk, etc, to do similar... (9 Replies)
Discussion started by: LMHmedchem
9 Replies
6. Shell Programming and Scripting
Hi All ,
Kindly help me with this soln
awk '{printf "%s %7s \n", $1,$c}' infile
where
value of variable c I am externally giving input
But executing the above command shows all the columns of infile where as I want only 1st column of infile and 2nd column should print value c (8 Replies)
Discussion started by: Pratik4891
8 Replies
7. UNIX for Dummies Questions & Answers
Hello,
I have a file with several lines and I need to trim and pad with spaces the data that are between position 6 and 15 included. Data in position 1 to 5 and after 15 could be anything, and should stay as they are.
For instance, the following records in a file (underscore = space)... (4 Replies)
Discussion started by: BSF
4 Replies
8. UNIX for Dummies Questions & Answers
I have a file in which I need to add more columns to based on a key in the first file:
File1
key1,abc,123,
key2,def,456,
key3,ghi,789,
File2
key2,zyx,111,qqq,
key3,yuu,222,www,
key1,pui,333,eee,
key4,xxx,999,rrr,
I would like to create the following output:
Output (1 Reply)
Discussion started by: WongSifu
1 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have a tab delimited text file with three columns:
Input:
1 25734 25737
1 32719 32724
1 59339 59342
1 59512 59513
1 621740 621745
For each row of the text file I want to print out all the values between the second and third columns, including them. The... (3 Replies)
Discussion started by: evelibertine
3 Replies
10. Shell Programming and Scripting
Hi ,
I need to add few new columns in existing file .Any help would be great
ex:
existing file
name,typ,add,dept
New file(com1,sal are new)
name,com1,type,sal,add,dept
Thanks,
mohan (1 Reply)
Discussion started by: mohan705
1 Replies
LEARN ABOUT MOJAVE
dbix::class::resultsourceproxy::table5.18
DBIx::Class::ResultSourceProxy::Table(3) User Contributed Perl Documentation DBIx::Class::ResultSourceProxy::Table(3)
NAME
DBIx::Class::ResultSourceProxy::Table - provides a classdata table object and method proxies
SYNOPSIS
__PACKAGE__->table('cd');
__PACKAGE__->add_columns(qw/cdid artist title year/);
__PACKAGE__->set_primary_key('cdid');
METHODS
add_columns
__PACKAGE__->add_columns(qw/cdid artist title year/);
Adds columns to the current class and creates accessors for them.
table
__PACKAGE__->table('tbl_name');
Gets or sets the table name.
table_class
__PACKAGE__->table_class('DBIx::Class::ResultSource::Table');
Gets or sets the table class used for construction and validation.
has_column
if ($obj->has_column($col)) { ... }
Returns 1 if the class has a column of this name, 0 otherwise.
column_info
my $info = $obj->column_info($col);
Returns the column metadata hashref for a column. For a description of the various types of column data in this hashref, see "add_column"
in DBIx::Class::ResultSource
columns
my @column_names = $obj->columns;
AUTHOR AND CONTRIBUTORS
See AUTHOR and CONTRIBUTORS in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself.
perl v5.18.2 2013-12-16 DBIx::Class::ResultSourceProxy::Table(3)