Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 04, 2013 01:34 AM by oned_gk
Jan 03, 2013 10:05 PM|LINK
I have about 200,000 records (rtf formatted text) in sql server databse that I have to convert to either html or plain text. I have been searching for some instructions for the last couple of days but can't find anything. One article mentioned that using
RichText control is a possible solution but no further mention was provided.
I have tried using regex, search and replace and various forms of sql, none of which are viable solutions. I am at my wits end. There has got to be a way to do this. Do you have any suggestions?
Jan 03, 2013 10:11 PM|LINK
check it here
Jan 03, 2013 11:00 PM|LINK
I have data i the database, not files on the file system...
Jan 03, 2013 11:33 PM|LINK
I don't think there is a sql command for that. You have to retrieve each of the items from the database and then re-save it. You should be able to write a .net application that retrieves the item, runs the formatting code, and saves it back in the database.
Jan 04, 2013 01:34 AM|LINK