04-06-2009
What you have looks fine, just replace the bc line with this:
X=`echo "scale=1;$X / 60/ 60" | bc` # Convert seconds to hours, with 1 decimal.
The "scale" variable defines your precision. It's documented in the "bc" man page. :-)
I've added my version of your program above:
#! /bin/bash
cat data | sed 's/,//g' |
while read a b c
do
x=$(echo "scale=1;$a/60/60" | bc)
echo "$x hrs, $b $c"
done
And this was done without the need of calling awk; of course I called "sed" and "bc". but I think you get the idea.
Last edited by sandholm; 04-06-2009 at 09:47 PM..
Reason: further example
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i have this script that searches for a pattern.
However it fails if the pattern includes some
special characters. So far, it fails with the
following strings:
1. -Cr
2. $Mj
3. H'412
would a sed or awk be more effective?
i don't want the users to put the (\)
during the search (they... (5 Replies)
Discussion started by: apalex
5 Replies
2. Shell Programming and Scripting
Hi. Does anyone know how to use the sed command to change the special border characters on this .per file. I have to edit about 80 .per files. I need a sed script to change the below 3 and A characters.
ÚÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄÄ¿
³ Test Islands, Office of Public Health -- WIC... (4 Replies)
Discussion started by: cstovall
4 Replies
3. Shell Programming and Scripting
I started with this:
counter1=1
cp file.txt file_${counter1}.tmp
while read name1
do
echo $name1
counter2=`expr $counter1 + 1`
sed /'${name1}'/d file_${counter1}.txt > file_${counter2}.txt
counter1=`expr $counter1 + 1`
done < source.txtsource.txt contains the... (1 Reply)
Discussion started by: lakanino
1 Replies
4. Shell Programming and Scripting
Hi everyone
I have file1 contains:
'7832'
' 8765
6543
I want a sed command that will format as:
'7832' , '8765' , '6543'
I tried
sed -e s/\'//g -e 's/^*//;s/*$//' file1 > file2
sed -e :a -e '$!N; s/\n/ /; ta' file2
which gives: 7832 8765 6543
I need some help to continue with... (5 Replies)
Discussion started by: nimo
5 Replies
5. Shell Programming and Scripting
Hello All
Seeking the right one SED command.
My attempt is:
From orginal.txt by SED to target.txt
sed -i "/('outbound-callerid/a\$ext->add($context, $exten, '', new ext_SipAddHeader('P-Preferred-Identity', '<sip:${CALLERID(nummer)}@carrier.com>'));" orginal.txtWhat am make wrong?:wall:
... (5 Replies)
Discussion started by: mdbinder
5 Replies
6. Shell Programming and Scripting
Need help in escaping special characters in sed command.
Here is the the string which i am trying to find a replace with
From :- REQUEST_TYPE=PIXEL&MSG_ID={//MESSAGE_ID}
To :- REQUEST_TYPE=PIXEL&MSG_ID= X_EDELIVERY_MESSAGE_ID & BATCH_ID= X_EDELIVERY_BATCH_ID
Here is the sed command i am... (2 Replies)
Discussion started by: aakishore
2 Replies
7. Shell Programming and Scripting
Hi I'm trying to replace string1 by string2 in file homepage.htm as follows but is not working. Please Help:
sedsed -i "s@'://your server name:port/test/owa'@'://11.22.33.44:5555/pls/SAMPLE'@g" homepage.htm
Where,
String1 ://your server name:port/test/owa
String2... (3 Replies)
Discussion started by: koazter
3 Replies
8. Shell Programming and Scripting
Hi,
I have a file with this line, it's always in the first line:
I want to remove these special characters: ´╗┐
file1
´╗┐\\bar\c$\test2\;3.348.118 Bytes;160 ;3
\\bar\c$\test\;35 Bytes;2 ;1
I want the same file to be only
\\bar\c$\test2\;3.348.118 Bytes;160 ;3
\\bar\c$\test\;35... (4 Replies)
Discussion started by: nakaedu
4 Replies
9. Shell Programming and Scripting
I am dusting off the sed cobwebs and had a basic question:
I have a file that contains:
$firewall = "on";
$cache = "on";
$dataset{'mary had a little lamb'} = "on";
and want to only change the contents of what is between the single quotes:
$dataset{'big bad wolf'} = "on";
I... (3 Replies)
Discussion started by: metallica1973
3 Replies
10. Shell Programming and Scripting
I have the foolowing data file:
File1
<p name="A">5004</p>
<p name="B">5004</p>
<p name="C">5004</p>
<p name="A">15004</p>
<p name="B">15004</p>
<p name="C">15004</p>
In a while loop using sed (100 of line need to be replace), I need the output to File3:... (2 Replies)
Discussion started by: bobo
2 Replies
LEARN ABOUT PHP
oci_field_precision
OCI_FIELD_PRECISION(3) OCI_FIELD_PRECISION(3)
oci_field_precision - Tell the precision of a field
SYNOPSIS
int oci_field_precision (resource $statement, mixed $field)
DESCRIPTION
Returns precision of the $field.
For FLOAT columns, precision is nonzero and scale is -127. If precision is 0, then column is NUMBER. Else it's NUMBER(precision, scale).
PARAMETERS
o $statement
- A valid OCI statement identifier.
o $field
- Can be the field's index (1-based) or name.
RETURN VALUES
Returns the precision as an integer, or FALSE on errors.
EXAMPLES
Example #1
oci_field_precision(3) Example
<?php
// Create the table with:
// CREATE TABLE mytab (c1 NUMBER, c2 FLOAT, c3 NUMBER(4), c4 NUMBER(5,3));
$conn = oci_connect("hr", "hrpwd", "localhost/XE");
if (!$conn) {
$m = oci_error();
trigger_error(htmlentities($m['message']), E_USER_ERROR);
}
$stid = oci_parse($conn, "SELECT * FROM mytab");
oci_execute($stid, OCI_DESCRIBE_ONLY); // Use OCI_DESCRIBE_ONLY if not fetching rows
$ncols = oci_num_fields($stid);
for ($i = 1; $i <= $ncols; $i++) {
echo oci_field_name($stid, $i) . " "
. oci_field_precision($stid, $i) . " "
. oci_field_scale($stid, $i) . "<br>
";
}
// Outputs:
// C1 0 -127
// C2 126 -127
// C3 4 0
// C4 5 3
oci_free_statement($stid);
oci_close($conn);
?>
NOTES
Note
In PHP versions before 5.0.0 you must use ocicolumnprecision(3) instead. This name still can be used, it was left as alias of
oci_field_precision(3) for downwards compatability. This, however, is deprecated and not recommended.
SEE ALSO
oci_field_scale(3), oci_field_type(3).
PHP Documentation Group OCI_FIELD_PRECISION(3)