Well it almost worked. The problem I'm having is that some of the data wraps around multiple lines and for them it's pulling blanks. The 3rd and 5th lines in the sample text show the problem. I need the 5th field and on alot of the records it's just not there. The only things I can figure out to tell it it's a multiple line record require the same character in the first position of a line. Any ideas? ^
856^18530001~BSN^14^486165^040927^181323^0004~NTE^856^18530002~BSN^14^486399^040927^181323^0004~NTE^
856^18
856^18530004~BSN^14^489012^040927^181323^0004~NTE^
856^18530005~BSN^1
856^18540001~BSN^14^488594^040927^181941^0004~NTE^
856^18540002~BSN^14^489016^040927^181941^0004~NTE^
856^18550001~BSN^14^488567^040927^182539^0004~NTE^
856^18550002~BSN^14^489102^040927^182539^0004~NTE^
856^18560001~BSN^14^484633^040927^183156^0004~NTE^