This is an off-the-wall idea: how about substituting the CHR() function for the string?

>>I had to import a text file which has pipes as the delimiter. When I use ...snip
>I've never had success using the | as a delimiter.