Help with Date Format and truncating a field

[mr starface]

After some help with a merge document I am working on, have done some browsing but cant find exactly what I need. The merge is coming straight from an external application so I can only work on the data in Word.



First thing is I have a date field and I would like it to read "1st April 2013" but I cant see how to insert the "st" or "th" after the day number?

Secondly I have some fields that have the text I want but there is some additional text before or after what I need. For example "0123456 - Fred Smith" and all I want is "Fred Smith". Is there a command similar to "LEFT/RIGHT" in Excel I could use?

Thanks for any help