I am a new member and this is my very first post on this forum. I am naive to the world of Unix, so my apologies for any stupid questions
I am trying to manipulate a csv file, say input_file.csv. One of the columns in this file ($8 = Group No.) contains some codes (X codes). This is big file containing some 20,000 rows.
I have a list (say list name is no_x_code_list) of X codes (they are some 20-25 codes) that need not be processed, means they needs to be removed from input_file.csv.
I am thinking of an awk script that looks something like this:
But I am not sure how to implement the bold portion of the script above. Any idea? Or any other way to achieve this?
regards,
juzz4fun
Last edited by Scott; 05-03-2013 at 03:27 PM..
Reason: Code tags
Thank you very much, Yoda.
I forgot to mention that the list I am talking about is nothing but a Unix variable below. Sorry for that...
Your solution would work perfectly if X codes are stored in a separate file.
And in the same script, I am writing the awk script.
Last edited by Scott; 05-03-2013 at 03:28 PM..
Reason: Please use code tags
echo "$no_x_code_list" is a list.
Not nice for awk. Convert to a file format and feed that to awk.
awk reads from stdin when the filename is '-'.
You need a Posix awk or GNU awk or nawk.
This User Gave Thanks to MadeInGermany For This Post:
Thanks MadeInGermany.
I tried to embed this logic in my current script, but it is giving me hard time
Used nawk instead of simple awk.
Getting below error:
Will the syntax changes if I use nawk?
Can you explain me how it works what you said? I mean, how does awk handles two inputs - one from echo and other one from .csv file?
I am thinking to start reading about these stuffs soon.
Last edited by Scott; 05-04-2013 at 02:23 AM..
Reason: Please use code tags
awk is a series of condition {action code}
so it is !($8 in A) {print $0}
not !($8 in A) print $0!
At the end of the script-line a missing action code defaults to {print $0}.
A missing condition is "always true" and the action code can have if statements, so you can also write it as { if (!($8 in A)) print $0 }.
Last edited by MadeInGermany; 05-03-2013 at 10:11 PM..
I'm trying to create a shell script that takes a awk script that I wrote and a filename as an argument. I was able to get that done but I'm having trouble figuring out how to keep the header of the output at the top but sort the rest of the rows alphabetically. This is what I have now but it is... (1 Reply)
Hi
I have a text file (Input.txt) with two column entries separated by tab as given below:
aaa str1
bbb str2
cccccc str3
dddd str4
eee str3
ssss str2
sdf str3
hhh str1
fff str2
ccc str3
.....
.....
..... (1 Reply)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff |... (1 Reply)
Discussion started by: Sarita Behera
1 Replies
4. Post Here to Contact Site Administrators and Moderators
Variable I have in my shell script
diff=$1$2.diff
id=$2
new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk -F'~' ''$2 == "$id"' {print $0}' > $new
I could see value of $id is not passing to the awk... (0 Replies)
I am getting the following error while passing parameter to a shell script called within awk script. Any idea what's causing this issue and how to ix it ? Thanks
sh: -c: line 0: syntax error near unexpected token `newline'
sh: -c: line 0: `./billdatecalc.sh ... (10 Replies)
This is the final first release of the dynamic menu generator for pekwm (WM).
#!/bin/bash
function param_val {
awk "/^${1}=/{gsub(/^${1}="'/,""); print; exit}' $2
}
echo "Dynamic {"
for CF in `ls -c1 /usr/share/applications/*.desktop`
do
name=$(param_val Name $CF)
... (3 Replies)
hi everyone
i am trying to do this
bash> cat abc.sh
deepak()
{
echo Deepak
}
deepak
bash>./abc.sh
Deepak
so it is giving me write simply i created a func and it worked
now i modified it like this way
bash> cat abc.sh (2 Replies)
Hello,
I have this awk script that I want to execute by passing parameters through a shell script.
I'm a little confused. This awk script removes duplicates from an input file.
Ok, so I have a .sh file called rem_dups.sh
#!/usr/bin/sh... (4 Replies)
Hi guys
I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file.
#!/bin/sh
echo " $2 $3 $4 $5 $6 $7
isql -w400 -U$2 -S$5 -P$3 << xxx
use $4
go
print"**Changes to the table... (0 Replies)