Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

text file editing

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting text file editing
# 15  
Old 06-03-2008
I guess we got it wrong, I need comma only from the next line not like 1234,ABCD, when next line is joined then I need the comma and quotes removed, thanks
# 16  
Old 06-03-2008
Hi, thanks a lot for your response, the solution provided by the moderator is really excellent, so I want to continue that, thanks a lot for your help
# 17  
Old 06-03-2008
Quote:
Originally Posted by injeti
Hi, thanks a lot for your response, the solution provided by the moderator is really excellent, so I want to continue that, [...]
OK,
I'm out Smilie
# 18  
Old 06-03-2008
Quote:
Originally Posted by injeti
Hi, thanks a lot for your response, the solution provided by the moderator is really excellent, so I want to continue that, thanks a lot for your help
hmmmmmmm.... I don't follow.
Could post (again) a sample input and a desired output, pls.

radoulov Smilie
# 19  
Old 06-03-2008
yes

INPUT is :

1086 "WPCW 19 - CW/AM1, WFPT-DT3 28 - V-ME, WTRF-DT2 32 - F/MY
WATCH WPGH 53 F & WWCP 08 F

1087 "WPCW 19 - CW/AM1, WPCB 40 - FAMN/CORNER,
WATCH WPXI 11 N & WPIX 11 CW

Desired OUTPUT should be:

1086WPCW 19 - CW/AM1, WFPT-DT3 28 - V-ME, WTRF-DT2 32 - F/MY, WATCH WPGH 53 F & WWCP 08 F

1087WPCW 19 - CW/AM1, WPCB 40 - FAMN/CORNER, WATCH WPXI 11 N & WPIX 11 CW

when the next line is joined, a comma should be added and the quotes should be removed
# 20  
Old 06-03-2008
ok, one more try:
Code:
nawk -v RS='' -v FS='' -v qq='"' '{gsub(" +" qq, ""); for(i=1;i<NF;i++) if(!match($i, ",$" )) $i=$i ",";print $0 "\n"}' myFile

# 21  
Old 06-04-2008
hi, the solution which you have provided below is working fine for only 2 lines in a file just like the sample which i have given, i want that to work for n no. of lines, thank you

nawk -v RS='' -v OFS=' ' -v qq='"' '$1=$1 {gsub(" +" qq, "");print $0 "\n"}' myfile
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Editing long text file

Good morning all, I have a machine running IRIX and I need to edit a text file on the terminal that is literally thousands of lines. Does anyone know the most efficient way to edit portions of files like these? Obviously simply using the vi command isn't going to work since I get a too many lines... (1 Reply)
Discussion started by: James C
1 Replies

2. Shell Programming and Scripting

Convert vi editing to text editing

Dear Guru's I'm using Putty and want to edit a file. I know we generally use vi editor to do it. As I'm not good in using vi editor, I want to convert the vi into something like text pad. Is there any option in Putty to do the same ? Thanks for your response. Srini (6 Replies)
Discussion started by: thummi9090
6 Replies

3. Shell Programming and Scripting

Help needed editing text file using the terminal

Hi, I have text file with the header like this tracking_id condition replicate FPKM XLOC_000001 alpha 1 10.3199 XLOC_000001 alpha 0 10.3686 XLOC_000001 alpha 2 15.5619 ... With the first column being genes, the second being the condition, the third... (5 Replies)
Discussion started by: 4galaxy7
5 Replies

4. Shell Programming and Scripting

editing line in text file adding number to value in file

I have a text file that has data like: Data "12345#22" Fred ID 12345 Age 45 Wilma Dino Data "123#22" Tarzan ID 123 Age 33 Jane I need to figure out a way of adding 1,000,000 to the specific lines (always same format) in the file, so it becomes: Data "1012345#22" Fred ID... (16 Replies)
Discussion started by: say170
16 Replies

5. Programming

Editing a specific liine of text file - C++

Is there any way to erase all the contents of a specific line of a text file and then write something on it? e.g. test.txt.old: qwert asdfg zxcbv=0 test.txt.new qwerty asdfg hello=0 is this possible with C++ ?:confused: (1 Reply)
Discussion started by: hakermania
1 Replies

6. Shell Programming and Scripting

Editing text using AWK

France : 40 : John Persia : 50 : John -----Database What i am trying to achieve is to search for a book, and replave the title with the new title echo -n "Title:" read Title echo -n "Author:" read Author echo "new Title" read NewTitle awk 'BEGIN {... (11 Replies)
Discussion started by: gregarion
11 Replies

7. Shell Programming and Scripting

Text editing script does everything but edit text.

I wrote this script to create and edit a large number of websites based on a template site and a collection of text files which have the relevant strings in them delimited by colons. I run it and the shell doesn't produce any errors, but when it gets to the for loop where it actually has to edit... (2 Replies)
Discussion started by: afroCluster
2 Replies

8. UNIX for Dummies Questions & Answers

Text editing on iPhone using ed

Hi all, I'm trying to edit a file using ed on an iphone. I am trying to edit a conf file and have managed to get to the directory where the default.conf file is located, however, when I type ed default.conf all i get is a number and then a blank line and a question mark which is why I am... (1 Reply)
Discussion started by: drewcifer
1 Replies

9. UNIX for Dummies Questions & Answers

Text Editing

Hello everybody, I have a sorted text file. some of the lines appear twice or even more. is there an unix utility that removes the extra appearences? Thanks, Ido. (7 Replies)
Discussion started by: ginodii
7 Replies
Login or Register to Ask a Question