I tried LEN and LEFT but could not get the syntax correct. using [value] is kind of throwing me on how to use it when calling the functions.
On 10/25/05, Mark Fuqua <[EMAIL PROTECTED]> wrote: > 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 > ********************************************************************** > -- 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 **********************************************************************
