[SOLVED] Help using awk,sed and grep

colucix · 07-07-2010, 06:57 PM

Quote:

Originally Posted by shakes82

I am getting a space after each ','

There is a typo in the pixellany's code:

Code:

-e 's/ /, /g'

should be

Code:

-e 's/ /,/g'

anyway, at this point you could try to figure it out, if you understand what these sed and awk statements do exactly. A little advice: pay always attention to the suggested code before actually run it and read carefully the related documentation to fully understand the algorithms. You can safely trust code posted by pixellany, druuna or me and many many other members here at LQ... but you never know!

Edit: ...and many many other members... grail being one of them.

shakes82 · 07-07-2010, 07:08 PM

Thanks grail. I understand what you are saying and I will learn this soon. I just needed to complete this work that is why needed help. Very soon I will be answering to questions on this forum.
I tried colucix command but it is giving me an error:
awk: ^syntax error. I copied the exact command. Please help. Thanks

shakes82 · 07-07-2010, 07:14 PM

Thanks everyone for your time and help. I have got the solution. Colucix, as I told grail....very soon you will find me answering to queries from newbies. I just needed to get this work done soon. Thanks again.

grail · 07-07-2010, 07:49 PM

Well just something to cut your teeth on later, the following should be good for both formats you have shown us:

Code:

awk -F"[ /]" 'gsub(/:/,"");if(NF==4){var=$1;d=2}else var="20"$3 $1 $2;print var $(4-d),$(5-d),$(6-d),"SYM"}' OFS="," inputfile > outputfile

shakes82 · 07-07-2010, 11:12 PM

thanks grail!!!!!