Superscript does not stay after merging

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard - 07 Apr 2004 23:29 GMT

I am using MS Word 2002 SP3 to merge data.

However, none of the superscripting formatting moves from the data field to
the merged documents.

For example if I have a field with 12th day of April 2004, the "th" would be
superscripted in the data field.

When I merge the data the "th" would not be superscripted in the merged
document, it would be just a regular "th". (It still is superscripted in
the data file) All other superscripts that I have manually entered into the
merged document stays superscripted. Even after I have corrected the
superscripting, if I close the document and re-enter, I must correct all of
the superscripts in the merged fields.

Please let me know how I can keep the superscripts "up high" after a merge.

Yours truly,

Richard

Reply to this Message

macropod - 08 Apr 2004 07:05 GMT

Hi Richard,

If you can re-format your data source to hold the dates in a simple
dd/MM/yyyy format, the following mergefield code should achieve what you're
after:

{QUOTE{SET Data{MERGEFIELD MergeDate}}{Data \@ d}{IF{=(mod({Data \@
d},10)<4)*(mod({Data \@ d},10)<>0)*({Data \@ d}<>11)*({Data \@
d}<>12)*({Data \@ d}<>13)}= 1 {=mod({Data \@ d},10)-2 \# rd;st;nd} th}" of
"{Data \@ "MMMM yyyy"}}

The trick is to superscript the "rd;st;nd" string and the "th" near the end
of the field.

Cheers
PS: Note that the field braces '{}' are all entered in pairs via Ctrl-F9.

> I am using MS Word 2002 SP3 to merge data.
>
[quoted text clipped - 16 lines]
>
> Richard

Reply to this Message

Richard - 08 Apr 2004 18:58 GMT

Thank you very much for the response.

Unfortunately, it does not appear to work. I copied the mergefield code
into the document after using ALT-F9 to view the codes. Changed the Data
Column to MergeDate and changed the date to dd/mm/yyyy. When I switch back,
nothing appears in the location.

I thought maybe it was the spacing, i.e. I tried inserting a space between
QUOTE and { but I then get the error message Error! Too many picture
switches defined.

Using just the merge code { MERGEFIELD MergeDate } it shows 8/04/2004

Did you get the code to work for you? Any idea what I am doing wrong?

Yours truly,

Richard

the following mergefield code should achieve what you're after:

> {QUOTE{SET Data{MERGEFIELD MergeDate}}{Data \@ d}{IF{=(mod({Data \@
> d},10)<4)*(mod({Data \@ d},10)<>0)*({Data \@ d}<>11)*({Data \@
> d}<>12)*({Data \@ d}<>13)}= 1 {=mod({Data \@ d},10)-2 \# rd;st;nd} th}" of
> "{Data \@ "MMMM yyyy"}}

Reply to this Message

macropod - 09 Apr 2004 11:09 GMT

Hi Richard,

I should have included '=' signs before each 'Data' ref after the SET field,
as in:

{QUOTE{SET Data{MERGEFIELD MergeDate}}{=Data \@ d}{IF{=(mod({=Data \@
d},10)<4)*(mod({=Data \@ d},10)<>0)*({=Data \@ d}<>11)*({=Data \@
d}<>12)*({=Data \@ d}<>13)}= 1 {=mod("{=Data \@ d},10)-2 \# rd;st;nd} th}"
of "{=Data \@ "MMMM yyyy"}}

Cheers

Reply to this Message

macropod - 10 Apr 2004 06:38 GMT

Hi Richard,

Seems the last solution insists on inserting today's date. Try:

{QUOTE{MERGEFIELD MergeDate \@ d}{IF{=(mod({MERGEFIELD MergeDate \@
d},10)<4)*(mod({MERGEFIELD MergeDate \@ d},10)<>0)*({ MERGEFIELD MergeDate
\@ d}<>11)*({ MERGEFIELD MergeDate \@ d}<>12)*({ MERGEFIELD MergeDate \@
d}<>13)}= 1 {=mod({MERGEFIELD MergeDate \@ d},10)-2 \# rd;st;nd} th}" of
"{MERGEFIELD MergeDate \@ "MMMM yyyy"}}

instead.

Cheers

> Thank you very much for the response.
>
[quoted text clipped - 21 lines]
> > d}<>12)*({Data \@ d}<>13)}= 1 {=mod({Data \@ d},10)-2 \# rd;st;nd} th}" of
> > "{Data \@ "MMMM yyyy"}}

Reply to this Message

Richard - 10 Apr 2004 20:43 GMT

The final solution does work.

Thank you for your help.

Yours truly,

Richard

> Hi Richard,
>
[quoted text clipped - 42 lines]
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.627 / Virus Database: 402 - Release Date: 16/03/2004

Reply to this Message