This is a known issue - I think the workaround is to run a replace on the list before you do listlen - stick a whitespace character in there:
Replace(list,"||","| |","all") Then you can replace it back the way it was after the listlen if you need to. -- Josh ----- Original Message ----- From: "Chad McCue" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, March 29, 2007 12:37 PM Subject: Get the Real list len > This list below really has 20 entries, but when I do a listlen on it, it > returns 19. It doesn't read the NULL value in the second spot > highlighted in red. I am reading a file that is generated from an > outside system, where the administrator does not want change the way it > works. > > 1346||258806|19520722|F|1|2|1|21|0|20050113|1|2|2|1|2|2|3|3|99111 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274125 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
