[ale] Riddle me this awk man

[Geoffrey Myers]

Greg Freemyer wrote:
> It works in cygwin!!!!!!
> 
> That may be a first for me.  A linux bug that does not exist in the
> cygwin version.
> 
> It might be a awk vs. gawk thing.  I'll worry with it tomorrow.

Then I'd say it's a bug in cygin.

> 
> Thanks for playing
> Greg
> 
> On Thu, Feb 17, 2011 at 8:01 PM, Greg Freemyer <greg.freemyer at gmail.com> wrote:
>> All,
>>
>> I'm trying to re-format the first field of a CSV file using AWK.
>>
>> This is what I'm trying which is very close to working:
>>
>> cat supertimeline.csv | awk -F" " '(NR == 1) {print};(NR > 1) { printf
>> "%s-%s-%s %s", $3,$2,$4,$5; $1=""; $2="";$3="";$4=""; $5=""; print
>> substr($0, 5) }' > mysupertimeline.csv
>>
>> But:
>>
>> # wc supertimeline.csv mysupertimeline.csv
>>   541986   4392932  82668394 supertimeline.csv
>>   174130    702866  23434337 mysupertimeline.csv
>>
>> I end up with only about a third as many lines.  How can that be?  The
>> missing lines seem to be spread around, so it's not like it did the
>> first 174,130 lines and died.
>>
>> I simplified it to:
>>
>> cat supertimeline.csv | awk -F" " ' { printf "%s-%s-%s %s",
>> $3,$2,$4,$5; $1=""; $2="";$3="";$4=""; $5=""; print substr($0, 5) }' >
>> mysupertimeline.csv
>>
>> and I get the same result.  (I have lots of free diskspace, so don't
>> blame that.)
>> Boo Hiss!
>>
>> FYI: this is ubuntu.  I'll try it on cygwin in a second just because I
>> have the csv file there already.
>>
>>
>> --
>> Greg Freemyer
>> Head of EDD Tape Extraction and Processing team
>> Litigation Triage Solutions Specialist
>> http://www.linkedin.com/in/gregfreemyer
>> CNN/TruTV Aired Forensic Imaging Demo -
>>    http://insession.blogs.cnn.com/2010/03/23/how-computer-evidence-gets-retrieved/
>>
>> The Norcross Group
>> The Intersection of Evidence & Technology
>> http://www.norcrossgroup.com
>>
> 
> 
> 


-- 
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson