All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Thanks for all who responded. Nothing was working. In case anyone is interested, I changed my data type to SMONEY and it worked. Makes no sense to me whatsoever, but I knew I had a money field that was NIL and working, so on a hunch I changed my computed field to SMONEY and it's beautiful. The FREE data type also worked, but I did not want quotation marks around my field. I had MT looking at this, too. I suppose they'll be surprised with my answer as well! Thanks, Donna Roemer Information Systems Department Deborah Heart and Lung Center 609-893-1200 x4742 [EMAIL PROTECTED] -----Original Message----- From: Stewart, Donald [mailto:[EMAIL PROTECTED] Sent: Thursday, May 04, 2006 2:50 PM To: Roemer Donna, Information Systems Subject: RE: [MEDITECH-L] C/S 5.4, NPR Question, FD 9 Footnote Try this computed field: Edit Field Attributes: xx.mi DAT=FREE JFY=L LEN=1 VAL=IF{(@name#"1 ")'="NMN";""} Donald F. Stewart Sr. Programmer Analyst Upson Regional Medical Center 801 W. Gordon St. Thomaston, GA 30286 (706)647-8111 x1696 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roemer Donna, Information Systems Sent: Wednesday, May 03, 2006 1:17 PM To: [email protected] Subject: [MEDITECH-L] C/S 5.4, NPR Question, FD 9 Footnote All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== I am trying to create a download and I'm using the FD 9 footnote to create a tab delimiter. I have a computed field for middle initial, but when the value is nil, I get weird characters and no delimiter in my download for that field. The odd thing is I have other fields that have a nil value that work fine. I have a LC on D to find the middle initial: LC=IF{FULLNAME%L(FULLNAME,",")^FIRST,FIRST$L(FIRST," ")}^/FIRSTNAME,LC=(FIRST%L(FIRST," "))#0^/MIDINIT,"" Then, my computed field is xx.mid.init DAT=INT LEN=1 VAL=/MIDINIT Any suggestions? When I take the FD footnote out, it works fine, too. Thanks, Donna Roemer Information Systems Department Deborah Heart and Lung Center 609-893-1200 x4742 [EMAIL PROTECTED] ___________________________________________________________________ CONFIDENTIALITY NOTICE: This e-mail and its attachments may contain PRIVILEGED and CONFIDENTIAL INFORMATION and/or PROTECTED PATIENT HEALTH INFORMATION intended solely for the use of Deborah Heart and Lung Center and the recipient(s) named above. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any review, dissemination, distribution, printing, or copying of this e-mail message and/or any attachments is strictly prohibited. If you have received this transmission in error, please notify the sender immediately and permanently delete this e-mail and any attachments. ____________________________________________________________________ _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l -- This message has been scanned by the Securiant SpiderISA for spam and viruses, and is believed to be safe and clean. -- This message has been scanned by the Securiant SpiderISA for spam and viruses, and is believed to be safe and clean. ___________________________________________________________________ CONFIDENTIALITY NOTICE: This e-mail and its attachments may contain PRIVILEGED and CONFIDENTIAL INFORMATION and/or PROTECTED PATIENT HEALTH INFORMATION intended solely for the use of Deborah Heart and Lung Center and the recipient(s) named above. If you are not the intended recipient, or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any review, dissemination, distribution, printing, or copying of this e-mail message and/or any attachments is strictly prohibited. If you have received this transmission in error, please notify the sender immediately and permanently delete this e-mail and any attachments. ____________________________________________________________________ _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
