Search Results

awk -F, '$6=="" {$6="00"} {print}' infile >newfile

If I read the requirements correctly I think the request was for something more like:
awk -F, '$6 ~ "^[[:blank:]]*$" {$6="00"} {print}' OFS=, infile >newfile

Just an observation: the additional blank char is at position 80, which is the default line width for many programs. Maybe it is just a "line break in disguise" and you could get rid of it by...

Hi, use $( ) instead of ${ } (and use double quotes around $str1)

Maybe with sed:

cut ... | sed 's/ *$//'

Sorry, you may have been too quick while I was editing and re-editing the post. I realised that michaelroxar17's correction didn't actually work and went off to test an alternative (which is in the...