|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
How to extract one column from csv file in perl?
Post 302475540 by kvth on Monday 29th of November 2010 05:01:40 AM
11-29-2010
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi everybody
I have some problems with PERL programming.
I have a file with two columns, both with numeric values.
I have to extract the values > 50 from the 2nd columns and sum them among them.
The I have to sum the respective values in the first column on the same line and, at the end, I... (6 Replies)
Discussion started by: m_elena
6 Replies
2. Shell Programming and Scripting
Hi I have a csv file which is below
A,5
B,6
C,10
D,7
I want the values who's second column is greater than 7
say
C,10
D,7
Help me please...
Thanks,
Maruth (3 Replies)
Discussion started by: maruthavanan
3 Replies
3. Shell Programming and Scripting
Can Anyone tell me how to extract the second column of a xls sheet
And compare the content of each row of the column with a .h file.
xls sheet is having only one spreadsheet. (2 Replies)
Discussion started by: suvenduperl
2 Replies
4. Shell Programming and Scripting
Hello Gurus
I have a source file which has the first line as header and the rest are the records
I need to extract the first column from the second line to extract a value
I/P
... (7 Replies)
Discussion started by: Pratik4891
7 Replies
5. Shell Programming and Scripting
Greetings, salutations.
I have a 3 column csv file with ~13 million rows and I would like to generate a correlation matrix. Interestingly, you all previously provided a solution to the inverse of this problem. Thread title: "awk? adjacency matrix to adjacency list / correlation matrix to list"... (6 Replies)
Discussion started by: R3353
6 Replies
6. Shell Programming and Scripting
Hi
I want to grep a column 6 & column 7 from a CSV Format file & then i have to find the difference between these columns as these both columns contains date & time in 7/7/2012 9:20 this format . So kindly help me out ASAP.
But please kindly dis xls has to be converted in csv format as may... (5 Replies)
Discussion started by: Prateek@123
5 Replies
7. Shell Programming and Scripting
Hi,
I am trying with the below Perl one-liner using regular expression to extract the first and second column of a text file:
perl -p -e "s/\s*(\w+).*/$1/"
perl -p -e "s/\s*.+\s(.+)\s*/$1\n/"
whereas the text file's data looks like:
Error: terminated 2233
Warning: reboot 3434
Warning:... (3 Replies)
Discussion started by: royalibrahim
3 Replies
8. Shell Programming and Scripting
Hi,
I want to extract first column from a file and redirect the output to another file in perl.
I am able to do this from command line by executing below commands.
perl -anle 'print $F' Input.dat > Output.dat
perl -ne '@F = split("\t", $_); print "$F\n";' Input.dat > Output.dat
perl -anE... (7 Replies)
Discussion started by: Neethu
7 Replies
9. Shell Programming and Scripting
Hi, I am newbie in shell script.
I need your help to solve my problem.
Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file.
File1:
SourceFile,DateTimeOriginal
/home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies
10. UNIX for Beginners Questions & Answers
file1:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,47
GETregistry,100,21592,0.00%,13
GEThomeLayout,100,30466,0.00%,17
file2:
Name,Threshold,Curr Samples,Curr Error%,Curr ART
GETHome,100,21601,0.00%,33
GETregistry,100,21592,0.00%,22... (6 Replies)
Discussion started by: Raghuram717
6 Replies
LEARN ABOUT PHP
db2_field_type
DB2_FIELD_TYPE(3) 1 DB2_FIELD_TYPE(3) db2_field_type - Returns the data type of the indicated column in a result set SYNOPSIS
string db2_field_type (resource $stmt, mixed $column) DESCRIPTION
Returns the data type of the indicated column in a result set. PARAMETERS
o $stmt - Specifies a statement resource containing a result set. o $column - Specifies the column in the result set. This can either be an integer representing the 0-indexed position of the column, or a string containing the name of the column. RETURN VALUES
Returns a string containing the defined data type of the specified column. If the specified column does not exist in the result set, db2_field_type(3) returns FALSE. SEE ALSO
db2_field_display_size(3), db2_field_name(3), db2_field_num(3), db2_field_precision(3), db2_field_scale(3), db2_field_width(3). PHP Documentation Group DB2_FIELD_TYPE(3)