Very Computer

by **sepa** » Fri, 05 Jan 2001 09:38:10

Hello,

I have a data file that contains redundant parts and I wonder whether
spliiting the file based on the data can be done. For example, the input
file looks as follows:

[input file]

45 35 33; 22 56 33; aaa
45 35 33; 22 56 32; aaa
45 35 33; 22 56 33; ddd
45 35 33; 22 56 33; ddd
55 35 33; 22 56 33; eee

What I would like to achieve is to insert a blank line each time the first
six numbers are different from the six numbers of the next line. So, the
output of the above is as follows:

[output file]

45 35 33; 22 56 33; aaa

45 35 33; 22 56 32; aaa

45 35 33; 22 56 33; ddd
45 35 33; 22 56 33; ddd

55 35 33; 22 56 33; eee

Are there Unix commands that can be used for this?

Thank you very much for your time.

Regards,
Seongbin Park

by **Barry Margoli** » Fri, 05 Jan 2001 11:58:45

>Hello,

>I have a data file that contains redundant parts and I wonder whether
>spliiting the file based on the data can be done. For example, the input
>file looks as follows:

>[input file]

>45 35 33; 22 56 33; aaa
>45 35 33; 22 56 32; aaa
>45 35 33; 22 56 33; ddd
>45 35 33; 22 56 33; ddd
>55 35 33; 22 56 33; eee

>What I would like to achieve is to insert a blank line each time the first
>six numbers are different from the six numbers of the next line.

awk '{ new6=$1 $2 $3 $4 $5 $6;
if (NR > 1 && last6 != new6) {print ""};
print; last6=new6 }' inputfile

--

Genuity, Burlington, MA
*** DON'T SEND TECHNICAL QUESTIONS DIRECTLY TO ME, post them to newsgroups.
Please DON'T copy followups to me -- I'll assume it wasn't posted to the group.

by **annel..** » Sat, 06 Jan 2001 10:39:07

>>Hello,

>>I have a data file that contains redundant parts and I wonder whether
>>spliiting the file based on the data can be done. For example, the input
>>file looks as follows:

>>[input file]

>>45 35 33; 22 56 33; aaa
>>45 35 33; 22 56 32; aaa
>>45 35 33; 22 56 33; ddd
>>45 35 33; 22 56 33; ddd
>>55 35 33; 22 56 33; eee

>>What I would like to achieve is to insert a blank line each time the first
>>six numbers are different from the six numbers of the next line.
> awk '{ new6=$1 $2 $3 $4 $5 $6;
> if (NR > 1 && last6 != new6) {print ""};
> print; last6=new6 }' inputfile

If the parts are redundant, uniq will filter out the duplicate lines
for you.

Annelise

- Show quoted text -

> --

> Genuity, Burlington, MA
> *** DON'T SEND TECHNICAL QUESTIONS DIRECTLY TO ME, post them to newsgroups.
> Please DON'T copy followups to me -- I'll assume it wasn't posted to the group.

by **Barry Margoli** » Sun, 07 Jan 2001 01:15:23

>>>Hello,

>>>I have a data file that contains redundant parts and I wonder whether
>>>spliiting the file based on the data can be done. For example, the input
>>>file looks as follows:

>>>[input file]

>>>45 35 33; 22 56 33; aaa
>>>45 35 33; 22 56 32; aaa
>>>45 35 33; 22 56 33; ddd
>>>45 35 33; 22 56 33; ddd
>>>55 35 33; 22 56 33; eee

>>>What I would like to achieve is to insert a blank line each time the first
>>>six numbers are different from the six numbers of the next line.

>> awk '{ new6=$1 $2 $3 $4 $5 $6;
>> if (NR > 1 && last6 != new6) {print ""};
>> print; last6=new6 }' inputfile

>If the parts are redundant, uniq will filter out the duplicate lines
>for you.

That's true, but it's not even close to what he asked for.

--

Genuity, Burlington, MA
*** DON'T SEND TECHNICAL QUESTIONS DIRECTLY TO ME, post them to newsgroups.
Please DON'T copy followups to me -- I'll assume it wasn't posted to the group.

Very Computer

question: Unix commands for splitting a file

question: Unix commands for splitting a file

question: Unix commands for splitting a file

question: Unix commands for splitting a file

question: Unix commands for splitting a file