|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Extract a certain field from a CSV?
Post 302497190 by Scott on Wednesday 16th of February 2011 02:26:38 PM
02-16-2011
Quote:
How would I, for example, extract the gender out of a certain person
Quote:
maybe based on the year of birth
Using , as a field separator, based on your input, the name would be in $1, the year of birth in $2, etc.
Code:
$2 == 1940 { print $3 }
$2 == 1940 { print $1, $3 }
$1 == "Bruce Lee" { print $3 }
$1 == "Bruce Lee" && $2 == 1940 { print $3 }
This User Gave Thanks to Scott For This Post:
|
|
10 More Discussions You Might Find Interesting
1. Linux
Hi, I need to replace a field (field 5) in a csv file, based on the content of another field (field 2), something like this:
actual file:
field1, field2, filed3, field4, field5, field6
01,232,abb-pan,679,,pan
02,565,cdf-pan,683,,pan
the result should be:
... (4 Replies)
Discussion started by: pcboss
4 Replies
2. UNIX for Dummies Questions & Answers
print "count,pub,prodline,group,sector,date,source" > $fname
cat sp_log.summary.$firstday-$lastday.ProdlineSector | sed "s/^ *//g;s/ *$//g" >sp_log.summary.$firstday-$lastday
cat sp_log.summary.$firstday-$lastday | sed "s/$/ $lastyy-$lastmm cache/;s/ /,/g" >> $fname
cat $fname | sed... (1 Reply)
Discussion started by: shikhakaul
1 Replies
3. Shell Programming and Scripting
Hello all,
I've a CSV file and need to replace 5th field if its value is "X".
The exact requirement is to replace 5th field (column) with "Y" if
a. it's value is "X" AND
b. the line must start with ABC string
i guess this can be done with awk. Pl help.
For security reasons, the... (2 Replies)
Discussion started by: prvnrk
2 Replies
4. Shell Programming and Scripting
Hi,
I need to extract values from a CSV file based on some conditions as explained below:
File format details:
1. each set starts with AAA only
2. number of columns is fixed
3. number of rows per set may vary (as they are having different CCC rows)
Now, i need to extract 3rd column of... (3 Replies)
Discussion started by: prvnrk
3 Replies
5. Shell Programming and Scripting
Hi all I am new to unix . I need to write a script that extracts some data from oracle into a .csv file with heading of the columns in the file
SO i created the following two scripts but they are not working
ac.sql (this is the sql file that i will call inside the shell script when i run... (1 Reply)
Discussion started by: rajesh_tns
1 Replies
6. Shell Programming and Scripting
I have a csv file that I need to extract some data from depending on another field after reading info from another text file.
The text file would say have 592560 in it.
The csv file may have some data like so
Field 1 Field2 Field3 Field4 Field5 Field6
20009756 1 ... (9 Replies)
Discussion started by: GroveTuckey
9 Replies
7. Shell Programming and Scripting
How can I select the bold fields from the following?
"CLLI","SWREL","RPTDATE","RPTIME","TZ","RPTTYPE","RPTPD","IVALDATE","IVALSTART","IVALEND","NUMENTIDS"
"tklc9010801","EAGLE5 45.0.0-64.70.1","2013-08-07","02:01:50","MST ","COMPONENT MEASUREMENTS ON... (4 Replies)
Discussion started by: leghorn
4 Replies
8. Shell Programming and Scripting
Hi
I have a job status csv file. I want to update the status of the job in the file.
Below is the csv file
1,jobname1,in_progress,starttime,somthing,somthing
2,jobname2,completed,starttime,somthing,somthing
3,jobname3,failed,starttime,somthing,somthing... (8 Replies)
Discussion started by: midhun19
8 Replies
9. Linux
I have a .CSV file (file.csv) whose data are all enclosed in double quotes. Sample format of the file is as below:
column1,column2,column3,column4,column5,column6, column7, Column8, Column9, Column10
"12","B000QRIGJ4","4432","string with quotes, and with a comma, and colon: in... (3 Replies)
Discussion started by: dhruuv369
3 Replies
10. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
LEARN ABOUT DEBIAN
clags2.f
clags2.f(3) LAPACK clags2.f(3) NAME
clags2.f - SYNOPSIS
Functions/Subroutines subroutine clags2 (UPPER, A1, A2, A3, B1, B2, B3, CSU, SNU, CSV, SNV, CSQ, SNQ) CLAGS2 Function/Subroutine Documentation subroutine clags2 (logicalUPPER, realA1, complexA2, realA3, realB1, complexB2, realB3, realCSU, complexSNU, realCSV, complexSNV, realCSQ, complexSNQ) CLAGS2 Purpose: CLAGS2 computes 2-by-2 unitary matrices U, V and Q, such that if ( UPPER ) then U**H *A*Q = U**H *( A1 A2 )*Q = ( x 0 ) ( 0 A3 ) ( x x ) and V**H*B*Q = V**H *( B1 B2 )*Q = ( x 0 ) ( 0 B3 ) ( x x ) or if ( .NOT.UPPER ) then U**H *A*Q = U**H *( A1 0 )*Q = ( x x ) ( A2 A3 ) ( 0 x ) and V**H *B*Q = V**H *( B1 0 )*Q = ( x x ) ( B2 B3 ) ( 0 x ) where U = ( CSU SNU ), V = ( CSV SNV ), ( -SNU**H CSU ) ( -SNV**H CSV ) Q = ( CSQ SNQ ) ( -SNQ**H CSQ ) The rows of the transformed A and B are parallel. Moreover, if the input 2-by-2 matrix A is not zero, then the transformed (1,1) entry of A is not zero. If the input matrices A and B are both not zero, then the transformed (2,2) element of B is not zero, except when the first rows of input A and B are parallel and the second rows are zero. Parameters: UPPER UPPER is LOGICAL = .TRUE.: the input matrices A and B are upper triangular. = .FALSE.: the input matrices A and B are lower triangular. A1 A1 is REAL A2 A2 is COMPLEX A3 A3 is REAL On entry, A1, A2 and A3 are elements of the input 2-by-2 upper (lower) triangular matrix A. B1 B1 is REAL B2 B2 is COMPLEX B3 B3 is REAL On entry, B1, B2 and B3 are elements of the input 2-by-2 upper (lower) triangular matrix B. CSU CSU is REAL SNU SNU is COMPLEX The desired unitary matrix U. CSV CSV is REAL SNV SNV is COMPLEX The desired unitary matrix V. CSQ CSQ is REAL SNQ SNQ is COMPLEX The desired unitary matrix Q. Author: Univ. of Tennessee Univ. of California Berkeley Univ. of Colorado Denver NAG Ltd. Date: November 2011 Definition at line 158 of file clags2.f. Author Generated automatically by Doxygen for LAPACK from the source code. Version 3.4.1 Sun May 26 2013 clags2.f(3)