On Fri, Nov 21, 2008 at 5:06 AM, Scott Raley -ITC wrote: > Anyone familiar with this using activeedit editor in their pages.. I have a > coldfusion application that I didn't write, just supporting it, that uses > this editor and stores in mysql. The editor stores all the html code in the > text. I wrote a cf page with erika's help to extract the information and > strip all the html out and save as a csv file. There are some records which > do not save correctly in the csv file like an extra comma or line break is > showing up to make the text start a new line but opening in notepad it shows > no space, html, br or anything. I posted to active edit and someone > suggested using ODQL to pull the data? I searched and all I can find on the > internet is what this acronym stands for (Object Database Query Language). > Anyone here have suggested about what is going on with activeedit or my sql > pull or what ODQL is?
Dunno about ODQL, but I've got some code I use to "fix" some of the most horrible CSV files I've ever seen. You might think about A) looking a the text in a hex editor, so you can really see what's there, and b) using some type of regex to strip out unwanted trash. I can send you the viable chunks out of my CSV fixer, if you'd like, but I don't know how much that would really help. :-/ Force be with you, esse! -- The ultimate value of life depends upon awareness and the power of contemplation rather than upon mere survival. Aristotle ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:281061 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
