You could use a regular expression: ReReplace(Other_Participants,"\s","","all")
> From: Tim Claremont > > I have a multiselect list box on a flash form, which relays > the IDNo to the submission form. My problem is that the > results that get stored in my table look like this "2001 > ,2004 ," with the extra spaces. I can't seem to use the > Trim function to get rid of them. Any ideas? > > <cfselect name="Other_Participants" > size="6" > width="200" > label="Other Part." > query="ParticipantList" > value="IDNo" > display="FullName" > selected="ClientNum" > visible="Yes" > enabled="Yes" > multiple="Yes"> > <option value="" selected>...</option> > </cfselect> This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. A1. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230855 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
