separating numeric fields

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DeborahKea - 31 May 2006 17:11 GMT

I have several numeric fields that I need to insert into my merge document.
Problem is, I need to separate them, using commas preferably. All letters do
not contain the same number of numeric data, so I will need to suppress blank
data fields. Any help would be greatly appreciated.

Reply to this Message

Doug Robbins - Word MVP - 31 May 2006 18:14 GMT

Use and If...then...Else... field construction.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I have several numeric fields that I need to insert into my merge document.
> Problem is, I need to separate them, using commas preferably. All letters
> do
> not contain the same number of numeric data, so I will need to suppress
> blank
> data fields. Any help would be greatly appreciated.

Reply to this Message

DeborahKea - 31 May 2006 20:40 GMT

Okay....Where would I find that? As a side note, before XP, I used to be able
to process any mail merge. Now everything requires codes & switches, and I
don't have a clue!!~!

> Use and If...then...Else... field construction.
>
[quoted text clipped - 4 lines]
> > blank
> > data fields. Any help would be greatly appreciated.

Reply to this Message

DeborahKea - 31 May 2006 21:02 GMT

Doug,
I found the If, then, else field merge, but can you explain to me how to
seperate numeric field with commas using this function?

> Use and If...then...Else... field construction.
>
[quoted text clipped - 4 lines]
> > blank
> > data fields. Any help would be greatly appreciated.

Reply to this Message

Doug Robbins - Word MVP - 31 May 2006 22:06 GMT

{ MERGEFIELD Number1}{IF { MERGEFIELD Number2 }<> "" ", { MERGEFIELD
Number2 }" "" }{IF { MERGEFIELD Number3 }<> "" ", { MERGEFIELD Number3 }"
"" } etc.

Use Ctrl+F9 to insert each pair of field delimiters and Alt+F9 to toggle
their display.

Note that this has not changed from earlier versions of Word.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Doug,
> I found the If, then, else field merge, but can you explain to me how to
[quoted text clipped - 10 lines]
>> > blank
>> > data fields. Any help would be greatly appreciated.

Reply to this Message

Graham Mayor - 01 Jun 2006 07:44 GMT

You can actually achieve that with switches, but in both cases there will be
a stray leading comma if the Number1 field is empty eg

{ MERGEFIELD Field1 \# ",0.00;,-0.00"; }{ MERGEFIELD Field2 \# "',
',0.00;', ',-0.00;" }{ MERGEFIELD Field3 \# "', ',0.00;', ',-0.00;" }

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> { MERGEFIELD Number1}{IF { MERGEFIELD Number2 }<> "" ", { MERGEFIELD
> Number2 }" "" }{IF { MERGEFIELD Number3 }<> "" ", { MERGEFIELD
[quoted text clipped - 27 lines]
>>>> suppress blank
>>>> data fields. Any help would be greatly appreciated.

Reply to this Message