Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Replace certain character with a new a new line.

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Replace certain character with a new a new line.
# 1  
Old 08-17-2004
Replace certain character with a new a new line.
Hello all... please help with the following.

I am parsing the following type of file...

W001;
W003;
W025;W044;
W030;
W022;W024;W099;W098;

Would like to make it look like this...
W001
W003
W025
W044
W030
W022
W024
W099
W098

Does sed or awk have a built in Variable that will force a new line?
# 2  
Old 08-18-2004
There is a split() function in awk.

First split a line by ";", then print out the splited values. Finally, pipe the output to sort.
# 3  
Old 08-18-2004
Or using tr

Code:
tr -d \\n < infile | tr \; \\n | sort

Cheers
ZB
# 4  
Old 08-18-2004
Try setting the awk record separator "RS"...

awk 'BEGIN{RS=";"}{print $1}' file1
# 5  
Old 08-18-2004
thanks fro the replies fellas, but I wound up using sed...



cat input.fla | sed 's/\;/\
/g' | egrep -v "^\$" | sort | uniq
# 6  
Old 08-18-2004
I'd say get rid of the "cat" to save yourself a wasted process, i.e.

sed 's/\;/\
/g' input.fla | egrep -v "^\$" | sort | uniq
# 7  
Old 01-11-2008
Quote:
Originally Posted by djsal
Hello all... please help with the following.

I am parsing the following type of file...

W001;
W003;
W025;W044;
W030;
W022;W024;W099;W098;

Would like to make it look like this...
W001
W003
W025
W044
W030
W022
W024
W099
W098

Does sed or awk have a built in Variable that will force a new line?
Code:
awk '{gsub(";","\n");printf"%s",$0}' file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace Control M (^M) character with new line

Hi All, We are getting an external file in abc.csv format. When opened in excel spread sheet, it is opening alright. But when opened in notepad, I see the contents in a single line. Ftp'd the file in binary mode to AIX UNIX host. When opened, I see Control M (^M) characters in place of New Line... (16 Replies)
Discussion started by: njny
16 Replies

2. Shell Programming and Scripting

Replace x-y character in line

I have a file which has n number of lines, i want to replace 3rd line position 3-5 to some text. 111111111111111111 222222222222222222 333333333333333333 444444444444444444 expected output 111111111111111111 222222222222222222 33abc3333333333333 444444444444444444 it is... (7 Replies)
Discussion started by: greenworld123
7 Replies

3. Solaris

Line too long error Replace string with new line line character

I get a file which has all its content in a single row. The file contains xml data containing 3000 records, but all in a single row, making it difficult for Unix to Process the file. I decided to insert a new line character at all occurrences of a particular string in this file (say replacing... (4 Replies)
Discussion started by: ducati
4 Replies

4. Shell Programming and Scripting

Replace last character of every second line

Hi all. I wonder if this possible.... any help advice is very much appreciated.. I n a shell script I create a latex file that looks like this \documentclass{article} \usepackage{graphics} \begin{document} \begin{figure} \begin{center} \begin{tabular}{cc} ... (10 Replies)
Discussion started by: malandisa
10 Replies

5. Shell Programming and Scripting

How to replace all after 4th character in line ?

How to replace all after 4 character at line? & convert to upper case ? google.com -> GOOG (2 Replies)
Discussion started by: Trump
2 Replies

6. Shell Programming and Scripting

how to replace character in the line

I have unix text file which has the following data aadjdfad;fa;fjjd;lakd;lkaslkd;k;k;lk;k;lk;l;lk;lkj;lj;lkj;k;lkj;lj;lkj;lkj;lkj;j sdkadk;adlf;lajf;akdjf;lkdjf;lkadjf;lkajsd;lfkj;lkj;lkj;lk;lk;lk;lk;k;lkj;k;lkm... (2 Replies)
Discussion started by: Raju Datla
2 Replies

7. UNIX for Dummies Questions & Answers

match a character in a line and replace

Hi, I have a file with large number of records. Sample below: 123456789QWERT2U 2 erter 987123678ZXCVB6Y 5 7689 934567123GHJKUI4O 7 - -- -- I want the 16th character in each record to be replaced with the below as follows;so 2 will become K, 6 will become O and 4 will become... (3 Replies)
Discussion started by: er_ashu
3 Replies

8. Shell Programming and Scripting

replace > with new line character

<reward_data><date><datetime>071308000804</datetime></date> I want the above data to be displayed as <reward_data> <date> <datetime>071308000804</datetime> </date> How can i accomplish this. I tried the below tr "><" ">\n" < filename (4 Replies)
Discussion started by: borncrazy
4 Replies

9. Shell Programming and Scripting

to replace a new line character

sample I/p: S12J LLL H77K PPP J25O LOP I73S lOP K99O PLO Required O/p: S12J LLL H77K PPP J25O LOP I73S lOP K99O PLO how to replace a new line character with space using sed command only Cheers, Chan (2 Replies)
Discussion started by: chan
2 Replies

10. Shell Programming and Scripting

Replace a character in last line

Hello Sed Experts, I have got a file which contain entries as below pmNoOfSwDownHsCong, pmUlUpswitchAttemptHigh, pmUlUpswitchAttemptLow, pmUlUpswitchSuccessHigh, pmUlUpswitchSuccessLow, pmUpswitchFachHsAttempt, ... (6 Replies)
Discussion started by: Mohammed
6 Replies
Login or Register to Ask a Question