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

[Fred Finken]

Using version 7.01, I get identical results with output to the screen when using either delimiter. Could it be that whatever you're using to view the results is causing a new line on pipes?

Fred Finken
IS Team Lead, Order Entry

Masco Cabinetry
fred.finken at mascocabinetry.com
15535 South State Ave. 
Middlefield, OH  44062 
tel        440.632.2491
cell      440.227.5907
fax       440.632.0497
KraftMaid® | Merillat®  | Quality Cabinets® | DENOVA®
 Please consider the environment before printing this e-mail

-----Original Message-----
From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Vincent Cocco
Sent: Tuesday, February 15, 2011 10:42 AM
To: Cedarville DOWNLOAD Users
Subject: [Download-List] Problems with the '|' delimiter?

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






_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list