[Download-List] Problems with the '|' delimiter?

[Vincent Cocco]

Good Morning All,

Are there any know issues using the '|' (pipe) delimiter in a DOWNLOAD query?

This query seems to work - using the '@' as a delimiter:

PA
*ACTIVITY INFORMATION*
**********************
DELETE ADVIZOR ADVIZOR_ACTIVITY
SELECT ACTIVITY
DOWNLOAD ACTIVITY\
ACTIVITY.ID\
ACTIVITY.NAME\
ACTIVITY.TYPE\
ACTIVITY.DATE\
ACTIVITY.PURPOSE\
ACTIVITY.INVITEE.COUNT\
ACTIVITY.CONFIRMEE.COUNT\
ACTIVITY.ATTENDEE.COUNT COMMA.CHAR "@" \
FILE ADVIZOR ADVIZOR_ACTIVITY OVERWRITING 


However changing COMMA.CHAR to use '|' causes each field in the file to be on a separate line.

Any help would be appreciated.


=======================
Vincent Cocco
ERP Application Developer II
Berklee College of Music
MS-186-ES
Boston, MA  02215

617-747-2704
vcocco at berklee.edu