problem with replace command with tr


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting problem with replace command with tr
# 1  
Old 08-19-2009
problem with replace command with tr

I have a sample file like this
Code:
7829885    7831552    +    1    1667,    0,
35934936    35937087    -    2    1281,870,    0,1281,

I would like to replace values starts with comma with just value like 0, to 0 or 1667, to 1667.
I can do with this by using tr -d '0,' '0' <file

But the problem having here is I would like to replace only single value that has comma like 0, or 1667, not the multiple valuse with commas like 1281,870, or 0,1281,
Briefly with out confusion
I have to remove the commas of all single values (1667 0)
I have to remove the last commas of all multiple values (1281,870 0,1281)

output
Code:
7829885    7831552    +    1    1667    0
35934936    35937087    -    2    1281,870    0,1281

Thanx
# 2  
Old 08-19-2009
Hi,

Try this.

Code:
sed -e 's/,[^0-9]//g' -e 's/,$//g' file_name

Regards,

Ranjith
# 3  
Old 08-19-2009
Code:
64,	0,

Code:
640

But I need
Code:
64  0

I mean a tab is missing so it is combinig 0 with the previous values.
Could please take allook

---------- Post updated at 09:00 PM ---------- Previous update was at 08:58 PM ----------

Code:
sed -e 's/,[^0-9]//g' -e 's/,$//g' file_name

Ok i got it

Thanx
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Search and replace problem

Hi, I am looking for bash or awk script to solve the following. Input File 1: >Min_0-t10270-RA|>Min_0-t10270-RA protein AED:0.41 eAED:0.46 QI:0|0|0|0.25|1|1|4|0|190 MIGLGFKYLDTSYFGGFCEPSEDMNKVCTMRADCCEGIEMRFHDLKLVLEDWRNFTKLST EEKRLWATPAAEDFF >Min_0-t10271-RA|>Min_0-t10271-RA protein... (5 Replies)
Discussion started by: Fahmida
5 Replies

2. Shell Programming and Scripting

Problem With Replace Script

Hi, I posted a topic requesting help with a script to replace certain things in an XML file https://www.unix.com/shell-programming-scripting/202943-replace-string-newline-2.html The replies helped a lot but I found that on big files it didn't work properly. The file I'm amending is... (5 Replies)
Discussion started by: Ste_Moore01
5 Replies

3. Homework & Coursework Questions

VI Search and Replace problem help...

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: Give the vi command for replacing all occurances of the string "DOS" with the string "UNIX" in the whole... (4 Replies)
Discussion started by: kbreitsprecher
4 Replies

4. Shell Programming and Scripting

Find and replace problem

i have a script that will find a certian pattern and replace it with blank space #!/bin/ksh for i in `cat test.txt | grep "UTILINET" | cut -c 172-191` do perl -pi -e 's/$i//g' test.txt echo "Completed" done the command gives some of the below strings 50032E1B ... (5 Replies)
Discussion started by: ali560045
5 Replies

5. Shell Programming and Scripting

find and replace problem

hi guys!!! i am writing a script in which i take an input from user and find it in a file and replace it. My input file looks like hi what your name? allrise my code looks is echo "Enter the name" read name FILE="/opt/name.txt" NEW_FILE="/opt/new_name.txt" exec 0<$FILE ... (3 Replies)
Discussion started by: allrise123
3 Replies

6. Shell Programming and Scripting

Multiline replace problem

I have a data of the form 0.0117843924 0. 0. 0. 0. 0.011036017 0. 0. 0. 0. 0.0103351669 0. 0. 0. 0. 4839.41211 0. 0. 0. 0. 4532.08203 0. 0. 0. 0. I would like to insert a couple of blank lines before the 4839 line, every time it appears. The numbers in the... (2 Replies)
Discussion started by: mathis
2 Replies

7. Shell Programming and Scripting

Problem with sed (search/replace)

Hi, In a file FILE, the following lines appear : WORD 8 8 8 ANOTHERWORD blabla ... Directly in the prompt, if I type $sed '/WORD/s/8/10/g' FILE it replace the 8's by 10's in file : $cat FILE WORD 10 10 10 ANOTHERWORD blabla ... (9 Replies)
Discussion started by: tipi
9 Replies

8. UNIX for Dummies Questions & Answers

find and replace command in one line using one command

Hi, I have a entry in the file as ::BSNL GUJARAT::India::OUT::NAT::REWEL::POSTPAID::919426199995 if u see this, i have the delimiter as :: , all i want is to replace "::" as ":" so how to do that.. pls help thanks (10 Replies)
Discussion started by: vasikaran
10 Replies

9. UNIX for Dummies Questions & Answers

vi search & replace ... having '/' in string - problem.

I want to carry out search & replace for the paths mentioned in the file with the help of vi. 'abc/' to be replaced by 'abc/data' When I use command in vi as below - %s/abc//abc/data/g it gives me an error. How we should deal with '/' part in string for vi search & replace? ... (6 Replies)
Discussion started by: videsh77
6 Replies
Login or Register to Ask a Question