Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Suppressing space replacing by comma

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Suppressing space replacing by comma
# 1  
Old 04-19-2010
Suppressing space replacing by comma
hi

i want to replace spaces by comma
my file is
Code:
ADD     16428   170     160     3       WNPG    204     941     No      204802
ADD     16428   170     160     3       WNPG    204     941     No      204803
ADD     16428   170     160     3       WNPG    204     941     No      204804
ADD     16428   170     160     3       WNPG    204     941     No      204831
ADD     16428   170     160     3       WNPG    204     941     No      204832
ADD     16428   170     160     3       WNPG    204     941     No      204833
ADD     16428   170     160     3       WNPG    204     941     No      204837
ADD     16428   170     160     3       WNPG    204     941     No      204853
ADD     16428   170     160     3       WNPG    204     941     No      204862

i want it like
Code:
ADD,16428,170,143,1,WNPG,204,242,No,204208
ADD,16428,170,143,1,WNPG,204,242,No,204216
ADD,16428,170,143,1,WNPG,204,242,No,204242
ADD,16428,170,143,1,WNPG,204,242,No,204245
ADD,16428,170,143,1,WNPG,204,242,No,204246
ADD,16428,170,143,1,WNPG,204,242,No,204312
ADD,16428,170,143,1,WNPG,204,242,No,204313
ADD,16428,170,143,1,WNPG,204,242,No,204319
ADD,16428,170,143,1,WNPG,204,242,No,204324

please let me know ..
Last edited by Scott; 04-19-2010 at 09:49 AM.. Reason: Code tags, PLEASE!
# 2  
Old 04-19-2010
Code:
 
tr " " "," < input_file

# 3  
Old 04-19-2010
try
Code:
 sed 's/\s/,/g' file_name

# 4  
Old 04-19-2010
Both are not working !
# 5  
Old 04-19-2010
They're not working because you didn't use code tags, and your formatting was therefore removed.

Code:
sed "s/  */,/g" inputfile

# 6  
Old 04-19-2010
replace multiple space with comma.
Quote:
Originally Posted by raghavendra.cse
Both are not working !
what ever solution is posted as per your previous requirement. But u changed the space with multiple space..
now you can try
Code:
sed 's/\s\+/,/g' file_name

# 7  
Old 04-19-2010
Hi

If your input file is tab delimited then try this.

Code:
tr '\011' ',' < filename

and If it is space delimited then

Code:
tr -s ' ' ',' < filename
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Add previous text when replacing comma with new line

Hi, I've got this output: # cat test2.txt TM1ITP1-TMNLSTP1 SLC00=0,SLC01=0,SLC02=0,SLC03=0 if I just use cat test2.txt | tr "," "\n" I'll end up very near to what I'm trying to achieve: TM1ITP1-TMNLSTP1 SLC00=0 SLC01=0 SLC02=0 SLC03=0 But how can i eventually add the term... (1 Reply)
Discussion started by: nms
1 Replies

2. Shell Programming and Scripting

Need help with Sed (replacing parenthesis and comma)

I have the following text as an input text: input.txt Results('Toilet', 'Sink', ) and i want to remove the last comma so the output is output.txt Results('Toilet', 'Sink' ) I tried using the following sed command, but I get a parsing error: sed s/, \)/\)/g input.txt >... (5 Replies)
Discussion started by: jl487
5 Replies

3. UNIX for Dummies Questions & Answers

Replacing | with a comma

I have a huge file which is pipe delimiter and i want to replace the pipe delimiter to a comma Please Help as its v urgent. Ex: parent|child|alias|....Heading of the file...and the data is of similar structure. (4 Replies)
Discussion started by: win4luv
4 Replies

4. Shell Programming and Scripting

Replacing Comma delimiter coming inside the data.

Hello, I am having flat file (Comma Delimiter) and the data in the file is as given below. EMPNO, ENAME, DESIGNATION, SALARY 10979, Arun Kumar, Cosultant, 35000 13555, Bidhu Shekar, Senior Consultant, 45000 15000, Kiran, Kumar, Senior, Consultant, 40000 If... (9 Replies)
Discussion started by: arunvasu2
9 Replies

5. UNIX for Advanced & Expert Users

Replacing the comma in .csv file in unix

Hi All, Could some one help me on one of my requirement below: I have a sequential file with 4fields in it and it is a comma (,) seperated file. Delimeter is 'comma'. But in of the file column for ex: 3rd column it is 'Description' (column name) I am getting the values with commas.... (6 Replies)
Discussion started by: eskay_s
6 Replies

6. Shell Programming and Scripting

sed help - replacing 6th comma with a space

Hi, How can I replace the 6th comma on each line (of a csv) with a space? Any online tutorials with plenty of examples using sed would be very useful. Alex (2 Replies)
Discussion started by: mcclunyboy
2 Replies

7. UNIX for Dummies Questions & Answers

Replacing underscore with white space after comma.

Hi all, I'm hoping you can help.. I've used this forum a couple of times and I am back again now i've moved onto something more complex (for me!) I have some data which looks like: "AL1_1,AL1_1," "AL1_1.AL1_1A.AL1_1AE,AL1_1AE," "AL1_1.AL1_1A.AL1_1AG,AL1_1AG," "AL1_1.AL1_1A.AL1_1AJ,AL1_1AJ,"... (10 Replies)
Discussion started by: gman
10 Replies

8. Shell Programming and Scripting

Replacing dot for comma

I wanted to change 34.66 to 34,66. I tried the command: sed 's/./,/' $NUM Where $NUM is a variable with 34.66 value. The output is ,4.66 (2 Replies)
Discussion started by: bdalmeida
2 Replies

9. UNIX for Dummies Questions & Answers

Replacing Comma by Tab

Hi All, i have a file test.txt as shown below, 1,test,test111 2,rest,rest222 i want to replace the commas by tab delimiter.., it should be like, 1 test test111 2 rest rest222 i tried the following code, sed 's/,/\\t/g' test.txt >> ouptut.txt (9 Replies)
Discussion started by: Serious Sam
9 Replies

10. Shell Programming and Scripting

replacing comma's with newlines using sed

Hi All, silly question that I'm sure is easy to answer for a more experienced coder... I have a file called test.txt containing the following text... need, to, break, this, line, into, individual, lines using sed, I'd like to make the file look like this... need to break this line... (5 Replies)
Discussion started by: newbie_coder
5 Replies
Login or Register to Ask a Question