Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

awk Error

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk Error
# 1  
Old 02-04-2013
awk Error
Hi

I am trying to create a file with count of lines and string from shell variable, i am getting the error incorrect syntax.

Below is the code :

Code:
wc -l $filename | awk '{ print $1"|"$2"|"${SOURCETYPE} }'>>$AUDITFILENAME

Could someone help me on this?
# 2  
Old 02-04-2013
Code:
wc -l "$filename" | awk -v S="$SOURCETYPE" '{ print $1"|"$2"|"S }' >> "$AUDITFILENAME"

# 3  
Old 02-04-2013
A long shot in the dark:
Code:
wc -l "$filename" | 
  awk '{ print $1, $2, ENVIRON["SOURCETYPE"] }' OFS=\| >> "$AUDITFILENAME"

If the code above doesn't work as expected, please post the exact command and complete output/error that you're getting.

The special builtin array ENVIRON may not be available in your awk implementation.
It contains only exported variables, it that's not your case, use bipinajith's solution
# 4  
Old 02-04-2013
This is in the spirit of what you tried. It should work:
Code:
wc -l $filename | awk '{ print $1"|"$2"|"'${SOURCETYPE}' }'>>$AUDITFILENAME

# 5  
Old 02-04-2013
Thanks dexdex200,

It got executed but it hasn't create the file as expected, it didn't take any value from the shell variable. I ran teh script with sex-x, so below is the one executed on.
Actual Code: wc -l $filename | awk '{ print $1"|"$2"|"'$SOURCETYPE' }'>>$AUDITFILENAME

Code:
+ awk { print $1"|"$2"|"SOURCE }
+ wc -l INPUTFILE_20130131070015560.LOG
+ 1>> SOURCE_AUDIT_FILE.TXT

Output:

41|INPUTFILE_20130129073044447.LOG|
Actual Output: 41|INPUTFILE_20130129073044447.LOG|SOURCE

Thanks
# 6  
Old 02-04-2013
This should do it then:
Code:
wc -l $filename | awk '{ print $1"|"$2"|'${SOURCETYPE}'" }'

Bipinajith's code is neater though
# 7  
Old 02-04-2013
BTW you can get rid of wc -l and do that part in awk itself:
Code:
awk -v S="$SOURCETYPE" 'END{ print NR,FILENAME,S; }' OFS=\| "$filename" >> "$AUDITFILENAME"
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Error in awk...

Hi friends... (Apoloigies for any typos.) (Don, thanks for your input.) Consider these two code snippets:- awkerror1.awk #!/usr/bin/awk -f BEGIN \ { SAWTOOTHPLUS64 = " !#$&\'\)*,-/0235689:<>?ABDEGHJKMNPQSTVWYZ\\^_abdeghjkmnpqstvwyz|}~" for(LOOP = 1; LOOP <= 13; ++LOOP) {... (3 Replies)
Discussion started by: wisecracker
3 Replies

2. UNIX for Dummies Questions & Answers

No error in awk...

Hi all... In the OSX forum I am starting a new awk project to learn awk. In this code snippet I have had to check boundaries to ensure that no NUMERICAL error occurs in the rest of the code... printf "Enter frequency required:- "; getline FREQ; RATE=(BYTES*FREQ); if ( RATE <= 4000 ) {... (4 Replies)
Discussion started by: wisecracker
4 Replies

3. Shell Programming and Scripting

awk output yields error: awk:can't open job_name (Autosys)

Good evening, Im newbie at unix specially with awk From an scheduler program called Autosys i want to extract some data reading an inputfile that comprises jobs names, then formating the output to columns for example 1. This is the inputfile: $ more MapaRep.txt ds_extra_nikira_usuarios... (18 Replies)
Discussion started by: alexcol
18 Replies

4. Shell Programming and Scripting

Error with awk

i have been trying to run the following bash script, but get error: awk: cmd. line:1: - awk: cmd. line:1: ^ unexpected newline or end of string I have been trying to figure out what the problem is but to no avail. I need to run the script urgently for a project, so any help will be highly... (5 Replies)
Discussion started by: anti_antaeus
5 Replies

5. Shell Programming and Scripting

awk command in script gives error while same awk command at prompt runs fine: Why?

Hello all, Here is what my bash script does: sums number columns, saves the tot in new column, outputs if tot >= threshold val: > cat getnon0file.sh #!/bin/bash this="getnon0file.sh" USAGE=$this" InFile="xyz.38" Min="0.05" # awk '{sum=0; for(n=2; n<=NF; n++){sum+=$n};... (4 Replies)
Discussion started by: catalys
4 Replies

6. Shell Programming and Scripting

AWK error

This is my disk space on solaris box and i wrote a simple script which identifies mount points which crosses 90% or above. But the AWK part is throwing some error and im unable to debug.. mzaheer @ UAT 144 % => df -k Filesystem kbytes used avail capacity Mounted on... (5 Replies)
Discussion started by: user__user3110
5 Replies

7. Shell Programming and Scripting

Awk error -- awk: 0602-562 Field $() is not correct.

typeset -i i=1 while read -r filename; do Splitfile=`$Targetfile_$i.txt` awk 'substr($0,1,5) == substr($filename,1,5) && substr($0,526,2) == substr($filename,6,2) && substr($0,750,12) == substr($filename,8,12)' $SourceFilename >> $Splitfile i=i+1 done < /tmp/list.out I am using this logic... (1 Reply)
Discussion started by: pukars4u
1 Replies

8. UNIX for Dummies Questions & Answers

awk error

Hi all, i have the files in the below sequence: fancy_LANG_STD_AU_2008-03-05.dat fancy_LANG_STD_HK_2008-03-06.dat fancy_LANG_STD_NZ_2008-03-05.dat fancy_STD_AU_2008-03-05.dat fancy_STD_HK_2008-03-06.dat fancy_STD_NZ_2008-03-05.dat i am trying to sort them like below: ... (3 Replies)
Discussion started by: gyankr
3 Replies

9. UNIX for Dummies Questions & Answers

awk Shell Script error : "Syntax Error : `Split' unexpected

hi there i write one awk script file in shell programing the code is related to dd/mm/yy to month, day year format but i get an error please can anybody help me out in this problem ?????? i give my code here including error awk ` # date-month -- convert mm/dd/yy to month day,... (2 Replies)
Discussion started by: Herry
2 Replies

10. Shell Programming and Scripting

Error in awk

var1=`echo "emp,dept,salgrade" | awk -F, '{print NF}'` count=1 while ; do i=`expr $count` tname=`echo "emp,dept,salgrade" | awk -F, '{ print $(echo $i) }'` count=$count+1; echo ${tname}; echo $count done I want to store in tname=emp, tname=dept,tname=salgrade I am getting... (2 Replies)
Discussion started by: dreams5617
2 Replies
Login or Register to Ask a Question