The UNIX and Linux Forums  
Hello and Welcome from United States to the UNIX and Linux Forums! Thank You for Visiting and Joining Our Global Community.

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
text file editing text file editing
.
google unix.com

Forums Register Forum RulesLinksAlbums FAQ Members List Calendar Search Today's Posts Mark Forums Read


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts and shell scripting languages here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Text editing on iPhone using ed drewcifer UNIX for Dummies Questions & Answers 1 03-05-2008 07:15 PM
Cons: Configuration is done by editing the text-based config file ... - Techworld.com iBot UNIX and Linux RSS News 0 10-09-2007 09:10 AM
Editing file rahul303 Shell Programming and Scripting 4 09-23-2007 10:49 PM
Text Editing ginodii UNIX for Dummies Questions & Answers 7 10-19-2006 09:13 AM
Help editing a file Docboyeee Shell Programming and Scripting 8 05-22-2002 09:22 AM

Closed Thread
English Japanese Spanish French German Portuguese Italian Dutch Swedish Russian Norwegian Hungarian Hebrew Danish Powered by Powered by Google
 
LinkBack Thread Tools Search this Thread Rate Thread Display Modes
  #1 (permalink)  
Old 06-03-2008
injeti injeti is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 32
text file editing
Hi, I need some help in text manipulation.

I have an input file like this:

7629 "WPCW 19 - CW/AM1, WPCB 40 - FAMN/CORNER, WPCB-DT1 50 - FAMN/CORNER, "
W35AW - Various Shopping Pgms
W41CF - TBN
W47CV - TBN
WLLS-LP 49 - AM1
WATCH WPXI 11 N & WPIX 11 CW

1234 "WPCW 19 - CW/AM1, WTRF-DT2 32 - F/MY, WPCB 40 - FAMN/CORNER, "
"WKBS-DT1 46 - FAMN/CORNER, WKBS 47 - FAMN/CORNER, WPCB-DT1 50 - FAMN/CORNER"
W45BT - FAMN/CORNER
W47CV - TBN
WLLS-LP 49 - AM1
WATCH WPXI 11 N & WPIX 11 CW
WATCH WPGH 53 F & WWCP 08 F[/B]
--------------------------------------------------------------------------
Output file should be like this:

7629WPCW 19 - CW/AM1, WPCB 40 - FAMN/CORNER, WPCB-DT1 50 - FAMN/CORNER, W35AW - Various Shopping PgmsW41CF - TBN W47CV - TBN WLLS-LP 49 - AM1 WATCH WPXI 11 & WPIX 11 CW

1234WPCW 19 - CW/AM1, WTRF-DT2 32 - F/MY, WPCB 40 - FAMN/CORNER, ""WKBS-DT1 46 - FAMN/CORNER, WKBS 47 - FAMN/CORNER, WPCB-DT1 50 - FAMN/CORNER" W45BT - FAMN/CORNER W47CV - TBN WLLS-LP 49 - AM1 WATCH WPXI 11 N & WPIX 11 CW WATCH WPGH 53 F & WWCP 08 F
--------------------------------------------------------------------------
Please provide me a solution, Thanks, Injeti
  #2 (permalink)  
Old 06-03-2008
vgersh99's Avatar
vgersh99 vgersh99 is online now Forum Staff  
Moderator
  
 

Join Date: Feb 2005
Location: Boston, MA
Posts: 5,119
Code:
nawk -v RS='' -v OFS=' ' '$1=$1' myFile
  #3 (permalink)  
Old 06-03-2008
injeti injeti is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 32
Hi thanks a lot, it worked, but it worked with 'awk' not 'nawk'
  #4 (permalink)  
Old 06-03-2008
injeti injeti is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 32
Hi, in the output file I need a new line between two lines, just like the way I have mentioned the output file to be, currently theres no new line
  #5 (permalink)  
Old 06-03-2008
vgersh99's Avatar
vgersh99 vgersh99 is online now Forum Staff  
Moderator
  
 

Join Date: Feb 2005
Location: Boston, MA
Posts: 5,119
Quote:
Originally Posted by injeti View Post
Hi, in the output file I need a new line between two lines, just like the way I have mentioned the output file to be, currently theres no new line
Code:
nawk -v RS='' -v OFS=' ' '$1=$1 {print $0 "\n"}' myFile
  #6 (permalink)  
Old 06-03-2008
injeti injeti is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 32
Thanks it worked, theres shouldnt be any space between the first 4 numbers and the next letters , like 7629WPCW, currently a space is coming 7629 WPCW

I need like this 7629WPCW and removing the quotes, Thanks
Closed Thread

Bookmarks

Tags
solaris

« Korn: How to zero fill df output so it will sort properly | how to average in awk »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Hybrid Mode Hybrid Mode
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 04:29 AM.

The UNIX and Linux Forums - Learn UNIX and UNIX Commands RSS Feeds - Contact Us - The UNIX and Linux Forums - Learn UNIX and UNIX Commands - Archive - Top

Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited. Language Translations Powered by .
vBCredits v1.4 Copyright ©2007 - 2008, PixelFX Studios
The UNIX and Linux Forums Content Copyright ©1993-2009. All Rights Reserved.Ad Management by RedTyger

Content Relevant URLs by vBSEO 3.2.0