Originally Posted by jan61
I'd assume you have a syntax error at another part of your script. Did you try the script without the END section?
The script works fine with the original END loop provided by PTrenholme. Tinkering with it, it appears that when I moved the code around I inadvertently removed some brackets, so the culprit was this part of the line:
(Record[i,"Name"]!="" ? ", " Record[i,"Name"] : "")
Now it runs, but it seems to give me ALL of the fields instead of just the ones I want ($1, $9 split, $10, $11, $12, $13, $14, $15), the Address array element seems to hold the entire rest of the record. Hmm. Not really sure why this is happening. I will continue to tinker.
EDIT: Ah, I think I see why Address contains so much data. The original input file specification has changed, it contains many fields per record but it is still just the fields I mentioned ($1, $9 - 15) that I want, the rest can be ignored. Just noting this as an update to the original problem.