DINIT27D.m

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 ---DINIT27D   1761     printed  Apr 09, 2024@21:50:49                                                                                                                                                                                                    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.