Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

File Read using awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting File Read using awk
# 1  
Old 05-04-2008
File Read using awk
Hi,

I need to read two colums(4th and 5th) from a file and do some manipulation

Input file is
401500 IOC Q 14 14
406200 LC Q 1 1
410124 IOC Q 5 4
410124 LC Q 11 8
410132 IOC Q 230 229
410148 IOC Q 5 5
410148 LC Q 11 11
410156 IOC Q 116 116
410156 LC Q 2038 2031

condition that i need to check is

f $4 > $5
diff = $4-$5
elif $5 > $4
diff=$5-$4
errpct = $4*0.05
if errpct > diff
error
else if errpct -le diff
success

How can i achive this using shell script. Please help
# 2  
Old 05-04-2008
What have you done to attempt to solve this problem?
Post your sample script, and we'll see how we can assist.

Regards
# 3  
Old 05-05-2008
Code:
nawk '{
errpct=$4*0.05
if ($4>$5)
	diff=$4-$5
else
	diff=$5-$4
if (errpct > diff)
	print $0" error"
else
	print $0" success"

}' file

output:
Code:
401500 IOC Q 14 14 error
406200 LC Q 1 1 error
410124 IOC Q 5 4 success
410124 LC Q 11 8 success
410132 IOC Q 230 229 error
410148 IOC Q 5 5 error
410148 LC Q 11 11 error
410156 IOC Q 116 116 error
410156 LC Q 2038 2031 error

# 4  
Old 05-05-2008
Using Conditional Operators

awk '{if (($4*0.05) > ( ($4>$5 ? $4-$5 : $5-$4))) print $0,"error"
else
print $0,"Success" }' test1

401500 IOC Q 14 14 error
406200 LC Q 1 1 error
410124 IOC Q 5 4 Success
410124 LC Q 11 8 Success
410132 IOC Q 230 229 error
410148 IOC Q 5 5 error
410148 LC Q 11 11 error
410156 IOC Q 116 116 error
410156 LC Q 2038 2031 error
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Use while loop to read file and use ${file} for both filename input into awk and as string to print

I have files named with different prefixes. From each I want to extract the first line containing a specific string, and then print that line along with the prefix. I've tried to do this with a while loop, but instead of printing the prefix I print the first line of the file twice. Files:... (3 Replies)
Discussion started by: pathunkathunk
3 Replies

2. Shell Programming and Scripting

Read values from second file in awk

Hello Friends, I have written a script like the following, which finds some logs and fetchs some desired rows and then calculate average processing time of a spesific application. if then echo echo "----- There are three arguments which is expected to run this script! ... (5 Replies)
Discussion started by: EAGL€
5 Replies

3. UNIX for Advanced & Expert Users

Using awk to read a file and process

I am fairly green using awk so I don't have anything started but what I am trying to do is: I have a file called "contacts" and in the file are 3 fields separate by ;. I want to read each line and send an email script. I have the email function working but just need to know how to setup awk to... (8 Replies)
Discussion started by: ziggy6
8 Replies

4. Shell Programming and Scripting

Using awk instead of while loop to read file

Hello, I have a huge file, I am currently using while loop to read and do some calculation on it, but it is taking a lot of time. I want to use AWK to read and do those calculations. Please suggest. currently doing: cat input2 | while read var1 do num=`echo $var1 | awk... (6 Replies)
Discussion started by: anand2308
6 Replies

5. Shell Programming and Scripting

Help on awk to read xml file

Hello, I have a xml file as shown below. I want to parse the file and store data in variables. xml file looks like: <TEST NAME="DataBaseurl">jdbc:oracle:thin:@localhost:1521:ora10</TEST> <TEST NAME="Databaseuser">Pradeep</TEST> ...... and many other such lines i want to read this file and... (2 Replies)
Discussion started by: pradeepmacha
2 Replies

6. Shell Programming and Scripting

awk line to read file

OK, I want to read a textfile `base.txt` looking like this: MASTER SLAVE PERP_BASE /_\ DAYS /_\ DOPPLER x20080613 x20080829 123.3909 77 11.04877 x20080613 x20080909 -5.9504 88 -12.78454 x20080613... (2 Replies)
Discussion started by: friend
2 Replies

7. Shell Programming and Scripting

Read a file and search a value in another file create third file using AWK

Hi, I have two files with the format shown below. I need to read first field(value before comma) from file 1 and search for a record in file 2 that has the same value in the field "KEY=" and write the complete record of file 2 with corresponding field 2 of the first file in to result file. ... (11 Replies)
Discussion started by: King Kalyan
11 Replies

8. Shell Programming and Scripting

Need help with awk - how to read a content of a file from every file from file list

Hi Experts. I need to list the file and the filename comes from the file ListOfFile.txt. Basicly I have a filename "ListOfFile.txt" and it contain Example of ListOfFile.txt /home/Dave/Program/Tran1.P /home/Dave/Program/Tran2.P /home/Dave/Program/Tran3.P /home/Dave/Program/Tran4.P... (7 Replies)
Discussion started by: tanit
7 Replies

9. Shell Programming and Scripting

How to re-read a file in AWK

Hi , i am having some problem with re-reading the same file in AWK. here is the scenario. function 1 { some_string > " file1 " # i have redirected output to file1. ........... ........ } Now in function 2 { ... (1 Reply)
Discussion started by: madhaviece
1 Replies

10. Shell Programming and Scripting

Help with awk - read from file

Hi, I've got a file like the following: Starting to process segment 0 (and symmetry related segments) Number of (cancelled) singularities: 0 Number of (cancelled) negative numerators: 0 Segment 0: 5.49secs Starting to process segment 1 (and symmetry related segments) Number of... (7 Replies)
Discussion started by: giorgos193
7 Replies
Login or Register to Ask a Question