BEGIN { #sql1id = dosql( sql1 ); sql1id = "s1.unl" while ((getline aline < sql1id) > 0) { gsub(/\\\|/, ";",aline) split(aline, sql1arr, "|") f = 0 f1 = sql1arr[++f] f2 = sql1arr[++f] f3 = sql1arr[++f] f4 = sql1arr[++f] f5 = sql1arr[++f] print f1 " " f2 " " f3 " " f4 " " f5 } #closesql(sql1id) }