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

DINIT27D.m

Go to the documentation of this file.
  1. DINIT27D ;SFISC/DPC-FOREIGN FORMAT EXCEL(DATA PARSE) ;11/30/92 3:42 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="" ^DINIT27E S Y=$E($T(ENTRY+I+1),5,999),X=$E(X,4,999),@X=Y
  1. Q
  1. ENTRY ;
  1. ;;^DIST(.44,.004,0)
  1. ;;=EXCEL (DATA PARSE)^^^^^1^^255^1^^^1
  1. ;;^DIST(.44,.004,1)
  1. ;;=W $$DPXCEL^DDXPLIB(DDXPXTNO)
  1. ;;^DIST(.44,.004,3,0)
  1. ;;=^^4^4^2921120^
  1. ;;^DIST(.44,.004,3,1,0)
  1. ;;=Use the EXCEL-DATA PARSE format to export data to the EXCEL spreadsheet
  1. ;;^DIST(.44,.004,3,2,0)
  1. ;;=program running on the Macintosh or under windows. Exported data is fixed
  1. ;;^DIST(.44,.004,3,3,0)
  1. ;;=length. The first line output is a guide for use by EXCEL's Data Parser
  1. ;;^DIST(.44,.004,3,4,0)
  1. ;;=to place data into columns. Maximum record length is 255 characters.
  1. ;;^DIST(.44,.004,4,0)
  1. ;;=^^7^7^2921120^
  1. ;;^DIST(.44,.004,4,1,0)
  1. ;;=To import a file created in this format into Excel, choose the Open
  1. ;;^DIST(.44,.004,4,2,0)
  1. ;;=command on the File menu and select the file. Each record will be put
  1. ;;^DIST(.44,.004,4,3,0)
  1. ;;=into a single cell. Select the column that has the data, including the
  1. ;;^DIST(.44,.004,4,4,0)
  1. ;;=first record which will contain the guide for data parsing. Then, choose
  1. ;;^DIST(.44,.004,4,5,0)
  1. ;;=Parse from the Data menu. Press the GUESS button and then press OK. The
  1. ;;^DIST(.44,.004,4,6,0)
  1. ;;=data will be put into correct columns. You may need to adjust column
  1. ;;^DIST(.44,.004,4,7,0)
  1. ;;=widths.