DINIT27D ;SFISC/DPC-FOREIGN FORMAT EXCEL(DATA PARSE) ;11/30/92 3:42 PM
;;22.2;VA FileMan;;Jan 05, 2016;Build 42
;;Per VA Directive 6402, this routine should not be modified.
;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
;;Licensed under the terms of the Apache License, Version 2.0.
;
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
Q
ENTRY ;
;;^DIST(.44,.004,0)
;;=EXCEL (DATA PARSE)^^^^^1^^255^1^^^1
;;^DIST(.44,.004,1)
;;=W $$DPXCEL^DDXPLIB(DDXPXTNO)
;;^DIST(.44,.004,3,0)
;;=^^4^4^2921120^
;;^DIST(.44,.004,3,1,0)
;;=Use the EXCEL-DATA PARSE format to export data to the EXCEL spreadsheet
;;^DIST(.44,.004,3,2,0)
;;=program running on the Macintosh or under windows. Exported data is fixed
;;^DIST(.44,.004,3,3,0)
;;=length. The first line output is a guide for use by EXCEL's Data Parser
;;^DIST(.44,.004,3,4,0)
;;=to place data into columns. Maximum record length is 255 characters.
;;^DIST(.44,.004,4,0)
;;=^^7^7^2921120^
;;^DIST(.44,.004,4,1,0)
;;=To import a file created in this format into Excel, choose the Open
;;^DIST(.44,.004,4,2,0)
;;=command on the File menu and select the file. Each record will be put
;;^DIST(.44,.004,4,3,0)
;;=into a single cell. Select the column that has the data, including the
;;^DIST(.44,.004,4,4,0)
;;=first record which will contain the guide for data parsing. Then, choose
;;^DIST(.44,.004,4,5,0)
;;=Parse from the Data menu. Press the GUESS button and then press OK. The
;;^DIST(.44,.004,4,6,0)
;;=data will be put into correct columns. You may need to adjust column
;;^DIST(.44,.004,4,7,0)
;;=widths.
--- Routine Detail --- with STRUCTURED ROUTINE LISTING ---[H[J[2J[HDINIT27D 1761 printed Nov 22, 2024@18:00:59 Page 2
DINIT27D ;SFISC/DPC-FOREIGN FORMAT EXCEL(DATA PARSE) ;11/30/92 3:42 PM
+1 ;;22.2;VA FileMan;;Jan 05, 2016;Build 42
+2 ;;Per VA Directive 6402, this routine should not be modified.
+3 ;;Submitted to OSEHRA 5 January 2015 by the VISTA Expertise Network.
+4 ;;Based on Medsphere Systems Corporation's MSC FileMan 1051.
+5 ;;Licensed under the terms of the Apache License, Version 2.0.
+6 ;
+7 FOR I=1:2
SET X=$TEXT(ENTRY+I)
if X=""
GOTO ^DINIT27E
SET Y=$EXTRACT($TEXT(ENTRY+I+1),5,999)
SET X=$EXTRACT(X,4,999)
SET @X=Y
+8 QUIT
ENTRY ;
+1 ;;^DIST(.44,.004,0)
+2 ;;=EXCEL (DATA PARSE)^^^^^1^^255^1^^^1
+3 ;;^DIST(.44,.004,1)
+4 ;;=W $$DPXCEL^DDXPLIB(DDXPXTNO)
+5 ;;^DIST(.44,.004,3,0)
+6 ;;=^^4^4^2921120^
+7 ;;^DIST(.44,.004,3,1,0)
+8 ;;=Use the EXCEL-DATA PARSE format to export data to the EXCEL spreadsheet
+9 ;;^DIST(.44,.004,3,2,0)
+10 ;;=program running on the Macintosh or under windows. Exported data is fixed
+11 ;;^DIST(.44,.004,3,3,0)
+12 ;;=length. The first line output is a guide for use by EXCEL's Data Parser
+13 ;;^DIST(.44,.004,3,4,0)
+14 ;;=to place data into columns. Maximum record length is 255 characters.
+15 ;;^DIST(.44,.004,4,0)
+16 ;;=^^7^7^2921120^
+17 ;;^DIST(.44,.004,4,1,0)
+18 ;;=To import a file created in this format into Excel, choose the Open
+19 ;;^DIST(.44,.004,4,2,0)
+20 ;;=command on the File menu and select the file. Each record will be put
+21 ;;^DIST(.44,.004,4,3,0)
+22 ;;=into a single cell. Select the column that has the data, including the
+23 ;;^DIST(.44,.004,4,4,0)
+24 ;;=first record which will contain the guide for data parsing. Then, choose
+25 ;;^DIST(.44,.004,4,5,0)
+26 ;;=Parse from the Data menu. Press the GUESS button and then press OK. The
+27 ;;^DIST(.44,.004,4,6,0)
+28 ;;=data will be put into correct columns. You may need to adjust column
+29 ;;^DIST(.44,.004,4,7,0)
+30 ;;=widths.
