Well, we have considered that...this is a text file that needs to get read into a variable either way, slapped into a list or to a query...then have the delim change happen...and then write it to a text file again. So it seems one half of one, one half of the other. At this point putting it into a query with that CSVtoQuery tag over doing a replace or listchangedelim seems as good as anything else, and may give us some other options to add some trinkets from the queried data.
Thanks for all the suggestions...we are running at pell mell speed on this pro-bono site...what else is a Sunday for? Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) -----Original Message----- From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 03, 2002 1:26 PM To: CF-Talk Subject: RE: comma to tab Have you tried something like replace(ListVar, ',', '#Chr(9)#', 'ALL') or ListChangeDelims(ListVar, '#Chr(9)#', ',')? Oh... I'm pulling Chr(9) from memory as the ANSI character for a tab, BTW... That's what I get from making a suggestion from home ;) Good luck! Hatton -----Original Message----- From: Eric J Hoffman [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 03, 2002 2:05 PM To: CF-Talk Subject: comma to tab Is there a custom tag or easy method to take a comma delimited list and convert it to tab delimited...something better and more robust than trying some sort of rereplace madness? I see some in the gallery to output from data queries, but we are merging two comma delim files but the client's client demands tab delimited data returned to them. Quick pointers are appreciated! Regards, Eric J. Hoffman Director of Internet Development DataStream Connexion, LLC (formerly Small Dog Design) ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
