The function listFix worked great, thanks to all who replied. Thanks again, - Charles
On 3/24/05 6:38 PM, "Dawson, Michael" <[EMAIL PROTECTED]> wrote: > There is a list fix function on cflib.org. I'm not sure if it will work > with tabs, but I don't see why it should be a problem. > > Without that function, I would loop over the list and replace two > consecutive tabs with a tab followed by a valid value followed by a tab. > Repeat until all doubled-up tabs are fixed. > > You might get this with a regular expression, but not sure if you could > do it in a single operation either. > > If I were doing it and since I have SQL Server at my fingertips, I would > just import the file into a database then do whatever with it. Is that > a possibility or do you need to rely soley on CF? > > M!ke > > -----Original Message----- > From: Charles Heizer [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 24, 2005 7:54 PM > To: CF-Talk > Subject: Tab Separated file help needed ... > > Hello, > I have a tab seperated file wich I'm reading in and I want to know if > there is some way to force a value if one does not exists. So here is a > example of what I have in some cases, I'll use \t as the tab char and \r > as a return. > > Charles \t Heizer \t cheizer \r > \t Smith \t smith1 \r > Tom \t \t tom1 \r > > I would like it to read ... > > Charles \t Heizer \t cheizer \r > NA \t Smith \t smith1 \r > Tom \t NA \t tom1 \r > > Can someone please clue me in on how to do this , if it's possible? > > Thanks, > - Charles > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:200012 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
