Awk to Break lines to multiple lines. - The UNIX and Linux Forums

		The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Awk to Break lines to multiple lines.

google unix.com

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
Break lines up into single lines after each space in every line	lewk	Shell Programming and Scripting	7	10-14-2009 10:33 AM
join lines on line break in files	mad_man12	Shell Programming and Scripting	6	07-31-2009 11:29 AM
Break one line to many lines using awk	pinnacle	Shell Programming and Scripting	16	06-01-2009 03:05 AM
retrieved multiple lines on multiple places in a file	dala	Shell Programming and Scripting	8	03-14-2008 03:28 PM
How to count lines - ignoring blank lines and commented lines	kthatch	UNIX for Dummies Questions & Answers	6	05-25-2007 02:21 AM


	Powered by

LinkBack

Thread Tools

Search this Thread

Rate Thread

Display Modes

#1 (permalink)

11-02-2009

pinnacle

Registered User

Join Date: Apr 2009

Posts: 182

Awk to Break lines to multiple lines.

Input File:

Quote:

123456789|H03,H01,R06,R05,C06|H03,H01,R06,R05,C06

Code:

 
nawk -F "|" '{
        for(i=1;i<=NF;i++) {
     if (i == 2) 
         {gsub(",","#",$i);z=split($i,a,"[#]")}
     else if (i == 3) 
         {gsub(",","#",$i);z=split($i,b,"[#]")}
 }
     if(z > 0) for(i=1;i<=z;i++)
  print $1,a[i],"Test";
     if(w > 0) for(j=1;j<=w;j++)
         print $1,b[j],"Testing";
  z=0;w=0
    }' OFS="|"  awktest.txt

Required Output:

Quote:

123456789|H03|Test
123456789|H01|Test
123456789|R06|Test
123456789|R05|Test
123456789|C06|Test
123456789|H03|Testing
123456789|H01|Testing
123456789|R06|Testing
123456789|R05|Testing
123456789|C06|Testing

Bookmarks

« issue invoking shell script using cron, even with proper file permission | Dropping Records for unknown reason in awk script »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Switch to Hybrid Mode Threaded 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 Forum Rules

All times are GMT -4. The time now is 09:15 AM.