Hi,
Word fields have no string parsing functions, so you cannot extract "Fred Smith" from "0123456 - Fred Smith". You could use some math functions to extract the "0123456', though.
As for the dates, the following field expresses a mailmerge date in ordinal form, coupled with the day of the week – with narrative text:
{MERGEFIELD MyDate \@ "dddd 'the {MERGEFIELD MyDate \@ d \*Ordinal} of' MMMM, yyyy"}
if you want ehe date ordinals to include superscripting, you can use a field coded as:
{QUOTE{SET MM_Date {MERGEFIELD MyDate}}{MM_Date \@ "dddd 'the' d"}{IF{=(MOD({={MM_Date \@ d}+89},100)>2)*(MOD({={MM_Date \@ d}+9},10)<3)}= 1 {=MOD({MM_Date \@ d},10)-2 \# rd;st;nd} th}{MM_Date \@ "' of' MMMM, yyyy"}}
where the 'rd', 'st', 'nd' and 'th' are all superscripted.
Note: The field brace pairs (ie '{ }') for the above examples are created in the body of the document via Ctrl-F9 (Cmd-F9 on a Mac) - you can't simply type them or copy & paste them from this message.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|