All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ======================================
Renee.... The caculated fields should work for you. Create a calculated field for last name: DAT=FREE JFY=L LEN=13 VAL=%Z.convert.to.mixed.case(@sort.name)#"0," Create a calculated field for first name DAT=FREE JFY=L LEN=12 VAL=%Z.convert.to.mixed.case(@sort.name)#"1,"#"0 " Create a calculated field for middle initial: DAT=FREE JFY=L LEN=2 [EMAIL PROTECTED]"1,"#"1 " Should work fine. Stephen Messersmith Mercy Medical Center, Baltimore -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Renee Rinehart Sent: Thursday, July 20, 2006 3:35 PM To: [email protected] Subject: [MEDITECH-L] Magic npr help with computed field All messages should be posted in plain text. HTML will be converted to attachments. The meditech-l web site is MTUsers.com ====================================== I hope someone can help me with this computed field. I'm attempting to extract an employee's last name in a field and their first name/initial in another field so I can download to a spreadsheet. I did find a KB article that sort of addresses this, but not entirely. I'm writing this in PP.PER. Any help would be appreciated. Renee' Rinehart, HCIS Financial Coordinator Guadalupe Regional Medical Center Seguin, Texas 78155 830-401-7214 [EMAIL PROTECTED] _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l _______________________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
