thanks for the suggestion. hmm...i did not know about ListLen treating consecutive delimiters as one.
what can be used instead to determine how many commas , are in each row? sebastian >cf treats consecutive delimiters as one, and here is a caveat with your >proposed ListLen use: > >if your list = "a,b,c,,,f" then listlen(yourlist) will return 4, not 6. > > >--- >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293772 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

