Re: Anyone using 'awk'

In article: <4jr67a$7jr@cssun.mathcs.emory.edu> noel@paragon.ie ("Noel O'Brien") writes: > anybody out there using 'awk' programming language to format data > before loading ? > > I have a text column (char(6)) in an ascii file but need to change > it to a DATE format before loading > > the ascii file holds the column like "020496" , with the quotes AWK is without doubt and above all else, the best thing since sliced bread and then some.. to convert "020496" to "02/04/96" use (assuming the date is in the first field): print substr($1,1,2) "/" substr($1,3,2) "/" substr($1,5,2) If you want any help - email me a copy of what you have and what you want and I may even do it for you ! (I love programming in awk!) -- -- Mike Aubury _\\ /_ O O -----------oOO-U-OOo------------+-----------------------------+ Heisendberg may have been here | mike@aubury.demon.co.uk | --------------------------------+-----------------------------+