Need an easy way to parse records
I have a file with each record having 40 fields and there are 300 records. What I want to to do is parse them out so each field has its own record so I'll end up with 12,000 records. I know I'll need a looping script of some kind but at first blush I can't see an easy way of having the loop hop from field-to-field in each record then, after the last field in the record, go to the next record then start the process again.
Any ideas? TIA for your help!