Return to DINIT27E.m CVS log

Up to [Coherent Logic Development] / freem_fileman / USER

Restructure repository

    1: DINIT27E	;SFISC/DPC-FOREIGN FORMAT EXCEL(TAB) ;11/30/92  3:44 PM
    2: 	;;21.0;VA FileMan;;Dec 28, 1994
    3: 	;Per VHA Directive 10-93-142, this routine should not be modified.
    4: 	F I=1:2 S X=$T(ENTRY+I) G:X="" ^DINIT27F S Y=$E($T(ENTRY+I+1),5,999),X=$E(X,4,999),@X=Y
    5: 	Q
    6: ENTRY	;
    7: 	;;^DIST(.44,.005,0)
    8: 	;;=EXCEL (TAB)^009^^^^^^^1^^^1
    9: 	;;^DIST(.44,.005,3,0)
   10: 	;;=^^2^2^2921120^
   11: 	;;^DIST(.44,.005,3,1,0)
   12: 	;;=Format used to export data to EXCEL spreadsheet running on the Macintosh
   13: 	;;^DIST(.44,.005,3,2,0)
   14: 	;;=or under Windows.  A <TAB> is placed between each field's value.
   15: 	;;^DIST(.44,.005,4,0)
   16: 	;;=^^6^6^2921120^^^
   17: 	;;^DIST(.44,.005,4,1,0)
   18: 	;;=Select the Open command on Excel's File menu.  Press the TEXT button and
   19: 	;;^DIST(.44,.005,4,2,0)
   20: 	;;=make sure that the Column Delimiter is set to "TAB."  Select the file.
   21: 	;;^DIST(.44,.005,4,3,0)
   22: 	;;=Each field's values will be imported into columns.
   23: 	;;^DIST(.44,.005,4,4,0)
   24: 	;;=If you are capturing data to make your export file, be sure that the <TAB>
   25: 	;;^DIST(.44,.005,4,5,0)
   26: 	;;=(ASCII value 009) is not converted to spaces by your communications
   27: 	;;^DIST(.44,.005,4,6,0)
   28: 	;;=software.
   29: 	;;^DIST(.44,.005,5,0)
   30: 	;;=^.441^1^1
   31: 	;;^DIST(.44,.005,5,1,0)
   32: 	;;=Tab Delimited
   33: 	;;^DIST(.44,.005,5,1,1,0)
   34: 	;;=^^1^1^2921120^^
   35: 	;;^DIST(.44,.005,5,1,1,1,0)
   36: 	;;=A <TAB> is placed between each field's value.
   37: 	;;^DIST(.44,.005,5,"B","Tab Delimited",1)
   38: 	;;=