Thanks Tim and everyone. That post really helpful and cflib UDF looks like a solution.
-A >Qasim, > >> listtoarray(replace(list, '||', '| |', 'All'), '|') > >This wouldn't work because there is actually an empty element *before* >the "153564587" item -- your code only replaces empty elements in the >middle of the series and would ignore those at the beginning or end. Of >course you could simply add a space at both the beginning and end of the >string before it is parsed, which would get around the problem. > >You still have the slight inconvenience of "empty" elements actually >containing a single space; what happens if one of the elements did >actually contain a single space? You'd have no way of knowing the >difference between the real element and those that have been "padded". > >Tim. > > >-- >------------------------------------------------------- >Badpen Tech - CF and web-tech: http://tech.badpen.com/ >------------------------------------------------------- > RAWNET LTD - independent digital media agency > "We are big, we are funny and we are clever!" > New site launched at http://www.rawnet.com/ >------------------------------------------------------- >This message may contain information which is legally >privileged and/or confidential. If you are not the >intended recipient, you are hereby notified that any >unauthorised disclosure, copying, distribution or use >of this information is strictly prohibited. Such >notification notwithstanding, any comments, opinions, >information or conclusions expressed in this message >are those of the originator, not of rawnet limited, >unless otherwise explicitly and independently indicated >by an authorised representative of rawnet limited. >------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183761 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54