| [613] | 1 | DINIT27E ;SFISC/DPC-FOREIGN FORMAT EXCEL(TAB) ;11/30/92 3:44 PM
|
|---|
| 2 | ;;22.0;VA FileMan;;Mar 30, 1999
|
|---|
| 3 | ;Per VHA Directive 10-93-142, this routine should not be modified.
|
|---|
| 4 | 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
|
|---|
| 5 | Q
|
|---|
| 6 | ENTRY ;
|
|---|
| 7 | ;;^DIST(.44,.005,0)
|
|---|
| 8 | ;;=EXCEL (TAB)^009^^^^^^^1^^^1
|
|---|
| 9 | ;;^DIST(.44,.005,3,0)
|
|---|
| 10 | ;;=^^2^2^2921120^
|
|---|
| 11 | ;;^DIST(.44,.005,3,1,0)
|
|---|
| 12 | ;;=Format used to export data to EXCEL spreadsheet running on the Macintosh
|
|---|
| 13 | ;;^DIST(.44,.005,3,2,0)
|
|---|
| 14 | ;;=or under Windows. A <TAB> is placed between each field's value.
|
|---|
| 15 | ;;^DIST(.44,.005,4,0)
|
|---|
| 16 | ;;=^^6^6^2921120^^^
|
|---|
| 17 | ;;^DIST(.44,.005,4,1,0)
|
|---|
| 18 | ;;=Select the Open command on Excel's File menu. Press the TEXT button and
|
|---|
| 19 | ;;^DIST(.44,.005,4,2,0)
|
|---|
| 20 | ;;=make sure that the Column Delimiter is set to "TAB." Select the file.
|
|---|
| 21 | ;;^DIST(.44,.005,4,3,0)
|
|---|
| 22 | ;;=Each field's values will be imported into columns.
|
|---|
| 23 | ;;^DIST(.44,.005,4,4,0)
|
|---|
| 24 | ;;=If you are capturing data to make your export file, be sure that the <TAB>
|
|---|
| 25 | ;;^DIST(.44,.005,4,5,0)
|
|---|
| 26 | ;;=(ASCII value 009) is not converted to spaces by your communications
|
|---|
| 27 | ;;^DIST(.44,.005,4,6,0)
|
|---|
| 28 | ;;=software.
|
|---|
| 29 | ;;^DIST(.44,.005,5,0)
|
|---|
| 30 | ;;=^.441^1^1
|
|---|
| 31 | ;;^DIST(.44,.005,5,1,0)
|
|---|
| 32 | ;;=Tab Delimited
|
|---|
| 33 | ;;^DIST(.44,.005,5,1,1,0)
|
|---|
| 34 | ;;=^^1^1^2921120^^
|
|---|
| 35 | ;;^DIST(.44,.005,5,1,1,1,0)
|
|---|
| 36 | ;;=A <TAB> is placed between each field's value.
|
|---|
| 37 | ;;^DIST(.44,.005,5,"B","Tab Delimited",1)
|
|---|
| 38 | ;;=
|
|---|
