[MT-L] Custom AP report

[Brian Roberts]

Hello L’ers,         

 

     I have a report in the AP.CHECK dpm that contains a computed field to display the ap.contact.email.address field values.  The problem is that the field has multiple lines and I only want the email address of the 1st line to appear.   Here is my field as it exists now.  How do I adjust the VAL statement to include the email address of the 1^st line only?

 

Computed field name:  xx.email.address

 

Field attributes:

DAT=FREE

JFY=L

LEN=69

VAL=IF{@vendor^MIS.VEN.number,""^MIS.VEN.ap.contact^LINE,

VAL=DO{@Next(MIS.VEN.ap.contact) ""^MIS.VEN.ap.contact.email.seq,

VAL=DO{@Next(MIS.VEN.ap.contact.email.seq) .,

VAL=LINE_" "_...@MIS.VEN.ap.contact.email.address^LINE}},LINE%0}

 

     

 

Brian Roberts          

Financial Applications Specialist

Information Technology Dept

Cambridge Memorial Hospital

Cambridge, Ontario

N1R 3G2

Email address: brob...@cmh.org

Phone number:  519-621-2333 ext. 1491

 

Confidentiality Warning: This message and any attachments are intended only for the use of the intended recipient(s), are confidential, and may be privileged. If you are not the intended recipient, you are hereby notified that any review, retransmission, conversion to hard copy, copying, circulation or other use of this message and any attachments is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, and delete this message and any attachments from your system. Thank you.