[MEDITECH-L] NPR comma delimited question
Tompkins, Kim
I have put FD 44 in the footnotes of an NPR report
However, this puts the quote marks around the fields.
The program that I need to pull this report into will not accept the quote marks.
Therefore, I found the DAT=INT to remove the quote marks
However, that also removes the formatting from the date field
Is there any way to get a comma delimited report that does not have quotes around the date field, but still have the date formatting?
Kim Tompkins - Information Services
perotsystems® - Supporting Community Health Systems (CHS) Account @ DeTar Hospital
Systems
506 E. San Antonio St.
Victoria, TX 77901
(361)788-6983 office
(361)788-6043 fax
kim.to...@triadhospitals.com
This email and any files transmitted with it may contain PRIVILEGED or CONFIDENTIAL information and may be read or used only by the intended recipient. If you are not the intended recipient of the email or any of its attachments, please be advised that you have received this email in error and that any use, dissemination, distribution, forwarding, printing, or copying of this email or any attached files is strictly prohibited. If you have received this email in error, please immediately purge it and all attachments and notify the sender by reply email or contact the sender at the number listed.
Lawrence, Mitchell
DAT=INT
JFY=L
LEN=8
VAL=%Z.date.out(VALUE)
Thank you,
Mitch Lawrence
Lead Applications Analyst
Technical Support - NPR/Automation
CHRISTUS Information Management
™: Mitchell...@christushealth.org
Send a “thank you” to someone!
Akhtar, Sohail
Hi Kim,
I did following with the help of Mark and the legend Joe Cocuzzo.
Bingo. That did it. I used as follows and it took the “” off of the date. Thanks for your help
DAT=INT
JFY=L
LEN=8
VAL=IF{@dis.date %Z.date.out(@dis.date);%Z.date.out(@bar.dis.ser)}
Sohail Akhtar
Systems Analyst
Jefferson Memorial Hospital
Ph: 304 724-3552
From: Blount, Mark
[mailto:Mark....@waynehealth.org]
Sent: Friday, September 07, 2007
9:51 AM
To: Akhtar,
Sohail
Subject: RE: [MEDITECH-L] NPR
report in C/S
What I know about NPR in C/S would echo in a thimble…does it still put quotes around it if it’s DAT=DATE? I’m thinking anything with a DAT=FREE the report writer will slap quotes around it…
You could try DAT=FREE and VAL=%Z.date.out(@discharge.date)…..
Or DAT=DATE10 ( I think that’s a valid DAT format )
Hey..I just found this from Joe Cocuzzo in my “archive”…
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Change the data type of all your fields that are text to INT.
If you have dates you will need to make them computed fields like this:
xx.reformat.date
DAT=INT
LEN=8
VAL=%Z.date.out(@your.date.field.here)
Meditech automatically uses a quote as a “text qualifier” for non numeric fields when
you use the FD footnote. I am not aware of a easier way to get rid of the text qualifier
than to change data type of all non-numeric fields to a numeric data type.
From:
meditech-...@mtusers.com [mailto:meditech-...@mtusers.com] On Behalf Of Tompkins, Kim
Sent: Friday, September 07, 2007
5:56 PM
To: Medit...@mtusers.com
Subject: [MEDITECH-L] NPR comma
delimited question
I
have put FD 44 in the footnotes of an NPR report
The information contained in this message is confidential and is intended for the addresses only. If you have received this message in error or there are any problems, please notify the sender immediately. The unauthorized use, disclosure, copying, or alteration of this message is strictly forbidden.
Robert White
xx.field.1|xx.field.2|xx.field.3|
In other words, I include the pipe (|) in my layout between each field.
The request for downloads with quotes surrounding each field seem to have totally disappeared. When I do get such requests they are usually these are from companies (or - more frequently - governmental institutions) with archaic technologies.
>>> <meditech-...@mtusers.com> 09/10/07 8:28 AM >>>
Hi Kim,
I did following with the help of Mark and the legend Joe Cocuzzo.
Bingo. That did it. I used as follows and it took the "" off of the
date. Thanks for your help
DAT=INT
JFY=L
LEN=8
VAL=IF{@dis.date %Z.date.out(@dis.date);%Z.date.out(@bar.dis.ser)}
Sohail Akhtar
Systems Analyst
Jefferson Memorial Hospital
Ph: 304 724-3552
sak...@jeffmem.com <mailto:sak...@jeffmem.com>
________________________________
From: Blount, Mark [mailto:Mark....@waynehealth.org]
Sent: Friday, September 07, 2007 9:51 AM
To: Akhtar, Sohail
Subject: RE: [MEDITECH-L] NPR report in C/S
What I know about NPR in C/S would echo in a thimble...does it still put
quotes around it if it's DAT=DATE? I'm thinking anything with a DAT=FREE
the report writer will slap quotes around it...
You could try DAT=FREE and VAL=%Z.date.out(@discharge.date).....
Or DAT=DATE10 ( I think that's a valid DAT format )
Hey..I just found this from Joe Cocuzzo in my "archive"...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
xx.reformat.date
DAT=INT
LEN=8
VAL=%Z.date.out(@your.date.field.here)
perotsystems(r) - Supporting Community Health Systems (CHS) Account @
DeTar Hospital
Systems
506 E. San Antonio St.
Victoria, TX 77901
(361)788-6983 office
(361)788-6043 fax
kim.to...@triadhospitals.com
This email and any files transmitted with it may contain PRIVILEGED or
CONFIDENTIAL information and may be read or used only by the intended
recipient. If you are not the intended recipient of the email or any of
its attachments, please be advised that you have received this email in
error and that any use, dissemination, distribution, forwarding,
printing, or copying of this email or any attached files is strictly
prohibited. If you have received this email in error, please immediately
purge it and all attachments and notify the sender by reply email or
contact the sender at the number listed.
The information contained in this message is confidential and is intended for the addresses only. If you have received this message in error or there are any problems, please notify the sender immediately. The unauthorized use, disclosure, copying, or alteration of this message is strictly forbidden.
=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=*=
To subscribe or unsubscribe to the meditech-l, visit http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com
To check the status of the meditech-l, visit MTUsers.NET
For help, email g...@MTUsers.NET.
Please visit and add information to the MTUsers WikiPedia at MTUsers.NET/mwiki
______________________________________
meditech-l mailing list
medit...@MTUsers.com
http://mtusers.com/mailman/listinfo/meditech-l_mtusers.com