Can you use a UDF for format function? Could you/can you write a UDF that would test for len then trim if len(comumn) gt 65 ?
Maybe you could use two fuctions inside a <cf_DisplayExpressionInList> tag? Mark -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tim Blankenship Sent: Tuesday, October 25, 2005 11:23 AM To: [email protected] Subject: [plum] <cf_displaycoluminlist> formatting Hello all, I want to display the first 65 characters in field if it is defined and if it's length is GTE 66. Here is the basic tag that trims the first 65 <cf_DisplayColumnInList column="NOTE" label="Note" type="text" formatfunction="LEFT([value], '65')"> This works great when the Note has 65 or more characters but bombs if less. Can someone shed some light on the correct syntax ? -- Tim Blankenship [EMAIL PROTECTED] ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm ********************************************************************** ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
