You could try using a replace or rereplace to change multiple spaces into something you can use as a list qualifier in a more direct way. I'm a fan of the bell chr(7) because you can't type it. :-)
You could use replace() and then trim the results to get what you want. This is probably the best solution. You could also do a rereplace() to remove all those extra spaces, but if there are leading or trailing spaces, it would remove them. --BenD Chris Martin wrote: > I'm trying to parse a .txt file using the built-in java reader and have come > across an issue where I need to qualify a list based on multiple spaces on a > line. For instance, > > LANCASTER MS BAND > JAMES GUENGERMAN > > The qualifier will be between "Band" and "James". There are over 10,000 > records that will be read in this method, so there is no set number of spaces > between the two strings. > > Any help is greatly appreciated! > > > > > > > Chris Martin > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287449 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4