Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Help in unix in awk

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Help in unix in awk
# 1  
Old 06-29-2010
Help in unix in awk
Hi,

I have a file as given below
Code:
$cat int_check
239|adf123@yahoo.com|999e
23e|get@rediff.com|987
233|get@rediff.com|987

I am running the command as given to find whether field 1 and 3 have proper integer values or not.
Code:
awk -F'|' 'int($1)!=$1 || int($3)!=$3' int_check
239|adf123@yahoo.com|999e
23e|get@rediff.com|987

I am getting the right output but can i get the output in this format.
Error in field 1 or 3|239|adf123@yahoo.com|999e
Error in field 1 or 3|23e|get@rediff.com|987
# 2  
Old 06-29-2010
Code:
awk -F'|' 'int($1)!=$1 || int($3)!=$3{printf "Error in field 1 or 3|"$0"\n"}' int_check

# 3  
Old 06-29-2010
Hey bartus,
Thanks a lot. It worked. You missed the }.
I used this and it worked.
Code:
awk -F'|' 'int($1)!=$1 || int($3)!=$3{printf "Error in field 1 or 3|"$0"\n"}' int_check

# 4  
Old 06-29-2010
Quote:
Originally Posted by ashwin3086
Hey bartus,
Thanks a lot. It worked. You missed the }.
I used this and it worked.
Code:
awk -F'|' 'int($1)!=$1 || int($3)!=$3{printf "Error in field 1 or 3|"$0"\n"}' int_check

Yea, I fixed it quite quickly, but I guess not quickly enough Smilie
# 5  
Old 06-29-2010
Hi ,

I am facing as issue in substituting the variable here.

I am assigning value to a variable as given
Code:
format=`echo "{printf \"Error in field 1 or 3|\"\$0\"\\n\"}"`

=> format will have {printf "Error in field 1 or 3|"$0"\n"}
Now i want to echo it (format variable) as it is in script meaning i dont want $0 value to be substituted.
How can i achieve this??
# 6  
Old 06-29-2010
Code:
format='{printf "Error in field 1 or 3|"$0"\n"}'

# 7  
Old 06-29-2010
Hi ,

When i run the command
Code:
format='{printf "Error in field 1 or 3|"$0"\n"}' 
echo "format is $format"

I am getting the result as
Code:
Format is {printf "Error in field 1 or 3|"$0"
"}

It is not printing \n as it is.It is going to new line.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. How to Post in the The UNIX and Linux Forums

Help me in awk or sed in UNIX

I have a fixed length file that looks like a@ a00 a00000 a00 a000000 a00 a0000 a0000 a00000000 a01 a@ a1 a2 a11 a22 a12 a13 a44 a45 a54 a65 a76 a77 a@ a1 a3 a6 a7 a9 a8 a2 a7 a8 a8 a9 a0 b@ b00 b00000 b00... (1 Reply)
Discussion started by: RJG
1 Replies

2. UNIX for Dummies Questions & Answers

UNIX inquiry for 'awk'

Hello Everyone, May I ask for your help regarding one of the UNIX command “awk”. So I executed a script and the output looks like this (see below): output.txt CONTRACTNAME ... (3 Replies)
Discussion started by: steven_huskie
3 Replies

3. AIX

awk UNIX

friends because I get this error when calling awk awk: 0602-546 Can not find or open file estdistica.awk. (10 Replies)
Discussion started by: tricampeon81
10 Replies

4. UNIX for Advanced & Expert Users

awk sub command in Unix

Hi, I am new to unix shell script and I have some trouble on the awk sub I would like to pick the Date "July 10 2012" into $corr_date by using sub() function, but it is not successful. The inputted text file: pic.*.txt July 10 2012 20:30:50 , 1234567.jpg July 10 2012 20:30:52 , 5648978.jpg... (1 Reply)
Discussion started by: meroko
1 Replies

5. UNIX for Dummies Questions & Answers

AWK Help (New to UNIX)

Write a script to calculate the average score and assign a letter grade for each student, also compute the average score for every test (the source data is in the file “grades”). Output all students' name, scores, and grades in descending order of the average score. Note: please save the output to... (17 Replies)
Discussion started by: dsptl
17 Replies

6. Shell Programming and Scripting

need help with UNIX and awk

Hi, I am working on a script where i am fetching a word from a parameter file and using it as output file name . here is the part of parameter file contents : it basically contains SQL statements. Select 'SSFNRTP' as TABLE_NAME,UCSTDT,CVOFIDKEY from (Select 'cofvof_interface' as... (2 Replies)
Discussion started by: manmeet
2 Replies

7. UNIX for Dummies Questions & Answers

Clock in Unix using awk

Hey everyone! Can someone help me, i need to make a program using awk, that displays the current time (hh/mm/ss), i would really apreciate it! Thanks! Alex. (4 Replies)
Discussion started by: alex_omul
4 Replies

8. Shell Programming and Scripting

unix awk scripting

Hi can anyone pls help me out in knowing how a array of elements which are fetched from database is passed to the awk program. Something like this #!/bin/sh AMT=`sqlplus -s usrname/pswd <<EOD set pagesize 0 feedback off verify off heading off echo on select amount from... (11 Replies)
Discussion started by: shaik
11 Replies

9. UNIX for Dummies Questions & Answers

UNIX awk help

I am new to UNIX and I need a sample awk or sed program to solve the following problem. I have a file with the following format. The file is comma delimited. Each record has header information followed by looping detailed information. In addition the detailed information will vary based on a... (2 Replies)
Discussion started by: royayala
2 Replies

10. Shell Programming and Scripting

Unix To Awk

How do I alias the FILE name into awk? gawk -f awk_script FILE or FILE | gawk awk_script for FILE in `find ./* -prune -type f -newer ./TIMEFILE` do # Need to have the actual FILE name ran thru an awk script done (1 Reply)
Discussion started by: goodmis
1 Replies
Login or Register to Ask a Question