Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Remove blank spaces

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove blank spaces
# 1  
Old 02-14-2013
Remove blank spaces
Gents,

Please can you help me.. to remove blank spaces Smilie

Input

Code:
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  ,1035  ,28  ,687  ,1819.0  ,CORREL BEFORE  ,1

Output file desired

Code:
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,1035,28,687,1819.0,CORREL BEFORE,1

Thanks in advance Smilie
# 2  
Old 02-14-2013
Removal of the blanks around the commas:
Code:
perl -i -pe 's/\s*,\s*/,/g' file

This User Gave Thanks to MadeInGermany For This Post:
jiam912
# 3  
Old 02-14-2013
Code:
 sed 's/ *,/,/g' file

This User Gave Thanks to pamu For This Post:
jiam912
# 4  
Old 02-14-2013
awk version
Code:
awk -F" +," '{$1=$1}1' OFS=, file

This User Gave Thanks to Jotne For This Post:
jiam912
# 5  
Old 02-14-2013
Thanks to all ,, your help is appreciated Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Delete blank spaces and blank lines in a file

Hi Gurus, Somebody can say me how to delete blank spaces and blank lines in a file unix, please. Thank you for advanced. (10 Replies)
Discussion started by: systemoper
10 Replies

2. UNIX for Dummies Questions & Answers

Remove blank spaces

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

3. Shell Programming and Scripting

How to remove all blank spaces in a file

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

4. Shell Programming and Scripting

Request to check:remove entries with blank spaces

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

5. Shell Programming and Scripting

how to remove blank spaces in file

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

6. Shell Programming and Scripting

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 ... (3 Replies)
Discussion started by: ppat7046
3 Replies

7. Shell Programming and Scripting

Remove blank spaces in a text file...

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

8. Shell Programming and Scripting

how to remove blank spaces of a file with awk??

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

9. UNIX for Dummies Questions & Answers

To remove Continous blank spaces from a file in UNIX

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

10. Shell Programming and Scripting

remove blank spaces in a string

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
Login or Register to Ask a Question