If your have string like this.. (for Example)

Mystr = 4140483656^232#12/10/2005@Credit

Here ^, #, @ are the Sepreators.. and then I can use Mid and Instr functions to get the Strings...!
Lile this..

String1 = Mid(Mystr,1, Instr(1, Mystr,"^")-1) will return 4140483656
String2 = Mid(Mystr, Instr(1, Mystr,"^")+1, Instr(1, Mystr,"#")-1) will return 232
....

and so on.. !

So i advice you to use different seprators instead of single | symbol as it is hard to part it..!