|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
using awk to strip out decimal point and trailing integers
Post 302606468 by jimbob01 on Sunday 11th of March 2012 04:02:04 PM
03-11-2012
Hi Guys,
Thanks for the help Dave.
vgersh99 - thanks!!! That worked a treat, exactly what I was after.
Thanx
Jim
Thanks for the help Dave.
vgersh99 - thanks!!! That worked a treat, exactly what I was after.
Thanx
Jim
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am trying to strip all leading and trailing spaces of a shell variable using either awk or sed or any other utility, however unscuccessful and need your help.
echo $SH_VAR | command_line Syntax.
The SH_VAR contains embedded spaces which needs to be preserved. I need only for the leading and... (6 Replies)
Discussion started by: jerardfjay
6 Replies
2. Shell Programming and Scripting
Hi,
I have input with decimal point ( 9.99 ) for hours variable hrs.
I need to change it to seconds.
Here is my code:
secs=`/usr/ucb/echo $hrs*3600 |bc`
But I don't want to see the decimal point.
I can use awk to trim it if there is one.
I am just wondering if there is better standard... (2 Replies)
Discussion started by: cin2000
2 Replies
3. Shell Programming and Scripting
Hi all. Using /bin/sh on an HPUX system.
I want to place a decimal in the field 2 charactors from the right (yes, converting to currency). The field lengths are variable. Here's what I'm doing:
exec < filename
while read FIELD1 FIELD2
do
FIELD1="echo $FIELD1 | sed 'syntax that will... (4 Replies)
Discussion started by: lyoncc
4 Replies
4. Shell Programming and Scripting
How to compare two numbers with decimal points ?
Is there a way in bash to do this? (33 Replies)
Discussion started by: kinny
33 Replies
5. Shell Programming and Scripting
Hi
In Unix, I have a file with some numbers like :
45600
12345
I want to insert a decimal point for these numbers based on user input.
If the input is 2, the numbers should be changed to
456.00
123.45
If the input is 3, the numbers should be changed to
45.600
12.345
Can... (2 Replies)
Discussion started by: yoursdivu
2 Replies
6. Shell Programming and Scripting
Hi everyone,
I am new here and generally not experienced with linux. My question must be easy, but as for now I have no idea how to do it.
I have lots of directories with numerical names, e.g. 50 50.1 50.12 etc. What I want is to leave directories with no or single digit after the decimal... (2 Replies)
Discussion started by: cabaciucia
2 Replies
7. Shell Programming and Scripting
Hi All,
Can some one help me in identifying the significance of character "$" ,Which is playing critical role in matching decimal point numbers as below.
$ echo "01#.01"|awk '{if ($0 ~ /^+(\.*)?$/) print}'
$ echo "01#.01"|awk '{if ($0 ~ /^+(\.*)?/) print}'
01#.01
$
Regards,
Rmkganesh. (3 Replies)
Discussion started by: rmkganesh
3 Replies
8. Shell Programming and Scripting
I have test.dat file with values given below:
20150202,abc,,,,3625.300000,,,,,-5,,,,,,,,,,,,,,,,,,,,,,
20150202,def,,,,32.585,,,,,0,,,,,,,,,,,,,,,,,,,,,,
20150202,xyz,,,,12,,,,,0.004167,,,,,,,,,,,,,,,,,,,,,,
My expected output is shown below:
... (1 Reply)
Discussion started by: nvk_vinoth
1 Replies
9. UNIX for Beginners Questions & Answers
hi there I being trying to figure out way to add " .0" to an integer value in a csv using sed or awk with out success. just as a work around for 2147483647 32 bit limitation that influxdb is currently having
the data base will accept values and work fine if it has the XXX.0 ... (7 Replies)
Discussion started by: sash99
7 Replies
10. UNIX for Advanced & Expert Users
Hi , I have a file which contains text like
A|Mau|Code|12|Detail
B|Mau|Code|20|Header
I want to write a command using awk which will output
A|Mau|Code|12.00|Detail
B|Mau|Code|20.00|Header
I used a command like awk -F"|" {printf "%s|%s|%s|%.2f|%s",$1,$2,$3,$4,$5}' which does the... (4 Replies)
Discussion started by: LoneRanger
4 Replies
LEARN ABOUT OSX
datetime::locale::om
DateTime::Locale::om(3) User Contributed Perl Documentation DateTime::Locale::om(3) NAME
DateTime::Locale::om SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'om' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Oromo. DATA
This locale inherits from the DateTime::Locale::root locale. It contains the following data. Days Wide (format) Wiixata Qibxata Roobii Kamiisa Jimaata Sanbata Dilbata Abbreviated (format) Wix Qib Rob Kam Jim San Dil Narrow (format) M T W T F S S Wide (stand-alone) Wiixata Qibxata Roobii Kamiisa Jimaata Sanbata Dilbata Abbreviated (stand-alone) Wix Qib Rob Kam Jim San Dil Narrow (stand-alone) M T W T F S S Months Wide (format) Amajjii Guraandhala Bitooteessa Elba Caamsa Waxabajjii Adooleessa Hagayya Fuulbana Onkololeessa Sadaasa Muddee Abbreviated (format) Ama Gur Bit Elb Cam Wax Ado Hag Ful Onk Sad Mud Narrow (format) J F M A M J J A S O N D Wide (stand-alone) Amajjii Guraandhala Bitooteessa Elba Caamsa Waxabajjii Adooleessa Hagayya Fuulbana Onkololeessa Sadaasa Muddee Abbreviated (stand-alone) Ama Gur Bit Elb Cam Wax Ado Hag Ful Onk Sad Mud Narrow (stand-alone) J F M A M J J A S O N D Quarters Wide (format) Q1 Q2 Q3 Q4 Abbreviated (format) Q1 Q2 Q3 Q4 Narrow (format) 1 2 3 4 Wide (stand-alone) Q1 Q2 Q3 Q4 Abbreviated (stand-alone) Q1 Q2 Q3 Q4 Narrow (stand-alone) 1 2 3 4 Eras Wide BCE CE Abbreviated KD KB Narrow KD KB Date Formats Full 2008-02-05T18:30:30 = Qibxata, Guraandhala 5, 2008 1995-12-22T09:05:02 = Jimaata, Muddee 22, 1995 -0010-09-15T04:44:23 = Sanbata, Fuulbana 15, -10 Long 2008-02-05T18:30:30 = 05 Guraandhala 2008 1995-12-22T09:05:02 = 22 Muddee 1995 -0010-09-15T04:44:23 = 15 Fuulbana -10 Medium 2008-02-05T18:30:30 = 05-Gur-2008 1995-12-22T09:05:02 = 22-Mud-1995 -0010-09-15T04:44:23 = 15-Ful--10 Short 2008-02-05T18:30:30 = 05/02/08 1995-12-22T09:05:02 = 22/12/95 -0010-09-15T04:44:23 = 15/09/-10 Default 2008-02-05T18:30:30 = 05-Gur-2008 1995-12-22T09:05:02 = 22-Mud-1995 -0010-09-15T04:44:23 = 15-Ful--10 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 WB UTC 1995-12-22T09:05:02 = 9:05:02 WD UTC -0010-09-15T04:44:23 = 4:44:23 WD UTC Long 2008-02-05T18:30:30 = 6:30:30 WB UTC 1995-12-22T09:05:02 = 9:05:02 WD UTC -0010-09-15T04:44:23 = 4:44:23 WD UTC Medium 2008-02-05T18:30:30 = 6:30:30 WB 1995-12-22T09:05:02 = 9:05:02 WD -0010-09-15T04:44:23 = 4:44:23 WD Short 2008-02-05T18:30:30 = 6:30 WB 1995-12-22T09:05:02 = 9:05 WD -0010-09-15T04:44:23 = 4:44 WD Default 2008-02-05T18:30:30 = 6:30:30 WB 1995-12-22T09:05:02 = 9:05:02 WD -0010-09-15T04:44:23 = 4:44:23 WD Datetime Formats Full 2008-02-05T18:30:30 = Qibxata, Guraandhala 5, 2008 6:30:30 WB UTC 1995-12-22T09:05:02 = Jimaata, Muddee 22, 1995 9:05:02 WD UTC -0010-09-15T04:44:23 = Sanbata, Fuulbana 15, -10 4:44:23 WD UTC Long 2008-02-05T18:30:30 = 05 Guraandhala 2008 6:30:30 WB UTC 1995-12-22T09:05:02 = 22 Muddee 1995 9:05:02 WD UTC -0010-09-15T04:44:23 = 15 Fuulbana -10 4:44:23 WD UTC Medium 2008-02-05T18:30:30 = 05-Gur-2008 6:30:30 WB 1995-12-22T09:05:02 = 22-Mud-1995 9:05:02 WD -0010-09-15T04:44:23 = 15-Ful--10 4:44:23 WD Short 2008-02-05T18:30:30 = 05/02/08 6:30 WB 1995-12-22T09:05:02 = 22/12/95 9:05 WD -0010-09-15T04:44:23 = 15/09/-10 4:44 WD Default 2008-02-05T18:30:30 = 05-Gur-2008 6:30:30 WB 1995-12-22T09:05:02 = 22-Mud-1995 9:05:02 WD -0010-09-15T04:44:23 = 15-Ful--10 4:44:23 WD Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 Qib 1995-12-22T09:05:02 = 22 Jim -0010-09-15T04:44:23 = 15 San Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 WB 1995-12-22T09:05:02 = 9:05 WD -0010-09-15T04:44:23 = 4:44 WD Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 WB 1995-12-22T09:05:02 = 9:05:02 WD -0010-09-15T04:44:23 = 4:44:23 WD M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (M-d) 2008-02-05T18:30:30 = 2-5 1995-12-22T09:05:02 = 12-22 -0010-09-15T04:44:23 = 9-15 MEd (E, M-d) 2008-02-05T18:30:30 = Qib, 2-5 1995-12-22T09:05:02 = Jim, 12-22 -0010-09-15T04:44:23 = San, 9-15 MMdd (dd/MM) 2008-02-05T18:30:30 = 05/02 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/09 MMM (LLL) 2008-02-05T18:30:30 = Gur 1995-12-22T09:05:02 = Mud -0010-09-15T04:44:23 = Ful MMMd (MMM d) 2008-02-05T18:30:30 = Gur 5 1995-12-22T09:05:02 = Mud 22 -0010-09-15T04:44:23 = Ful 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = Qib Gur 5 1995-12-22T09:05:02 = Jim Mud 22 -0010-09-15T04:44:23 = San Ful 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = Guraandhala 5 1995-12-22T09:05:02 = Muddee 22 -0010-09-15T04:44:23 = Fuulbana 15 MMMMdd (dd MMMM) 2008-02-05T18:30:30 = 05 Guraandhala 1995-12-22T09:05:02 = 22 Muddee -0010-09-15T04:44:23 = 15 Fuulbana MMMMEd (E MMMM d) 2008-02-05T18:30:30 = Qib Guraandhala 5 1995-12-22T09:05:02 = Jim Muddee 22 -0010-09-15T04:44:23 = San Fuulbana 15 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = Qib, 2008-2-5 1995-12-22T09:05:02 = Jim, 1995-12-22 -0010-09-15T04:44:23 = San, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 Gur 1995-12-22T09:05:02 = 1995 Mud -0010-09-15T04:44:23 = -10 Ful yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = Qib, 2008 Gur 5 1995-12-22T09:05:02 = Jim, 1995 Mud 22 -0010-09-15T04:44:23 = San, -10 Ful 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 Guraandhala 1995-12-22T09:05:02 = 1995 Muddee -0010-09-15T04:44:23 = -10 Fuulbana yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 Q1 1995-12-22T09:05:02 = 1995 Q4 -0010-09-15T04:44:23 = -10 Q3 yyMM (MM/yy) 2008-02-05T18:30:30 = 02/08 1995-12-22T09:05:02 = 12/95 -0010-09-15T04:44:23 = 09/-10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 yyyyMMMM (MMMM y) 2008-02-05T18:30:30 = Guraandhala 2008 1995-12-22T09:05:02 = Muddee 1995 -0010-09-15T04:44:23 = Fuulbana -10 Miscellaneous Prefers 24 hour time? No Local first day of the week Wiixata SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.16.2 2013-08-25 DateTime::Locale::om(3)