06-16-2009
remove blank spaces from fields
Hi Friends,
I have large volume of data file as shown below.
Beganing or end of each filed, there are some blank spaces.
How do I remove those spaces?
AAA AAA1 | BBB BB1 BB2 |CC CCCC
DDDD DD | EEEEEEE EEEEEEEE | FFF FFFFFF FFFF
GG GGGGGG |HH HH |IIII IIIIIIIIIIII
The file should like as below.
AAA AAA1|BBB BB1 BB2|CC CCCC
DDDD DD|EEEEEEE EEEEEEEE|FFF FFFFFF FFFF
GG GGGGGG|HH HH|IIII IIIIIIIIIIII[/B]
Thanks for your help in advance.
Prashant
-----Post Update-----
I need to retain space between words.
-----Post Update-----
I need to retain space between words.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
can any help how to remove blank spaces in a string?
STR="GOOD BYE"
by removing blank spaces, the string should be GOOD,BYE
thanks in advance (2 Replies)
Discussion started by: spandu
2 Replies
2. Shell Programming and Scripting
Hey ,
I have a file and it's having spaces for some of the fields in it. Like the one below. I want to remove the spaces in them through out the file. The spaces occur randomly and i can't say which field is having space. So please help. Here is sample file with spaces after 5th field. (3 Replies)
Discussion started by: dsravan
3 Replies
3. UNIX for Dummies Questions & Answers
All...
I want to remove blank spaces in file . I just leraned that we can use
" cat <Input filename> | tr -s ‘ ‘ > <Target file name> "
i also know with SED we can replace a blank space by other character by
sed s/ /*/g filename.
Please let me know how can i do that by... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies
4. Shell Programming and Scripting
hello
how to remove blank spaces of a file with awk??
i´m trying
awk '{gsub(" ","",$0); print $0;}' filename.txt
but it answers
syntax error near line
first of all i did this for download from netbackup database jobs
privilege bpdbjobs -report -M sv88 -gdm -header |cut -c-1024... (4 Replies)
Discussion started by: pabloli150
4 Replies
5. Shell Programming and Scripting
Hi,
I have this problem that there are blank spaces in my text file... i want to remove them
line 1
line 2
line 3
I want to remove the space between line 2 and line 3... I tried sed... it work but it prints the whole text file at the command prompt which i dont want....
sde i tried was... (4 Replies)
Discussion started by: bhagya2340
4 Replies
6. Shell Programming and Scripting
hi
i have a file which store some data.the contents of my file is
data1:data2
data3:data4
i have a script which read this file
correct="$(cat /root/sh | cut -d: -f1)"
i used this syntax..please help me which syntax is used to remove blank spaces..then how to read this file.. (1 Reply)
Discussion started by: shubhig15
1 Replies
7. Shell Programming and Scripting
Hi
I want to remove entries with blank spaces
in my input file:
123
234
456
678
56789
345346456
589
3454
345456
3454566............................ (2 Replies)
Discussion started by: manigrover
2 Replies
8. Shell Programming and Scripting
I have a file which contains data such as that shown below. How do i remove all the blcnak spaces, before, during and at the end of each line in one command?
300015, 58.0823212, 230.424728
300016, 58.2276459, 229.141602
300017, 58.7590027, 226.960846
... (9 Replies)
Discussion started by: carlr
9 Replies
9. Shell Programming and Scripting
Gents,
Please can you help me.. to remove blank spaces :)
Input
ABSOLUTE , ,FALSE ,1035 ,28 ,669 ,1817.0 ,CORREL BEFORE ,1
ABSOLUTE , ,FALSE ,1035 ,28 ,686 ,1817.0 ,CORREL BEFORE ,1
ABSOLUTE , ,FALSE ,1035 ,28 ,670 ,1819.0 ,CORREL BEFORE ,1
ABSOLUTE , ,FALSE ... (4 Replies)
Discussion started by: jiam912
4 Replies
10. UNIX for Dummies Questions & Answers
Dear Masters,
I want to remove all lines with blank spaces
input file:
a|abc|0|1
a|abc|2|3
b||3|5
c|def||7
d|def|0|1
Expected:
a|abc|0|1
a|abc|2|3
d|def|0|1
I did this
awk -F'|' '!/^$/' input (4 Replies)
Discussion started by: radius
4 Replies
LEARN ABOUT DEBIAN
bestups
BESTUPS(8) NUT Manual BESTUPS(8)
NAME
bestups - Driver for Best Power / SOLA (Phoenixtec protocol) UPS equipment
NOTE
This man page only documents the hardware-specific features of the bestups driver. For information about the core driver, see nutupsdrv(8).
SUPPORTED HARDWARE
bestups was designed to monitor Best Power UPS hardware like the Fortress, Fortress Telecom, Axxium Rackmount and Patriot Pro. It also
recognizes and supports SOLA units such as the 325, 520 and 620. In addition, the Best 610 is supported using the 'ID' option.
Other UPS hardware using the Phoenixtec protocol should also work, but they will generate a warning since their battery information is not
known.
This driver does not support some older Best/SOLA units.
EXTRA ARGUMENTS
This driver supports the following optional settings in the ups.conf(5):
nombattvolt=num
Override the battery float voltage which is normally determined by asking the hardware. This is useful if your UPS constantly reports
battery.charge values just below 100% even when it's completely charged.
If you have this problem, set this to whatever battery.voltage reports when the UPS is known to be completely charged with a good
battery.
The author's Best Fortress 750 uses nombattvolt=27.4.
battvoltmult=num
Multiply the reported battery voltage by this number. Some devices report only a fraction of the total battery voltage.
For example, the SOLA 610 700VA UPS (with a 24V battery) reports the single cell voltage (about 2.27V when fully charged). In this
particular case you can set battvoltmult = 12 in ups.conf(8) to fix this.
ID=string
Set the Identification response string. This should only be used with hardware that supports the Phoenixtec protocol status inquiry
commands, but not the "ID" command, such as the Best/SOLA 610. Format of the ID string is: AAA,BBBB,CCC,DDD,EE.E,FF.F
AAA is the three-character identification for the UPS model.
BBBB is the output power in VA (volt amperes). B is an integer number ranging from 0 to 9.
CCC is the Nominal Input Voltage. C is an integer number ranging from 0 to 9. The unit is Volts AC.
DDD is the Nominal Output Voltage. D is an integer number ranging from 0 to 9. The unit is Volts AC.
EE.E is the Battery Voltage that will cause the UPS to shut itself off. E is an integer number ranging from 0 to 9. Then unit is Volts
DC and a decimal point is present.
FF.F or FFF.F is the Battery Voltage at full charge. F is an integer number ranging from 0 to 9. Then unit is Volts DC. Typically, for
700VA, 1KVA and 1.5KVA units, the format is FF.F. For 2KVA and 3KVA units, the format is FFF.F.
Example: a Best 610 1.5KVA unit would use the string "610,1500,120,120,10.0,48.0".
BUGS
The battery charge percentage value (in battery.charge) is derived from the voltage data that the UPS returns, since the UPS doesn't return
that value directly. On some hardware, the charge will remain at 100% for a long time and then drops quickly shortly before the battery
runs out. You can confirm from the battery.voltage readings that this is a problem with the UPS and not this driver.
Similarly, the float from the charger in some models forces the battery charge percentage back up to 100% immedately after the UPS goes
back on-line, so you can't tell when it is really recharged.
Finally, some models give one value for the battery's nominal voltage and yet actually have a nominal voltage slightly below that. This
leads to things such as the perpetual 98.7% charge on the author's Fortress 750, even when it's been charging for weeks. You can use
nombattvolt= in ups.conf(8) to fix this.
AUTHOR
Russell Kroll, Jason White
SEE ALSO
The core driver:
nutupsdrv(8)
Internet resources:
The NUT (Network UPS Tools) home page: http://www.networkupstools.org/
Network UPS Tools 05/21/2012 BESTUPS(8)