replacing certain characters with new line?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting replacing certain characters with new line?
# 1  
Old 05-13-2007
replacing certain characters with new line?

i have a text file which domains something like this

123213213213/32434342
324324324/12312321321
12321321,435435435
12321312 / 12313213 / 12435435345
4353213 , 123213213213
21321321312-12334324
234324324 - 235645645645
456456456 - 45456456456 - 45645645654243

how can i replace '/' and ' / ' and ',' and '-' and ' - ' with new line so the numbers gets sorted all into new lines using any tool such as sed, awk etc.. ?


Thank you.
# 2  
Old 05-13-2007
Try :
Code:
awk '{gsub(/ - |-| \/ |\//, "\n"); print' infile > outfile


Jean-Pierre.
# 3  
Old 05-13-2007
Quote:
Originally Posted by aigles
Try :
Code:
awk '{gsub(/ - |-| \/ |\//, "\n"); print' infile > outfile


Jean-Pierre.
i corrected itto
Code:
awk '{gsub(/ - |-| \/ |\//, "\n"); print}'

but it didnt replace , with new lines any idea why? although it did work just fine for the dashes and slashes Smilie


Thanks
# 4  
Old 05-13-2007
never mind this did it
Code:
awk '{gsub(/ - |,|-| \/ |\//, "\n"); print}' in > out

Smilie

Thanks again
# 5  
Old 05-13-2007
With GNU Awk:

Code:
awk '$1=$1' RS="[\n/,-]" inputfile

Otherwise:

Code:
sed 's/ *[/,-] */\
/g' inputfile

Then use sort to order the output.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replacing end of line characters

Hello, I'm looking for some help in renaming data-timestamps stored within different calendar directories/files. The calendar directory has hundreds of ICS files: ~/Library/Calendars/F494C908.calendar/Events/92B65E439AAC.ics ~/Library/Calendars/F494C908.calendar/Events/DE7867E61969.ics... (8 Replies)
Discussion started by: Schubi
8 Replies

2. Shell Programming and Scripting

sed replacing specific characters and control characters by escaping

sed -e "s// /g" old.txt > new.txt While I do know some control characters need to be escaped, can normal characters also be escaped and still work the same way? Basically I do not know all control characters that have a special meaning, for example, ?, ., % have a meaning and have to be escaped... (11 Replies)
Discussion started by: ijustneeda
11 Replies

3. Shell Programming and Scripting

Replacing characters

Hi fellow experts, I have a question for you. Data looks like: 00877,05/13/2010,PBO,P,0000708331,518 00877,05/13/2010,PBO,P,0000708331,519 ... ... 00877,05/13/2010,PBO,P,0000708331,2103 00877,05/13/2010,PBO,P,0000708331,2104,etc,etc Basically I have to replace 518,519,2103,2104,... (4 Replies)
Discussion started by: Devski123
4 Replies

4. Shell Programming and Scripting

Replacing strang characters ^Y ^Z ^Q ^A

hello frends, i am facing a problem where when i use vi to ciew my files then every line contains a special character like ^Q ^A ^Y ^Z in the very beginning. i tried to remove them using many techniques already posted in this forum but in vain. please take a sample of file when viewed in vi editor:... (6 Replies)
Discussion started by: vikas_kesarwani
6 Replies

5. Shell Programming and Scripting

Replacing Characters with |

Hi All, example data.log 526569346 66815531961 09 526569346 66815531961 09 526569346 66815531961 09 526569346 66815531961 09 526569346 66815531961 09 I want like this to 526569346|66815531961|09 526569346|66815531961|09... (4 Replies)
Discussion started by: ooilinlove
4 Replies

6. Shell Programming and Scripting

Replacing Characters

Hi All, I have a file which is delimeted with the character '. i need to replace this character with the same character and also a new line. Can anyone please help me with the tr command for this. Many thanks Karan (11 Replies)
Discussion started by: karansachdeva
11 Replies

7. Shell Programming and Scripting

replacing characters

hi all I have a file that has sone spaces in start then / at last. i want to get rid of this. how to do? eg. 11414/ 49878/ 27627/ I WANT THE FILE AS 11414 49878 27627 PLEASE HELP (3 Replies)
Discussion started by: infyanurag
3 Replies

8. UNIX for Dummies Questions & Answers

replacing characters

Hi, I have a script for replacing bad characters in filenames for f in *; do mv $f `echo $f | tr '+' '_'` done; this replaces + for _ But I need to replace all bad characters ? / % + to _ Pls how can i do this in one script ? (3 Replies)
Discussion started by: palmer18
3 Replies

9. Shell Programming and Scripting

Replacing characters in file with line break

Hi, Apologies if this has been asked before, but I searched and was not able to find an answer. It's probably a simple question to answer for those of you with some experience, though... I have a relatively long string where tokens are separated by the colon (':') character. Let's say the... (10 Replies)
Discussion started by: johnemb
10 Replies

10. Shell Programming and Scripting

Replacing all but last Hex characters in a text line

I must remove hex characters 0A and 0D from several fields within an MS Access Table. Since I don't think it can be done in Access, I am trying here. I am exporting a Table from Access (must be fixed length fields, I think, for my idea to work here) into a text format. I then want to run a... (2 Replies)
Discussion started by: BAH
2 Replies
Login or Register to Ask a Question