05-29-2013
Implementing operators on multiple fields
Hallo Friends,
Have a look at my script:
awk -F',' '$14==9100' *_201304*.csv|wc -l > pax1;
awk -F',' '$14==9101' *_201304*.csv|wc -l >>pax1;
awk -F',' '$14==9102' *_201304*.csv|wc -l >>pax1;
awk -F',' '$14==9103' *_201304*.csv|wc -l >>pax1
I would like to include field 42. like below
HTML Code:
awk -F',' ['$14==9101' , '$42!=0'] *_201304*.csv|wc -l > pax1
Basically my script is saying if field 14 = 9101 and field 42 is not zero then wc -l . Please help with my syntax
Regards,
10 More Discussions You Might Find Interesting
1. Programming
Hi,
Is it possible to use bitwise operators in bit fields?
For example:
typedef struct Mystruct {
unsigned char A :1 ;
unsigned char B :1 ;
} Mystruct;
and assume
struct Mystruct STR_1S, STR_2S, tempSTRS = {0};
then the following line:
tempSTRS = STR_1S & STR_2S;
gives the... (3 Replies)
Discussion started by: amatsaka
3 Replies
2. Shell Programming and Scripting
Is it possible to do a join on multiple fields of two files? I am trying to do something like join -t, -1 2,3 -2 2,3 -o 2.1,2.2,2.3,1.3 filea fileb
I want the join to be on columns 2 and 3 of filea and columns 2 and 3 of fileb.
What is hapenning is that the second file that I want to do the join... (1 Reply)
Discussion started by: reggiej
1 Replies
3. Shell Programming and Scripting
hello all
I have a file names xxx with data like
1,2,3,12
1,3,6,12
1,3,5,12
2,4,6,12
6,5,6,12
4,2,7,12
4,1,3,12
I wish to sort this file xxx on first three fields in ascending order.
OUPUT should be like
1,2,3,12
1,3,5,12
1,3,6,12
2,4,6,12 (4 Replies)
Discussion started by: vasuarjula
4 Replies
4. Shell Programming and Scripting
Hello All
I have data in a flat file with numeric and aplha numeric datatypes.
Now i have to sort on multiple fileds.
Can any body please give me the sort code?
i am particularly confused about the sort code like
sort -n +0 -1 +1 -2 .... (1 Reply)
Discussion started by: vasuarjula
1 Replies
5. UNIX for Dummies Questions & Answers
Hi, I need help with the join command
I have 2 files that I want to join on multiple fields.
I want to return all records from file 1
I also want empty fields in my joined file if there isn't a match in file 2
I have already sorted them so I know they are in the same order.
file1 ... (0 Replies)
Discussion started by: shunter0810
0 Replies
6. UNIX for Dummies Questions & Answers
Hi,
shell is /bin/ksh
I am trying to do the following in my code.. but its showing me an error
if ] && ] ]]; then
echo "id is $ida and chk_dy is $chk_dy"
fi
the error I get is
syntax error at line 23 : `"$ida"' unexpected
I need to execute the... (2 Replies)
Discussion started by: nss280
2 Replies
7. UNIX for Dummies Questions & Answers
I'm trying extract a number of filename fields from a log file and copy them out as separate rows in a text file so i can load them into a table. I'm able to get the filenames but the all appear on one line. I tried using the cut command with the -d (delimiter) option but cant seem to make it... (1 Reply)
Discussion started by: Sinbad-66
1 Replies
8. Shell Programming and Scripting
I figured this would be simple, but I am stuck.
Variable longpath="/dir1/dir2/dir3/filename.stuff.morestuff.garbage"
I want to end up with just "filename.extra.moreextra". So, I want to get rid of the path and .garbage
I want to do this with just ksh internals. So, no sed,grep,awk,expr,... (4 Replies)
Discussion started by: Topaz
4 Replies
9. Shell Programming and Scripting
Hi
I want to send a status mail if daily or weekly or monthly batch completed or aborted. Here is the code.
if && &&
||
Else if &&
&& ||
Else if &&
&& ||
then
mailx –s “Status Report” sumone@sumthing.com
else
print ”try again”
Plz suggest the changes. (3 Replies)
Discussion started by: Avi
3 Replies
10. Shell Programming and Scripting
I am trying to find a way to repeat fields. I am not really sure how to explain it so let me just post a sample and what I want it to look like.
888123 66232 18 1
19
44422 11 7
23
881133 66231 33 1
34 ... (4 Replies)
Discussion started by: DerangedNick
4 Replies
LEARN ABOUT DEBIAN
csv2rec
CSV2REC(1) User Commands CSV2REC(1)
NAME
csv2rec - csv to rec converter
SYNOPSIS
csv2rec [OPTIONS]... [CSV_FILE]
DESCRIPTION
Convert csv data into rec data.
-t, --type=TYPE
type name for the converted records; if this parameter is ommited then no type is used.
-s, --strict
be strict parsing the csv file.
-e, --omit-empty
omit empty fields.
--help print a help message and exit.
--version
show version and exit.
AUTHOR
Written by Jose E. Marchesi.
REPORTING BUGS
Report bugs to: bug-recutils@gnu.org
GNU recutils home page: <http://www.gnu.org/software/recutils/>
General help using GNU software: <http://www.gnu.org/gethelp/>
COPYRIGHT
Copyright (C) 2010, 2011, 2012 Jose E. Marchesi. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
The full documentation for csv2rec is maintained as a Texinfo manual. If the info and csv2rec programs are properly installed at your
site, the command
info csv2rec
should give you access to the complete manual.
csv2rec 1.4.93 January 2012 CSV2REC(1)