conditional split

braindrain · #1 (**permalink**) 03-07-2006

Hi,

Can someone let me know how I can split a record when it contains a vairable length of fields.

Code:

Line1

field1,field101,field102,field 103,field104

Line 2

field1,field101,field102,field 103,field104,field201,field202,field 203,field204

Line 3
field1,field101,field102,field 103,field104,field201,field202,field 203,field204,field301,field 302,field303,field304

In the above scenario,I wanna blow up individual record for the number of times the field101..field104 or field201...field204 or field 301..304 exists.

So for the above example the expected output would be,

Line 1 would remain as such.

Line 2 would be splitted into 2 where field101,..field104(record1) and field201..field204(record 2)

Line 3 would be splitted into 3 where field101,..field104(record1) ,field201..field204(record 2) and field301..field304(record 3)

Appreciate your inputs.

Thx

vino · #2 (**permalink**) 03-08-2006

For each record, would there be only 4 fields ? Or does that vary. If it varies, then you need to show us what the fields look like.

braindrain · #3 (**permalink**) 03-10-2006

Hi,
There would only four fields for each record split.

futurelet · #4 (**permalink**) 03-10-2006

Code:

ruby -ne 'scan(/([a-z]+ ?(\d)\d*,(?:[a-z]+ ?\2\d*,?)*)/i ).each{|x|
  puts x.first.chomp(",") }' myfile

braindrain · #5 (**permalink**) 03-10-2006

Hi Futurelet,
could you tell me what is this command 'RUBY' ? Is this pearl ?????
Iam looking to acheive this in shell scripting.

gauravgoel · #6 (**permalink**) 03-11-2006

Hi Braindrain,

this will work

Quote:

$ cat f1.txt|awk -F ',' '{
> for(i=1;i<NF;i+=4)
> print $i, $(i+1), $(i+2), $(i+3)
> }'

where f1.txt is ur input file,

Gaurav

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Conditional FTP	Dastard	Shell Programming and Scripting	2	06-21-2008 07:38 AM
conditional email	ricky007	Shell Programming and Scripting	3	03-06-2008 01:38 AM
AWK - conditional cause	Rafael.Buria	Shell Programming and Scripting	2	01-28-2008 01:24 PM
Split a file with no pattern -- Split, Csplit, Awk	madhunk	UNIX for Dummies Questions & Answers	10	12-17-2007 12:57 PM
Conditional Statements	cstovall	Shell Programming and Scripting	1	05-15-2005 05:58 PM

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 Hybrid Mode Switch to Threaded Mode	Rate This Thread:


	Powered by