Shell Programming and Scripting

Hi,

I have two issues:

I have one file say file1.dat and its over 3GB. It contains pipe delimited fields. The first line in the file is the header field which tells the column names etc. and from second line it's the data fileds with pipe delimited. Something like below:

Col1|Col2|Col3|Col4|....
Aaaa|wok|dasd|wsd....
Bbbb|cube|daer|fsdfsd...



1st issue: How can I change all the data value in second column to "HARD". I do not want to change the header. The modified version needs to go to a new file FILE2.DAT and the data in new file should not get effected in the original file.

2nd issue: How can I change the data value in second field that contains "wok" to WORK.I do not want to change the header. The modified version needs to go to a new file FILE2.DAT and the data in new file should not get effected in the original file.


Would really appreciate your help.

Thanks

All of it could be easily done with 'awk'.
You've been exposed to the awk solutions for the 4 years that you've been a member of these forums. Give it a try and do come back if/when you get stuck.
Good luck!

Thanks Vgersh99.
I was not working on Unix for quite a few years now but I recently got a job in unix and am having some initial difficulties.
Any help would be appreciated.

Can this not be done through SED.

Thanks

yes, it be done either with awk or sed.
Here's something to start with:

Code:

awk -F'|' 'FNR>1{$2="HARD"}1' OFS='|' myFile

Thanks a ton this seems to work.

Is it possible to add one more logic into this to delete the first line something like SED '1d' without creating another copy of file.

Let say I have a file file1.txt....
Due to space issue, I cannot create another file....I just need to remove the header and run the awk you suggested above and save it.

Thanks again

Code:

awk -F'|' 'FNR>1 && $2="HARD"' OFS='|' myFile