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 manipulation text manipulation
.
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
Building Full-Text Search Applications with Oracle Text iBot Oracle Updates (RSS) 0 04-06-2008 05:10 AM
Text file manipulation Ezy UNIX for Dummies Questions & Answers 4 02-25-2008 01:15 PM
Text Manipulation. Icepick Shell Programming and Scripting 4 02-25-2008 04:18 AM
Text file manipulation svannala UNIX for Dummies Questions & Answers 5 01-20-2006 07:01 PM
shell script : text manipulation (easy quesiton) champion Shell Programming and Scripting 3 07-01-2002 03:10 AM

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

Join Date: Jun 2008
Posts: 32
text manipulation
Hi, i have a file like this below, and it my have n no. of lines. Moderator gave me a solution with awk, but it was working only for the first 2 lines because awk has a limitation. can anyone give me the solution, thank you
INPUT FILE:
1081 "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

1082 "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

1086 "WPCW 19 - CW/AM1, WFPT-DT3 28 - V-ME, WTRF-DT2 32 - F/MY, WPCB 40 - FAMN/CORNER,"
"WKBS-DT1 46 - FAMN/CORNER, WKBS 47 - FAMN/CORNER,"
"WPCB-DT1 50 - FAMN/CORNER, WGPT-DT3 54 - V-ME"
W35AW - Various Shopping Pgms
W47CV - TBN
WATCH WPXI 11 N & WPIX 11 CW
WATCH WPGH 53 F & WWCP 08 F

OUTPUT FILE should be like this:
1081WPCW 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 N & WPIX 11 CW

1082WPCW 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

1086WPCW 19 - CW/AM1, WFPT-DT3 28 - V-ME, WTRF-DT2 32 - F/MY, WPCB 40 - FAMN/CORNER,""WKBS-DT1 46 - FAMN/CORNER, WKBS 47 - FAMN/CORNER,""WPCB-DT1 50 - FAMN/CORNER, WGPT-DT3 54 - V-ME" W35AW - Various Shopping Pgms W47CV - TBN WATCH WPXI 11 N & WPIX 11 CWWATCH WPGH 53 F & WWCP 08 F
  #2 (permalink)  
Old 06-04-2008
joeyg's Avatar
joeyg joeyg is offline Forum Staff  
modérateur
  
 

Join Date: Dec 2007
Location: Home of 17-time world champion Boston Celtics
Posts: 1,311
Question Are you just trying to eliminate <cr> and <lf> characters?
Perhaps I am missing something, but it appears that you are trying to eliminate single-instance <cr> <lf> between lines, but maintain when there are consecutive <cr> <lf> pairs. Thus, turn 6-7 lines or so into one long sentence.
  #3 (permalink)  
Old 06-04-2008
injeti injeti is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 32
Hi, thanks for the reply, each line should start with a number like 1081 and all the lines of text should be joined till next number 1082.

so output should be like

1081WPCW 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 N & WPIX 11 CW

1082WPCW 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
  #4 (permalink)  
Old 06-04-2008
joeyg's Avatar
joeyg joeyg is offline Forum Staff  
modérateur
  
 

Join Date: Dec 2007
Location: Home of 17-time world champion Boston Celtics
Posts: 1,311
Question Before/after clarification
Quote:
Before = 1081 "WPCW
After = 1081WPCW
You also show a drop of:
space character
first double-quote

Also, are all starting prefixes four digits?
Is there a range of numbers? i.e. >1000 and <2000 ?
  #5 (permalink)  
Old 06-04-2008
injeti injeti is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 32
when the lines are joined, a comma can be appended or space and there is no range of numbers but always 4 digit numbers, if double quotes are removed then its good, thank you
  #6 (permalink)  
Old 06-04-2008
joeyg's Avatar
joeyg joeyg is offline Forum Staff  
modérateur
  
 

Join Date: Dec 2007
Location: Home of 17-time world champion Boston Celtics
Posts: 1,311
Wink One approach in unix script
script:
Code:
> cat conv_form
#! /bin/bash
#conv_form

ifile=file1
ofile=file9
rm $ofile 2>/dev/null
first=0

while read zf
   do
   fourc=$(echo "$zf" | cut -c1-4)
   if [ $fourc -gt 1 ] 2>/dev/null
      then
#output prior data (if any) skipping first pass thru file
         if [ $first -gt 0 ]
            then
            echo "$hold_var">>$ofile
            echo " ">>$ofile
         fi
         first=1
#clear variables
         hold_var=$(echo "$zf")
      else
         hold_var=$(echo "$hold_var" "$zf")
   fi
done <$ifile
#output prior data (if any) from where fell out of loop
echo "$hold_var">>$ofile
output:
>cat file9
1081 "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

1082 "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

1086 "WPCW 19 - CW/AM1, WFPT-DT3 28 - V-ME, WTRF-DT2 32 - F/MY, WPCB 40 - FAMN/CORNER," "WKBS-DT1 46 - FAMN/CORNER, WKBS 47 - FAMN/CORNER," "WPCB-DT1 50 - FAMN/CORNER, WGPT-DT3 54 - V-ME" W35AW - Various Shopping Pgms W47CV - TBN WATCH WPXI 11 N & WPIX 11 CW WATCH WPGH 53 F & WWCP 08 F
  #7 (permalink)  
Old 06-04-2008
injeti injeti is offline
Registered User
  
 

Join Date: Jun 2008
Posts: 32
i will try that, the output seems to be exactly what i wanted but i dont need space & doube quotes in between 1081 "WPCW

output should be like this:
1081WPCW 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

1082WPCW 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

1086WPCW 19 - CW/AM1, WFPT-DT3 28 - V-ME, WTRF-DT2 32 - F/MY, WPCB 40 - FAMN/CORNER,WKBS-DT1 46 - FAMN/CORNER, WKBS 47 - FAMN/CORNER,WPCB-DT1 50 - FAMN/CORNER, WGPT-DT3 54 - V-ME W35AW - Various Shopping Pgms W47CV - TBN WATCH WPXI 11 N & WPIX 11 CW WATCH WPGH 53 F & WWCP 08 F
Sponsored Links
Closed Thread
Page 1 of 2 1 2 >

Bookmarks

« Script to remove all empty files within the directory structure? | REGEX: Matching Null? »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Linear Mode Linear 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 08:24 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 translation by Google.
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