If you're familiar with how to access java in coldfusion, I've found this library to be very useful when creating "delimited" files.
http://www.csvreader.com/java_csv.php - Gabriel On Sun, Nov 6, 2011 at 1:26 AM, Torrent Girl <[email protected]> wrote: > > >On 11/4/2011 11:39 PM, Torrent Girl wrote: > > > >> the problem is the file will be created on the fly by remote > >users who will import the data and won't have time to manipulate > >it by hand. > > > >Do you need the time? If not, just send the yyyy-mm-dd format > >and see if that will open up automatically in Excel as date. > > > >I don't know a way to specify a date time automatically in Excel > >from a CSV file opening. If someone knows, please let us know. > > > >-- > Thanks I was able to format the data. It works now. > > Any suggestions on creating a TAB file in CF? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:348485 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
