Home   Package List   Routine Alphabetical List   Global Alphabetical List   FileMan Files List   FileMan Sub-Files List   Package Component Lists   Package-Namespace Mapping  
Routine: DINIT27E

DINIT27E.m

Go to the documentation of this file.
  1. DINIT27E ;SFISC/DPC-FOREIGN FORMAT EXCEL(TAB) ;11/30/92 3:44 PM
  1. ;;22.2;VA FileMan;;Jan 05, 2016;Build 42
  1. ;;Per VA Directive 6402, this routine should not be modified.
  1. ;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
  1. ;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
  1. ;;Licensed under the terms of the Apache License, Version 2.0.
  1. ;
  1. 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
  1. Q
  1. ENTRY ;
  1. ;;^DIST(.44,.005,0)
  1. ;;=EXCEL (TAB)^009^^^^^^^1^^^1
  1. ;;^DIST(.44,.005,3,0)
  1. ;;=^^2^2^2921120^
  1. ;;^DIST(.44,.005,3,1,0)
  1. ;;=Format used to export data to EXCEL spreadsheet running on the Macintosh
  1. ;;^DIST(.44,.005,3,2,0)
  1. ;;=or under Windows. A <TAB> is placed between each field's value.
  1. ;;^DIST(.44,.005,4,0)
  1. ;;=^^6^6^2921120^^^
  1. ;;^DIST(.44,.005,4,1,0)
  1. ;;=Select the Open command on Excel's File menu. Press the TEXT button and
  1. ;;^DIST(.44,.005,4,2,0)
  1. ;;=make sure that the Column Delimiter is set to "TAB." Select the file.
  1. ;;^DIST(.44,.005,4,3,0)
  1. ;;=Each field's values will be imported into columns.
  1. ;;^DIST(.44,.005,4,4,0)
  1. ;;=If you are capturing data to make your export file, be sure that the <TAB>
  1. ;;^DIST(.44,.005,4,5,0)
  1. ;;=(ASCII value 009) is not converted to spaces by your communications
  1. ;;^DIST(.44,.005,4,6,0)
  1. ;;=software.
  1. ;;^DIST(.44,.005,5,0)
  1. ;;=^.441^1^1
  1. ;;^DIST(.44,.005,5,1,0)
  1. ;;=Tab Delimited
  1. ;;^DIST(.44,.005,5,1,1,0)
  1. ;;=^^1^1^2921120^^
  1. ;;^DIST(.44,.005,5,1,1,1,0)
  1. ;;=A <TAB> is placed between each field's value.
  1. ;;^DIST(.44,.005,5,"B","Tab Delimited",1)
  1. ;;=