AnsweredAssumed Answered

Need an easy way to parse records

Question asked by WF7A on Aug 18, 2014
Latest reply on Aug 19, 2014 by WF7A


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!