Annotation of freem_fileman/USER/DINIT27E.m, revision 1.1
1.1 ! snw 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: ;;=
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>