<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.6249.1">
<TITLE>RE: repeating data question (by.exp)</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">PS</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">:</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">Does anyone know how to use download BY.EXP but suppress the repeated</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#0000FF" FACE="Arial">non</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">-</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">multivalue data?</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">Example:</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> 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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial">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 COLOR="#0000FF" FACE="Arial">Would look like this:</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial"> 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 SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial"> DG96 </FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><BR>
</SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"><FONT SIZE=2 FACE="Arial">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 SIZE=2 FACE="Arial"> 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 SIZE=2 FACE="Arial"> 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 SIZE=2 FACE="Arial"> 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 COLOR="#0000FF" FACE="Arial">If it helps this is my base work...</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">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 COLOR="#0000FF" FACE="Arial">DOWNLOAD UT.OPERS \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">@ID COL.HDG "Datatel loginID"\</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">SYS.USER.NAME COL.HDG "User Name" \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">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 COLOR="#0000FF" FACE="Arial">BY.EXP SYS.USER.CLASSES SYS.USER.CLASSES \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">HEADING FIELD.NAMES @DATE CONV "D4/" \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">FILE _HOLD_ UT.OPERS.HTM FORMAT HTML OVERWRITING</FONT></SPAN><SPAN LANG="en-us"></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">Or this:</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">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 COLOR="#0000FF" FACE="Arial">DOWNLOAD UT.OPERS \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">@ID COL.HDG "Datatel loginID"\</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">SYS.USER.NAME COL.HDG "User Name" \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">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 COLOR="#0000FF" FACE="Arial">SYS.USER.CLASSES</FONT></SPAN><SPAN LANG="en-us"> <FONT COLOR="#0000FF" FACE="Arial">NUM.VALUES ALL</FONT></SPAN><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">\</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">HEADING FIELD.NAMES @DATE CONV "D4/" \</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en-us"><FONT COLOR="#0000FF" FACE="Arial">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 COLOR="#0000FF" FACE="Arial">Keith Johnson</FONT></SPAN></A></P>
<P ALIGN=LEFT><SPAN LANG="en"><FONT COLOR="#0000FF" FACE="Arial">UNIX Systems Administrator </FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT COLOR="#0000FF" SIZE=1 FACE="Arial">Programmer / Analyst</FONT></SPAN></P>
<P ALIGN=LEFT><SPAN LANG="en"><FONT COLOR="#0000FF" FACE="Arial">Lewis-Clark State College</FONT></SPAN><SPAN LANG="en-us"></SPAN><SPAN LANG="en"> <FONT COLOR="#0000FF" FACE="Arial">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>