Removing space for a merge field

B

Bob Reynolds

hello,
I have the following formatting in a merge field in WORD.

{ IF { MERGEFIELD "ERSAL" } <>"" "{ MERGEFIELD "ERSAL" }" "" \*
MERGEFORMAT }

The display is now
First Name

I want it to be
First Name

What I am trying to do is remove the space that is associated with this
merge field if it is blank in the data source.
Right now if the field is blank, a space shows up.

How can I eliminate the space as the one above doesn't work?

Thanks
BOB REYNOLDS
 
G

Graham Mayor

You have a space in plain text in the merge document. Move this space into
the field result
eg
{IF{Mergefield ERSAL} <> "" " {Mergefield ERSAL}"}
ie
{IF{Mergefield ERSAL} <> "" "[space]{Mergefield ERSAL}"}

Thus the space is placed when the field has content.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
 
B

Bob Reynolds

So simple, Thanks so much

Bob


Graham Mayor said:
You have a space in plain text in the merge document. Move this space into
the field result
eg
{IF{Mergefield ERSAL} <> "" " {Mergefield ERSAL}"}
ie
{IF{Mergefield ERSAL} <> "" "[space]{Mergefield ERSAL}"}

Thus the space is placed when the field has content.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



Bob said:
hello,
I have the following formatting in a merge field in WORD.

{ IF { MERGEFIELD "ERSAL" } <>"" "{ MERGEFIELD "ERSAL" }" "" \*
MERGEFORMAT }

The display is now
First Name

I want it to be
First Name

What I am trying to do is remove the space that is associated with
this merge field if it is blank in the data source.
Right now if the field is blank, a space shows up.

How can I eliminate the space as the one above doesn't work?

Thanks
BOB REYNOLDS
 
G

Graham Mayor

You are welcome :)

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



Bob said:
So simple, Thanks so much

Bob


Graham Mayor said:
You have a space in plain text in the merge document. Move this
space into the field result
eg
{IF{Mergefield ERSAL} <> "" " {Mergefield ERSAL}"}
ie
{IF{Mergefield ERSAL} <> "" "[space]{Mergefield ERSAL}"}

Thus the space is placed when the field has content.

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



Bob said:
hello,
I have the following formatting in a merge field in WORD.

{ IF { MERGEFIELD "ERSAL" } <>"" "{ MERGEFIELD "ERSAL" }" "" \*
MERGEFORMAT }

The display is now
First Name

I want it to be
First Name

What I am trying to do is remove the space that is associated with
this merge field if it is blank in the data source.
Right now if the field is blank, a space shows up.

How can I eliminate the space as the one above doesn't work?

Thanks
BOB REYNOLDS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top