[vox-tech] Changing data with awk

[Richard Crawford]

I have a large flat file generated by SQL Loader that I'd like to mess
around with; specifically, I'd like to replace all of the carriage returns
in one field with some other character, since they're messing up my data
load.

I figured I'd use awk, since it's a pretty powerful little tool for
getting right to the data.  If I use:

$ awk -F^ {print $6} test.dat

I get the field that I want.  But how do I change the characters in that
field and replace them in test.dat?


-- 
Sláinte,
Richard S. Crawford (AIM: Buffalo2K)
http://www.mossroot.com   http://www.stonegoose.com/catseyeview
"You cannot trust your judgement if your imagination is out of focus." 
--Mark Twain