Search for string and convert it to date

Search for string and convert it to date

Hello i have in one table string which looks like this xxxxxxxxx
day.month.year xxxxxxxxx. For date format is not used DD.MM.YYYY but is
used also D.M.YYYY, depends hov many numbers date has. Question is how to
search for string: left max 2 characters before first . then search for
cahracters between . and . and then search for 4 characters after second .
This will by numbers for day, month and year. When this values will be
know then those numbers convert to date. example: text 1.1.2013 text -
find particular numbers and create from this date. I have no possibility
to create separate column with date.
Any suggestion will be mostly welcome