DINIT27A.m

DINIT27A ;ISCSF/DPC-FOREIGN FORMAT 1-2-3 DATA PARSE ;1/11/93  2:27 PM

 ;;22.0;VA FileMan;;Mar 30, 1999

 ;Per VHA Directive 10-93-142, this routine should not be modified.

 F I=1:2 S X=$T(ENTRY+I) G:X="" ^DINIT27B S Y=$E($T(ENTRY+I+1),5,999),X=$E(X,4,999),@X=Y

 Q

ENTRY ;

 ;;^DIST(.44,.001,0)

 ;;=1-2-3 DATA PARSE^^^^^1^^240^1^^1^1

 ;;^DIST(.44,.001,1)

 ;;=W $$DP123^DDXPLIB(DDXPXTNO)

 ;;^DIST(.44,.001,3,0)

 ;;=^^4^4^2921106^

 ;;^DIST(.44,.001,3,1,0)

 ;;=This format produces fixed length records designed for import into Lotus

 ;;^DIST(.44,.001,3,2,0)

 ;;=1-2-3.  The user is prompted for data types.  A special header is created

 ;;^DIST(.44,.001,3,3,0)

 ;;=that is used by 1-2-3's Data Parser.  The maximum record length is 240

 ;;^DIST(.44,.001,3,4,0)

 ;;=characters.

 ;;^DIST(.44,.001,4,0)

 ;;=^^10^10^2921120^

 ;;^DIST(.44,.001,4,1,0)

 ;;=To import data into 1-2-3 from a file created with this format: 1) Use

 ;;^DIST(.44,.001,4,2,0)

 ;;=File->Import->Text and select the file.  2) The first line of the file

 ;;^DIST(.44,.001,4,3,0)

 ;;=contains the information for the data parser.  You must change this from a

 ;;^DIST(.44,.001,4,4,0)

 ;;=label, preceded by ', to a format, preceded by ||.  Edit the line to make

 ;;^DIST(.44,.001,4,5,0)

 ;;=this change.  3) Use Data->Parse.  The Input Column range should include

 ;;^DIST(.44,.001,4,6,0)

 ;;=all the imported data, including the format line.  Select a desired Output

 ;;^DIST(.44,.001,4,7,0)

 ;;=Range. Finally, select Go to format the data in the output range. Be sure

 ;;^DIST(.44,.001,4,8,0)

 ;;=your columns are wide enough to hold the data.  NOTE: dates will be

 ;;^DIST(.44,.001,4,9,0)

 ;;=changed into numbers, 1-2-3's internal representation of a date. You can

 ;;^DIST(.44,.001,4,10,0)

 ;;=make the date readable by using Range->Format->Date.

 ;;^DIST(.44,.001,5,0)

 ;;=^.441^1^1

 ;;^DIST(.44,.001,5,1,0)

 ;;=Lotus 1-2-3 Data Parse

 ;;^DIST(.44,.001,5,"B","Lotus 1-2-3 Data Parse",1)

 ;;=

 ;;^DIST(.44,.001,6)

 ;;=S Y=$E(X,6,7)_"-"_$P("JAN^FEB^MAR^APR^MAY^JUN^JUL^AUG^SEP^OCT^NOV^DEC",U,+$E(X,4,5))_"-"_$E(X,2,3) S:$E(X)'=2 Y="NOT 1900s"

DINIT27A  ;ISCSF/DPC-FOREIGN FORMAT 1-2-3 DATA PARSE ;1/11/93  2:27 PM

 +1       ;;22.0;VA FileMan;;Mar 30, 1999

 +2       ;Per VHA Directive 10-93-142, this routine should not be modified.

 +3        FOR I=1:2

               SET X=$TEXT(ENTRY+I)

               IF X=""

                   GOTO ^DINIT27B

               SET Y=$EXTRACT($TEXT(ENTRY+I+1),5,999)

               SET X=$EXTRACT(X,4,999)

               SET @X=Y

 +4        QUIT 

ENTRY     ;

 +1       ;;^DIST(.44,.001,0)

 +2       ;;=1-2-3 DATA PARSE^^^^^1^^240^1^^1^1

 +3       ;;^DIST(.44,.001,1)

 +4       ;;=W $$DP123^DDXPLIB(DDXPXTNO)

 +5       ;;^DIST(.44,.001,3,0)

 +6       ;;=^^4^4^2921106^

 +7       ;;^DIST(.44,.001,3,1,0)

 +8       ;;=This format produces fixed length records designed for import into Lotus

 +9       ;;^DIST(.44,.001,3,2,0)

 +10      ;;=1-2-3.  The user is prompted for data types.  A special header is created

 +11      ;;^DIST(.44,.001,3,3,0)

 +12      ;;=that is used by 1-2-3's Data Parser.  The maximum record length is 240

 +13      ;;^DIST(.44,.001,3,4,0)

 +14      ;;=characters.

 +15      ;;^DIST(.44,.001,4,0)

 +16      ;;=^^10^10^2921120^

 +17      ;;^DIST(.44,.001,4,1,0)

 +18      ;;=To import data into 1-2-3 from a file created with this format: 1) Use

 +19      ;;^DIST(.44,.001,4,2,0)

 +20      ;;=File->Import->Text and select the file.  2) The first line of the file

 +21      ;;^DIST(.44,.001,4,3,0)

 +22      ;;=contains the information for the data parser.  You must change this from a

 +23      ;;^DIST(.44,.001,4,4,0)

 +24      ;;=label, preceded by ', to a format, preceded by ||.  Edit the line to make

 +25      ;;^DIST(.44,.001,4,5,0)

 +26      ;;=this change.  3) Use Data->Parse.  The Input Column range should include

 +27      ;;^DIST(.44,.001,4,6,0)

 +28      ;;=all the imported data, including the format line.  Select a desired Output

 +29      ;;^DIST(.44,.001,4,7,0)

 +30      ;;=Range. Finally, select Go to format the data in the output range. Be sure

 +31      ;;^DIST(.44,.001,4,8,0)

 +32      ;;=your columns are wide enough to hold the data.  NOTE: dates will be

 +33      ;;^DIST(.44,.001,4,9,0)

 +34      ;;=changed into numbers, 1-2-3's internal representation of a date. You can

 +35      ;;^DIST(.44,.001,4,10,0)

 +36      ;;=make the date readable by using Range->Format->Date.

 +37      ;;^DIST(.44,.001,5,0)

 +38      ;;=^.441^1^1

 +39      ;;^DIST(.44,.001,5,1,0)

 +40      ;;=Lotus 1-2-3 Data Parse

 +41      ;;^DIST(.44,.001,5,"B","Lotus 1-2-3 Data Parse",1)

 +42      ;;=

 +43      ;;^DIST(.44,.001,6)

 +44      ;;=S Y=$E(X,6,7)_"-"_$P("JAN^FEB^MAR^APR^MAY^JUN^JUL^AUG^SEP^OCT^NOV^DEC",U,+$E(X,4,5))_"-"_$E(X,2,3) S:$E(X)'=2 Y="NOT 1900s"