How to suppress error in following command?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to suppress error in following command?
# 8  
Old 09-30-2013
You may want to set the OFMT (output format; default "6.2f") variable to a more suitable value.
If you try MadeInGermany's proposal, use printf, not print.

EDIT: wrong default from the top of my head. Correct: "%.6g"

Last edited by RudiC; 09-30-2013 at 03:18 PM..
This User Gave Thanks to RudiC For This Post:
# 9  
Old 10-01-2013
Hi All,

Thank you all for your valuable input. Yes I managed to print the number correctly using the printf function. However, I got another issue with the command provided by RudiC.

I am applying the same command on another file in which record separator is not pipe. I change the command as below:

Code:
awk -F" " '/^040/ {REC++; SUM+=$14; FN=FILENAME} END {printf ("%s;%d;%0.2f\n", FN,REC,SUM/100)} ' $FILENAMEA

Using above I do not get the correct result. This is because field 14 is not being grepped correctly.

I tried following command also:

Code:
awk '{$1=$1}1' OFS="|" $FILENAMEA | awk -F" " '/^040/ {REC++; SUM+=$14; FN=FILENAME} END {printf ("%s;%d;%0.2f\n", FN,REC,SUM/100)} '

However, this did not work as filename is not being printed and the sum is also coming wrong.

Please advise.

Thanks
Angshuman
# 10  
Old 10-01-2013
Please post input files.
# 11  
Old 10-01-2013
Hi RudiC,

Please find the attached file.

Thanks
Angshuman
# 12  
Old 10-01-2013
What's wrong - $14 is 0 in both lines starting with 040, so the sum is 0 as well.
# 13  
Old 10-01-2013
Hi RudiC,

I am not sure with previous file. However, please refer to this attached file.

When I run both the following commands, I get two diff output.

Code:
awk -F" " '/^040/ {REC++; SUM+=$15; FN=FILENAME} END {printf ("%s;%d;%0.2f\n", FN,REC,SUM/100)} ' myfile.txt

output : myfile.txt;2;0.00


Code:
grep ^040 myfile.txt | cut -f14

Output:

1000
1000

These files are tab delimited. If you notice, you will see that some of the fields have text separated by space. Hence If I use space as delimiter, the output will not be consistent. When I use cut command to get field 14, I get consistent result across all files.

For example in the following line

Code:
040     40      0       0123683106      00389486375     80      RCCCFN  11      1380302611      02      03      MOBILE 012      0       40      0       NL02

MOBILE 012 is one field. If you check the second file that I have uploaded, you can see that this particular field can have text containing multiple spaces.

Thanks
Angshuman

Last edited by angshuman; 10-01-2013 at 09:29 PM..
# 14  
Old 10-02-2013
Hi RudiC,

I managed to get that working. As I said the delimiter is tab and hence I have changed the delimiter as below:

Code:
awk -F" " '/^040/.....  is changed to awk -F'\t'  '/^040/....

After that it is working fine. However, I got another question here.

Besides lines starting with 040, if I have to grep another line starting with say 600 and sum 18th column of that line but all the output should display in one line, do I need to perform it separately and then paste the output or is there anything that can be changed in the command above to get the required output.

Thanks
Angshuman

Last edited by angshuman; 10-02-2013 at 02:23 AM.. Reason: clarification
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Tcsh: How to suppress error messages.

Hallo, I wrote some script: 95% of the script's output consists of error messages like "mkdir: cannot create directory ‘final': File exists Exit 1" and "rm: No match. Exit 1". These messages are not harmful at all, but they make the output almost unreadable. How can I get rid of... (5 Replies)
Discussion started by: DanielDD
5 Replies

2. Shell Programming and Scripting

Suppress Error Message

How can I suppress a error message being given by awk command in bash shell? (2 Replies)
Discussion started by: Prachi Gupta
2 Replies

3. Shell Programming and Scripting

How to suppress the error while copying the file

HI , I am tryin to copying multiple files from some dir. If the files are not present. It should not throw error in the screen. HOw to do that . Please help (4 Replies)
Discussion started by: arukuku
4 Replies

4. HP-UX

glance adviser suppress newline in print command

Hi, I have a glance adviser, the highlights below. The problem that i have is that every time glance finds process name "abc" it write the memory region data in a new line. My question is if i have a way to print without newline? The output line for process abc looks something like this:... (0 Replies)
Discussion started by: yochaia01
0 Replies

5. Shell Programming and Scripting

how to suppress dd output?

I have to stop the output of dd from writing to terminal. Here is the command: sudo dd if=boot1h of="/dev/r$temp1" Here is the output: 2+0 records in 2+0 records out 1024 bytes transferred in 0.000804 secs (1273715 bytes/sec) I have tried >> log.txt but it doesn't work. Is there... (4 Replies)
Discussion started by: msf5042
4 Replies

6. Shell Programming and Scripting

how to suppress list number from history command output

i run history command and I want to eliminate the list number. So far this perl script works as long as the list is a exact 3 character long. cat dd | perl -pe 's,\d{3},,' 70 export JAVA_HOME=. 81 export JAVA_HOME=. 82 export JAVA_HOME=`pwd` export JAVA_HOME=`pwd` ... (1 Reply)
Discussion started by: soemac
1 Replies

7. Shell Programming and Scripting

Suppress error message in shell script

Hi All this is a simple script #! /bin/bash FileCnt=`ls -lrt $DIR/* | wc -l` echo $FileCnt how could i escape the error msg if there are no files in $DIR ls: /home/sayantan/test/files/cnt/*: No such file or directory 0 Looking forward for a quick reply Regards, Newbie... (3 Replies)
Discussion started by: newbie07
3 Replies

8. Shell Programming and Scripting

Suppress error message in unzip

I'm creating a bsh shell to unzip a file from one directory into another. The directory that holds the zip files has zip files constantly being added to it, so I am testing it before it does the unzip and more. Right now my code looks like this: unzip -tq $ZIP_PATH/$ZIP_NAME >/dev/null if ... (5 Replies)
Discussion started by: skwyer
5 Replies

9. Shell Programming and Scripting

How to suppress error messages in script

I am getting the following upon cat a file which is not present in directory. "cat: cannot open test1.txt" I need to process files and I want that this message should be suppressed. thx (5 Replies)
Discussion started by: helper2007
5 Replies
Login or Register to Ask a Question