[Download-List] Field delimiters

[Brich, Richard W]

THIS WORK FOR YOU sHAWN?
:SELECT PERSON SAMPLE 5

 

5 records selected to list 0.

 

>DOWNLOAD PERSON LAST.NAME LITERAL "<+>" FIRST.NAME FORMAT FIXED

DOWNLOAD version 7.00

Using input file PERSON

Output to screen

 

Md                                                       <+>Anisur

 

Johnson                                                  <+>Joshua

 

Chuang                                                   <+>Shu-Hao

 

Zhang                                                    <+>Xuesong

 

Demarco                                                  <+>Jeff


-----Original Message-----
From: download-list-admin at cedarville.edu
[mailto:download-list-admin at cedarville.edu]On Behalf Of Maggie Steyn
Sent: Monday, March 01, 2004 10:34 AM
To: 'download-list at cedarville.edu'
Subject: RE: [Download-List] Field delimiters


I tried + on its own and that worked OK. I think it is limiting the
separator to one character, contrary to Page 38 of the manual.

Maggie Steyn
Application Analyst
Information Technology Department
Niagara University
msteyn at niagara.edu
Phone: (716) 286-8651
Fax: (716) 286-8045 
 

-----Original Message-----
From: Pat Minatra (DataTel) [mailto:minatrae at hsutx.edu] 
Sent: Monday, March 01, 2004 12:28 PM
To: download-list at cedarville.edu
Subject: RE: [Download-List] Field delimiters


I'm thinking that the + is a reserved character?  Could be wrong though as I
have not had a chance to try it out.

-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor" "sorrow looks back - worry looks around -
faith looks up" Regards, Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University  
www.hsutx.edu
PO BOX 16040
Abilene, TX  79698


-----Original Message-----
From: download-list-admin at cedarville.edu
[mailto:download-list-admin at cedarville.edu] On Behalf Of Shawn Waldie
Sent: Monday, March 01, 2004 11:17 AM
To: 'download-list at cedarville.edu'
Subject: RE: [Download-List] Field delimiters


Well, part of it is 'fixed'.
The following:

field1<field2<field3<field4<field5

was produced by ...

DOWNLOAD file \
  FILE _HOLD_ hold.item \
  COMMA.CHAR "<+>" QUOTE.CHAR "" \
  OVERWRITING \
 DETAIL \
  field1 \
  field2 \
  field3 \
  field4 \
  field5


Page 38 of DOWNLOAD.pdf says that ... The value specified by COMMA.CHAR does
not have to be a single character. The following is an acceptable use of
COMMA.CHAR:	DOWNLOAD CUSTOMERS NAME PHONE \
	
COMMA.CHAR
"<_>"

... so I'm not sure why my syntax isn't working.  Are '+>' reserved for
something else? Anyone want to venture a guess?



-----Original Message-----
From: Shawn Waldie 
Sent: Thursday, February 26, 2004 1:57 PM
To: 'download-list at cedarville.edu'
Subject: RE: [Download-List] Field delimiters


Actually, this isn't working for me either. It gives me the following:

"field1"<"field2"<"field3"<"field4"<"field5"

What I would like to see is:

field1<+>field2<+>field3<+>field4<+>field5
_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list
_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list
_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list