> Is there a relatively low tech way of converting flat > files delimited with > | into a mysql database? I am on a different host now and > have cold fusion > asp perl and maybe php available.
If you've got coldfusion and a dsn for a mysql database it should just be a matter of figuring out how to parse the text file. Cffile will read the contents of the file into a string and from there you can use #chr(13)##chr(10)# or two line feeds or two carriage returns (dependant on the os on which the file was created) as a list deliminter to get individual lines and of course, your | character to delimit individual cells. Read through the file line by line and cell by cell and insert it into your empty mysql db. hth s. isaac dealey 972-490-6624 new epoch http://www.turnkey.to lead architect, tapestry cms http://products.turnkey.to tapestry api is opensource http://www.turnkey.to/tapi certified advanced coldfusion 5 developer http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
