Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Field Number read and "wc -l"

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Field Number read and "wc -l"
# 8  
Old 05-27-2013
Just try
Code:
find . -name "*.csv" -type f -print | xargs awk -F"," ' $14 ~ /6010|2345|5690|8670|4567/ { print $0 ; ++cpt } END { print cpt} '

This User Gave Thanks to Fundix For This Post:
kekanap
# 9  
Old 05-27-2013
I am still getting a syntax error my friend.
# 10  
Old 05-27-2013
Strange, works fine for me here on Aix systems.
Can you please paste the command and the error outputs ?
# 11  
Old 05-27-2013
Code:
-bash-3.2$ find . -name "*_201304*.csv" -type f -print | xargs awk -F"," ' $14 ~ /9100/9101/9102/9103/9104/9105/9106/9150/9151/9152/9153/9200/9201/9202/9203/9300/9301/9302/9303/9304/9305/9400/9401/9510/9511/ { print $0 ; ++cpt } END { print cpt} '|wc -l
+ wc -l
+ xargs awk -F, ' $14 ~ /9100/9101/9102/9103/9104/9105/9106/9150/9151/9152/9153/9200/9201/9202/9203/9300/9301/9302/9303/9304/9305/9400/9401/9510/9511/ { print $0 ; ++cpt } END { print cpt} '
+ find . -name '*_201304*.csv' -type f -print
awk:  $14 ~ /9100/9101/9102/9103/9104/9105/9106/9150/9151/9152/9153/9200/9201/9202/9203/9300/9301/9302/9303/9304/9305/9400/9401/9510/9511/ { print $0 ; ++cpt } END { print cpt}
awk:                                                                                                                                       ^ syntax error
awk:  $14 ~ /9100/9101/9102/9103/9104/9105/9106/9150/9151/9152/9153/9200/9201/9202/9203/9300/9301/9302/9303/9304/9305/9400/9401/9510/9511/ { print $0 ; ++cpt } END { print cpt}
awk:                                                                                                                                       ^ syntax error
awk:  $14 ~ /9100/9101/9102/9103/9104/9105/9106/9150/9151/9152/9153/9200/9201/9202/9203/9300/9301/9302/9303/9304/9305/9400/9401/9510/9511/ { print $0 ; ++cpt } END { print cpt}
awk:                                                                                                                                       ^ syntax error
0
-bash-3.2$

Last edited by Scrutinizer; 05-29-2013 at 04:15 PM.. Reason: code tags
# 12  
Old 05-27-2013
You forgot the pipes in the regex: $14 ~ /9100|9101|9102|...
This User Gave Thanks to Subbeh For This Post:
kekanap
# 13  
Old 05-27-2013
wow it works like magic thank you very much my friends

---------- Post updated at 05:26 PM ---------- Previous update was at 05:24 PM ----------

Thank you friends.Smilie
# 14  
Old 05-27-2013
Quote:
Originally Posted by kekanap
wow it works like magic thank you very much my friends
You'll find several wizards around these forums who are strong with Unix magic. Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Failure: if grep "$Var" "$line" inside while read line loop

Hi everybody, I am new at Unix/Bourne shell scripting and with my youngest experiences, I will not become very old with it :o My code: #!/bin/sh set -e set -u export IFS= optl="Optl" LOCSTORCLI="/opt/lsi/storcli/storcli" ($LOCSTORCLI /c0 /vall show | grep RAID | cut -d " "... (5 Replies)
Discussion started by: Subsonic66
5 Replies

2. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

3. Shell Programming and Scripting

Awk,sed : change every 2nd field ":" to "|"

Hi Experts, I have a string with colon delimited, want 2nd colon to be changed to a pipe. data: 101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3: I am trying with sed, but can change only 1 occurance: echo "101:8:43:4:72:14:41:69:85:3:137:4:3:0:4:0:9:3:0:3:12:3:" | sed 's/:/|/2'... (5 Replies)
Discussion started by: rveri
5 Replies

4. UNIX for Advanced & Expert Users

Should I say "field 8" or "column 8" in this case?

I saw some recent posts where I thought the terms "field" and "column" were being misused. I work with data a lot, and have my opinions. I'm wondering if those opinions are correct. ***** Rows seem clear - I don't think there is any controversy about what a row is, either for database or text... (10 Replies)
Discussion started by: hanson44
10 Replies

5. Shell Programming and Scripting

Read from "list1" and list matches in "list2"

I want to print any matching IP addresse in List1 with List 2; List 1 List of IP addresses; 161.85.58.210 250.57.15.129 217.23.162.249 74.76.129.101 30.221.177.237 3.147.200.59 170.58.142.64 127.65.109.33 150.167.242.146 223.3.20.186 25.181.180.99 2.55.199.32 (3 Replies)
Discussion started by: lewk
3 Replies

6. Shell Programming and Scripting

Purpose of "read" and "$END$" in ksh ?

Hi, Could anyone please shed some light on the following script lines and what is it doing as it was written by an ex-administrator? cat $AMS/version|read a b verno d DBVer=$(/usr/bin/printf "%7s" $verno) I checked that the cat $AMS/version command returns following output: ... (10 Replies)
Discussion started by: dbadmin100
10 Replies

7. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

8. UNIX for Dummies Questions & Answers

Explanation of "total" field in "ls -l" command output

When I do a listing in one particular directory (ls -al) I get: total 43456 drwxrwxrwx 2 root root 4096 drwxrwxrwx 3 root root 4096 -rwxrwxr-x 1 nobody nobody 3701594 -rwxrwxr-x 1 nobody nobody 3108510 -rwxrwxr-x 1 nobody nobody 3070580 -rwxrwxr-x 1 nobody nobody 3099733 -rwxrwxr-x 1... (1 Reply)
Discussion started by: proactiveaditya
1 Replies

9. Shell Programming and Scripting

read -p "prompt text" foo say "read: bad option(s)" in Bourne-Shell

Hallo, i need a Prompting read in my script: read -p "Enter your command: " command But i always get this Error: -p: is not an identifier When I run these in c-shell i get this error /usr/bin/read: read: bad option(s) How can I use a Prompt in the read command? (9 Replies)
Discussion started by: wiseguy
9 Replies

10. Shell Programming and Scripting

how to request a "read" or "delivered" receipt for mails

Dears, I've written a script which allows me to send mails in different formats with different attaches. Now I still want to add a feature to this script. My users would like to be able to receive a "read" or "delivered" receipt for their mails. The script send mails on behalve of an specific... (1 Reply)
Discussion started by: plelie2
1 Replies
Login or Register to Ask a Question