<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1276" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=817151120-18112003><FONT face=Arial color=#0000ff size=2>In
this case, you may want to explore the MV.ORIENTATION VERTICAL
option.</FONT></SPAN></DIV>
<DIV><SPAN class=817151120-18112003></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Keith Johnson
[mailto:KJohnson@lcsc.edu] <BR><B>Sent:</B> Tuesday, November 18, 2003 3:00
PM<BR><B>To:</B> download-list@cedarville.edu<BR><B>Subject:</B> [Download-List]
RE: repeating data question (by.exp)<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P align=left><SPAN lang=en-us><FONT face=Arial
color=#0000ff>PS</FONT></SPAN><SPAN lang=en-us><FONT face=Arial
color=#0000ff>:</FONT></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>Does anyone know
how to use download BY.EXP but suppress the repeated</FONT></SPAN><SPAN
lang=en-us> <FONT face=Arial color=#0000ff>non</FONT></SPAN><SPAN
lang=en-us><FONT face=Arial color=#0000ff>-</FONT></SPAN><SPAN lang=en-us><FONT
face=Arial color=#0000ff>multivalue data?</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial
color=#0000ff>Example:</FONT></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial
size=2>
PU.ADMIN
</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>Amy A. Mayer, IT staff
DG95 </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>Amy A. Mayer, IT staff
DG96 </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>Bev D. Hill
ST.ADMIN.CNIN </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>Bev D. Hill
BUD.ADMIN.2 </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>Bev D. Hill
GL.ADMIN </FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>Bev D. Hill
AP.ADMIN </FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>Would look like
this:</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial
size=2>
PU.ADMIN
</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>Amy A. Mayer, IT staff
DG95 </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>
DG96 </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>Bev D. Hill
ST.ADMIN.CNIN </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>
BUD.ADMIN.2 </FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial
size=2>
GL.ADMIN </FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us><FONT face=Arial size=2>
AP.ADMIN </FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>If it helps this
is my base work...</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>SSELECT UT.OPERS
BY SYS.USER.NAME WITH SYS.USER.CLASSES LIKE ...ADMIN... OR WITH SYS.USER.CLASSES
LIKE ''</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>DOWNLOAD UT.OPERS
\</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>@ID COL.HDG
"Datatel loginID"\</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>SYS.USER.NAME
COL.HDG "User Name" \</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>EVAL "IF
SYS.USER.CLASSES EQ '' THEN 'Power' ELSE ''" COL.HDG "Power User; All Screens
except Privileged (Admin)" \</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>BY.EXP
SYS.USER.CLASSES SYS.USER.CLASSES \</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>HEADING
FIELD.NAMES @DATE CONV "D4/" \</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>FILE _HOLD_
UT.OPERS.HTM FORMAT HTML OVERWRITING</FONT></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>Or
this:</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>SSELECT UT.OPERS
BY SYS.USER.NAME WITH SYS.USER.CLASSES LIKE ...ADMIN... OR WITH SYS.USER.CLASSES
LIKE ''</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>DOWNLOAD UT.OPERS
\</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>@ID COL.HDG
"Datatel loginID"\</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>SYS.USER.NAME
COL.HDG "User Name" \</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>EVAL "IF
SYS.USER.CLASSES EQ '' THEN 'Power' ELSE ''" COL.HDG "Power User; All Screens
except Privileged (Admin)" \</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial
color=#0000ff>SYS.USER.CLASSES</FONT></SPAN><SPAN lang=en-us> <FONT face=Arial
color=#0000ff>NUM.VALUES ALL</FONT></SPAN><SPAN lang=en-us><FONT face=Arial
color=#0000ff>\</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>HEADING
FIELD.NAMES @DATE CONV "D4/" \</FONT></SPAN></P>
<P align=left><SPAN lang=en-us><FONT face=Arial color=#0000ff>FILE _HOLD_
UT.OPERS.HTM FORMAT HTML OVERWRITING</FONT></SPAN><SPAN lang=en-us></SPAN></P>
<P align=left><SPAN lang=en></SPAN><A name=""><SPAN lang=en><FONT face=Arial
color=#0000ff>Keith Johnson</FONT></SPAN></A></P>
<P align=left><SPAN lang=en><FONT face=Arial color=#0000ff>UNIX Systems
Administrator
</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en> <FONT face=Arial
color=#0000ff size=1>Programmer / Analyst</FONT></SPAN></P>
<P align=left><SPAN lang=en><FONT face=Arial color=#0000ff>Lewis-Clark State
College</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en>
<FONT face=Arial
color=#0000ff>208.792.2510</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en></SPAN></P>
<P align=left><SPAN lang=en-us></SPAN></P></BODY></HTML>