Removing dates from within a text fields
Posted on 2013-06-12
I have a text field with free entry text in it. Within this text it may have something like:
;my it was such a great day on 4/4/2011, I wish all days were like this...
The formats of the dates vary, 04/04/2011 instead of 4/4/2011, the dates themselves also vary.
I also have things like 1/2 the day was great, and I need to keep the 1/2 and not confuse it with a date.
I am open to doing this in something other than tsql.