Frosty the Coder
Legendary Poster
Hello list,
We had a requirement to create a non-csv, delimited text file.
We chose the pipe ("|") as it doesn't normally appear in our data.
When we create the file and use VIEW or QUERY to look at it, we see "pipe".
When we use DSPPFM to look at the same data, the delimiter shows as "close bracket".
When the delimited file is sent for outside processing, they see "close bracket".
I could (probably) understand the character changing when viewed from different platforms,
but am baffled as to DSPPFM not showing the same as QUERY.
Any thoughts as to why this is happening?
We had a requirement to create a non-csv, delimited text file.
We chose the pipe ("|") as it doesn't normally appear in our data.
When we create the file and use VIEW or QUERY to look at it, we see "pipe".
When we use DSPPFM to look at the same data, the delimiter shows as "close bracket".
When the delimited file is sent for outside processing, they see "close bracket".
I could (probably) understand the character changing when viewed from different platforms,
but am baffled as to DSPPFM not showing the same as QUERY.
Any thoughts as to why this is happening?