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 HPUX
unexpand
expand(1) General Commands Manual expand(1)
NAME
expand, unexpand - expand tabs to spaces, and vice versa
SYNOPSIS
tablist] [file ...]
tablist] [file ...]
Obsolescent:
tabstop] tabn] [file ...]
DESCRIPTION
processes the named files or the standard input and writes to the standard output with tabs changed into spaces. Backspace characters are
preserved in the output, and the column count is decreased by one column for tab calculations. For proper tab calculation, if a multi-col-
umn character is to be "backspace'd", it should be followed by multiple backspace characters which equal to it's column width. If a tab
character is found after the last tab position, it is replaced by a single space. is useful for preprocessing character files that contain
tabs (before sorting, looking at specific columns, etc).
recognizes the following command-line options and arguments:
tablist specifies where to set the tab positions instead of the default tablist can take two forms. If it is a single num-
ber, tabs are set tablist spaces apart. tablist can also be a blank- or comma-separated list of increasing positions
where tabs are to be set.
This option is obsolescent and is equivalent to using
This option is obsolescent and is equivalent to using
processes the named files or the standard input and writes to the standard output with spaces changed into tabs where possible. By
default, only leading spaces and tabs are converted to maximal strings of tabs. The default tab position is every 8 characters. Backspace
characters are preserved into the output, and the column count is decreased by one column for tab calculations. For proper tab calcula-
tion, if a multi-column character is to be "backspace'd", it should be followed by multiple backspace characters which equal to it's column
width.
recognizes the following command-line options and arguments:
Tabs are inserted whenever they would compress the resultant file
by replacing two or more spaces before a tab position.
tablist specifies the tab positions. tablist can take two forms. If it is a single number, tabs are set every tablist spa-
ces apart. If tablist is a blank- or comma-separated list of increasing positions, tabs are set at those locations.
The option implies the option. If the option is not specified, the default is equivalent to specifying except that
is not implied for this case.
EXTERNAL INFLUENCES
Environment Variables
determines the interpretation of text as single and/or multi-byte characters.
determines the language in which messages are displayed.
If or is not specified in the environment or is set to the empty string, the value of is used as a default for each unspecified or empty
variable. If is not specified or is set to the empty string, a default of "C" (see lang(5)) is used instead of
If any internationalization variable contains an invalid setting, and behave as if all internationalization variables are set to "C". See
environ(5).
If is set to a non-empty string value, it overrides the values of all the other internationalization variables.
International Code Set Support
Single- and multi-byte character code sets are supported with the exception that do not recognize multi-byte alternative space characters.
STANDARDS CONFORMANCE
expand(1)