[ale] Another Large File/PERL/Awk/Sed question...

JK jknapka at kneuro.net
Tue Dec 1 16:26:53 EST 2009


JK wrote:
> sed -e '0,1 s/column4;column4/column4;column5/' < hugeFile > resultFile


Though, yeah, you probably really want:

sed -i -e '0,1 s/column4;column4/column4;column5/' hugeFile

To make it not take forever.

-- JK


> Bob Kruger wrote:
>> All;
>>
>> Thanks to all who assisted me with my earlier question on deleting the 
>> semicolon from the end of a line.  I have another one that may be a 
>> bit stickier.
>>
>> Again I have a large data file in text format, this one is 3.2GB.  
>> Same as before, the field are semicolon delimited.  The first line of 
>> the file is the column name.  However, I have two columns that were 
>> inadvertently given the same column name. 
>> Example:
>>
>> column1;column2;column3;column4;column4;column6;column7....
>>
>> I would like to change the second instance of column4 to column5 on 
>> the first line of the file.  I thought it would be simple to fire up 
>> vi and just do a simple text edit.  The edit part was simple, but the 
>> saving of the file is taking hours.
>>
>> Any thoughts or ideas using PERL, Awk, or Sed?
>>
>> Thanks in advance for any assistance.
>>
>> V/r
>>
>> Bob
>>
>>
>> _______________________________________________
>> Ale mailing list
>> Ale at ale.org
>> http://mail.ale.org/mailman/listinfo/ale
>> See JOBS, ANNOUNCE and SCHOOLS lists at
>> http://mail.ale.org/mailman/listinfo
>>
>>
> 
> 



More information about the Ale mailing list