05-09-2008
Hi
I am not able to delete trailing zero's using awk.
e1.dat
======
2008-04-30|16|N|U|||||U|||+000000000000000000000000000.0000|+00000000000000000000.00000000000
2008-04-30||16|N|U|||||U|||+000000000000000000000000000.0000|+00000000000000000000.00000000000
cat e1.dat |awk -F "|" ' sub("\\.*0+$","") '
Thanks in advance
MR
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
How do I remove or add leading zeroa from a variable. To make variable 10 characters long when adding zeros. (6 Replies)
Discussion started by: toshidas2000
6 Replies
2. Shell Programming and Scripting
I have a string "disk0 with a trailing white space after it" but I want to get rid of this white space from right to left so that I am left with "disk0" only.
Using sed 's/ $//g' doesn't seem to work
Any ideas ?
Thanks (5 Replies)
Discussion started by: cillmor
5 Replies
3. Shell Programming and Scripting
Hello-
I have a variable which contains a number, I need to populate number of zeros before another value as per this variable value.
for example:
I have variable X whose content is 5, variable Y whose content is 123
Now append number of zeros as per variable X before varible 'Y'... (4 Replies)
Discussion started by: pasupuleti81
4 Replies
4. Shell Programming and Scripting
Hello All,
I have a csv file with 3 columns. The file which looks like this
47850000,100,233
23560000,10000,456
78650000,560000,54
34000000,3456,3
The first column has 4 trailing zeros. I have to remove 4 trailing zeroes from 1st field. The output file should appear as follows.
... (12 Replies)
Discussion started by: grajp002
12 Replies
5. Shell Programming and Scripting
How to delete ending/trailing spaces using awk,sed,perl?
Input:(each line has extra spaces at the end)
3456 565
3 7
35 878
Expected output:
3456 565
3 7
35 878 (5 Replies)
Discussion started by: cola
5 Replies
6. Shell Programming and Scripting
Hi,
I have a input string 0000106 I need to extract the number after leading zeros ie the number 106. I used the command tr -d "0" and got the output as 16. Could any one of you please help me in using the tr command to get the output 106. Thanks in advance.... (2 Replies)
Discussion started by: dean_amrita
2 Replies
7. UNIX for Dummies Questions & Answers
Hi All.
How can I convert this:
ABC_1_1
ABC_1_2
ABC_1_3
into this:
ABC_1 1
ABC_1 2
ABC_1 3
I tried this command but it is not working:
awk '{sub(/+$/,"\t", $1)}{print}'
Any suggestions on how to fix this?
Thank you :wall:
Please use code tags when posting data and... (3 Replies)
Discussion started by: danieladna
3 Replies
8. Shell Programming and Scripting
Hi I have a simple request but can't find the answer. I want to remove trailing zeros, and in some cases the fullstops, from the input data. Example of input file:
FR002_15.000_20.000
SD475_5.000_10.500
FG5647_12.250_15.500
BH2463_30.555_32.000
Desired output file would be:
... (10 Replies)
Discussion started by: theflamingmoe
10 Replies
9. UNIX for Beginners Questions & Answers
Hi,
I am trying to remove trailing zeros from numbers in a csv file.
CSV Input : 0.5000,abc,2.00,2.400,285.850,285a.850,205.180800,mno000,a0b0,2.860
Expected Output :
.5,abc,2,2.4,285.85,285a.850,205.1808,mno000,a0b0,2.86
Can you please help.
Thanks. (11 Replies)
Discussion started by: manubatham20
11 Replies
10. Shell Programming and Scripting
shell : bash
os : RHEL 7.2
I have a file like below
61265388
1-11Y5C-7690
1-11Y4Q-6763
INSERT INTO emp VALUES('oramds:test.xref','CBS_01','MIGWO161265388','61265388','N',SYSDATE);
INSERT INTO emp VALUES('oramds:test.xref','COMMON','MIGWO161265388','MIG1COMMON61265388','N',SYSDATE);... (3 Replies)
Discussion started by: kraljic
3 Replies
UPSC(8) Network UPS Tools (NUT) UPSC(8)
NAME
upsc - example lightweight UPS client
SYNOPSIS
upsc ups [variable]
DESCRIPTION
upsc is provided as a quick way to poll the status of a UPS server. It can be used inside shell scripts and other programs that need UPS
data but don't want to include the full interface.
OPTIONS
ups Display the status of that UPS. The format for this option is [upsname@]hostname[:port].
For example, "myups@mybox:1234" would poll a UPS called "myups" on a host called "mybox", with upsd(8) running on port 1234.
Using an argument like "anotherbox" polls the first configured UPS on the host "anotherbox", on the default port that was compiled
into the software, typically 3493.
variable
Display the value of this variable only. By default, upsc retrieves the list of variables from the server and then displays the
value for each. This may be useful in shell scripts to save an additional pipe into grep.
DIAGNOSTICS
upsc will either print a list of all supported variables and their values on the UPS or an error message. If you receive an error, make
sure you have specified a valid UPS on the command line, that upsd(8) is really running on the other host and that no firewalls are block-
ing you.
HISTORY
Earlier versions of this program used the upsfetch library and UDP sockets to talk to upsd. This version of upsc uses the new upsclient
library, which only talks TCP. This is why upsct no longer exists.
SEE ALSO
upsd(8)
Internet resources:
The NUT (Network UPS Tools) home page: http://www.exploits.org/nut/
NUT mailing list archives and information: http://lists.exploits.org/
Wed Oct 16 2002 UPSC(8)