- 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 Feb 19, 2025@00:17:17 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.