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"
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:
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.
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.
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
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)
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)
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)
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)
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)
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)
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)
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)