replacing data in SQL server
I have multiple tables with corrupted data like this:
Good data</title>and some random HTML<p></p><
What I would like to do is only keep "Good data" in the cell and remove
everything else. I thought I can just create a small project with EF and
clean the db with C# but there might be a quicker solution with SQL only?
Can you use regex or some kind of substring function in SQL?
I will manually look at the table and select the field that needs to run
through the code, there is no need to automate that at this point.
Thank you
No comments:
Post a Comment