Rick, #replace(stringVar, '\', '/', 'all')#
should give you the string as you need it, though I'd be more worried about why the \'s are being deleted during whatever operation you're trying to perform. - Gabriel -----Original Message----- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, 10 June 2009 1:45 PM To: cf-talk Subject: How can I make this work with expandPath? Hi, all... I'm running a query that uses load data infile 'd:/inetpub/webroot/real_estate_data/smlc/daily_downloads/text_files/#today# /#name#' The "/" have to be backwards to work in this case. If they are turned around as "\" in the path, they get deleted in the translation...haven't figured that one out... Anyway, I wanted to use: load data infile "#expandPath('/real_estate_data/smlc/daily_downloads/text_files/#today#/#nam e#')#" That works except for the fact that all the "/" get translated into "\" by expandPath and then are deleted from the resulting path, leaving it invalid. How can I code this to make it work with expandPath? Nothing I've tried causes a correct path to be translated by CF. Thanks for any feedback... Rick ---------------------------------------------------------------------------- ------------------------------------------------------------ *"Ninety percent of the politicians give the other ten percent a bad reputation."* Henry Kissinger ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323316 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
