Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Remove spaces between charc and replace it with ','.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove spaces between charc and replace it with ','.
# 1  
Old 06-10-2008
Remove spaces between charc and replace it with ','.
Hi,

Below is my output file: (The below line has multiple spaces bet charc and I want to replace spaces with "," only for the first line)

NYCCMS97KJ931 01-JUN-08 1214957



I want this to be:

NYCCMS97KJ931, 01-JUN-08, 1214957


Thanks in advance.
# 2  
Old 06-10-2008
Code:
sed "1s/ /, /g" input_file.txt

# 3  
Old 06-10-2008
This is showing my output like:

NYCCMS97KJ931, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,
, , , , , , , , , , , , , , , , , , 01-JUN-08, , , , 1214957


I just want to replace all the spaces with one ",".

Thanks.
# 4  
Old 06-10-2008
Code:
sed "1s/  */, /g" input_file.txt

# 5  
Old 06-10-2008
Code:
tr ' ' ','

or
Code:
sed 's/ /,/g'

or
Code:
awk '{gsub(" ",",")}1'

# 6  
Old 06-10-2008
Thanks it worked.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Trying to remove leading spaces

OS : RHEL 6.7 Shell : bash I am trying to remove the leading the spaces in the below file $ cat pattern2.txt hello1 hello2 hello3 hello4 Expected output is shown below. $ cat pattern2.txt hello1 hello2 hello3 hello4 (2 Replies)
Discussion started by: John K
2 Replies

2. Shell Programming and Scripting

Remove spaces in a file

Hi friends, I have a file1.txt 1 | a | 4757634 | jund jdkj | erhyj 2 | a | 4757634 | jnd jdkj | rhje hjrhwj i have used tr -d '\040' to remove the spcaes output file cat file1.txt | tr -d '\040' 1|a|4757634|jundjdkj|erhyj... (5 Replies)
Discussion started by: i150371485
5 Replies

3. Shell Programming and Scripting

remove spaces

Hi folks, I need to remove spaces at the end of each line in a *.txt file. it looks like this word 1 word 2 . . . word n i found some sed commands but any of them didnt work so far thank you for your posts (6 Replies)
Discussion started by: Jimmy7
6 Replies

4. Shell Programming and Scripting

Remove spaces in filenames

Hi, I have files like below, In files coming as spaces. Before transfering those files into ftp server. I want to remove the spaces and then can transfer the files into unix server. e.g: filenames are 1) SHmail _profile001_20120908.txt 2) SHmail_profile001 _20120908.txt 3) sh... (3 Replies)
Discussion started by: kirankumar
3 Replies

5. UNIX for Dummies Questions & Answers

remove spaces in between file

hey, I have this file: ATOM 2510 HG12 VAL 160 8.462 15.861 1.637 ATOM 2511 HG13 VAL 160 9.152 14.510 0.725 ATOM 2512 CG2 VAL 160 6.506 16.579 -0.088 ATOM 2513 HG21 VAL 160 5.499 16.421 -0.478 ATOM 2514 HG22 VAL 160 6.417 16.984 ... (4 Replies)
Discussion started by: kanikasharma
4 Replies

6. Shell Programming and Scripting

remove spaces between tags

I am having the data.txt file as follows. ------- <RMService> <ResControl> <ResultCode>FATAL</ResultCode> <ServiceTime>38</ServiceTime> <DWLControl> <requesterLanguage>100</requesterLanguage> <requesterLocale>en</requesterLocale> <requesterName>NCO A Batch... (6 Replies)
Discussion started by: kmanivan82
6 Replies

7. Shell Programming and Scripting

Remove Spaces

Hi All, I have a comma seperated file. I wanna remove the spaces from column 2. I mean i don't wanna remove the spaces those are presnt in column 1. ex: emp name, emp no, salary abc k, abc 11, 1000 00 bhk s, bhk 22, 2000 00 the output should be: emp name, emp no, salary abc k, abc11,... (4 Replies)
Discussion started by: javeed7
4 Replies

8. UNIX for Dummies Questions & Answers

remove spaces btw

filename contains: 123 4 1234 5 12345 689 i want result: 1234 12345 12345679 cat filename | awk '{print $1, $2, $3}' will get my result, but too many $$s. sed -e 's///g' filename will take care one space, will take 2 spaces. is it a short way to do this ? (7 Replies)
Discussion started by: tjmannonline
7 Replies

9. Shell Programming and Scripting

exporting number into .csv file in text form (no other extra charc) from shell script

I have written a k shell program which is executing a sql and exporting data in numeric form like 0412323444 into .csv file. the problem i am facing is that , the data is coming in excel formatted in scientific form like 4.1+E08,while my requirement is to store data as such 0412323444 in excel ( no... (5 Replies)
Discussion started by: Deepak_Rastogi
5 Replies

10. UNIX for Dummies Questions & Answers

How to remove trailing spaces

Hi, I have a file like this (ADD_MONTHS((Substr(Trim(BOTH FROM Translate(Maximum(closeDa ------------------------------------------------------------ 2007-06-30 00:00:00 I have a requirement where i need just the date. When i do: tail -1... (2 Replies)
Discussion started by: mahek_bedi
2 Replies
Login or Register to Ask a Question