fieds formatting issue

[Drew]

All I want to do is format a merge field in a document template to display
only the last 4 digits of a social security number. Sound easy?

It appears that the default behavior of Word makes this extremely difficult,
when, in fact it, should be extremely simple...or maybe I'm just an idiot.

Is there a way to write a field switch to make this happen?

"\# x####" and variations thereof give me a sum.

Thanks.

A

 

[Drew]

OK, I see why it doesn't work like it should and sort of have a solution,
unfortunately, my solution doesn't work.

{Quote
{SET ID {MERGEFILED SSN}}
{SET EXP1{=-{=-{ID}-ID}/2}}
{SET EXP2{=-({ID}*(-1)-{ID})/2}}
{SET EXP3{=-({EXP1}+{EXP2}-{ID})}}"XXX-XX-"{EXP3 \# 0000}}

....works fine, except in the doc that I need it to work. There, it gives me
a syntax error. What am I doing wrong?

 

[Stefan Blom]

I haven't actually tested the code, but I do notice that the example you
posted spells "MERGEFILED" instead of "MERGEFIELD." Could that be the error?

 

[Drew]

No, I had it right in the doc, it just mistyped it in my post. Thanks.

 

[macropod]

Hi Drew,

If your source data is '###-##-####' and is not simply '#########' formatted to look like '###-##-####', try:
{QUOTE
{SET ID {MERGEFIELD SSN}}
{SET EXP{=({ID}*(-1)-ID)/2}}"XXX-XX-"{EXP \# 0000}}

If your source data is '#########' formatted to look like '###-##-####', try:
{=MOD({MERGEFIELD SSN},10000) \# "XXX-XX-0000"}

 

[macropod]

For the second solution, try:
"XXX-XX-{=MOD({MERGEFIELD SSN}, 10000) \# 0000}"

--
Cheers
macropod
[MVP - Microsoft Word]

Hi Drew,

If your source data is '###-##-####' and is not simply '#########' formatted to look like '###-##-####', try:
{QUOTE
{SET ID {MERGEFIELD SSN}}
{SET EXP{=({ID}*(-1)-ID)/2}}"XXX-XX-"{EXP \# 0000}}

If your source data is '#########' formatted to look like '###-##-####', try:
{=MOD({MERGEFIELD SSN},10000) \# "XXX-XX-0000"}

--
Cheers
macropod
[MVP - Microsoft Word]

OK, I see why it doesn't work like it should and sort of have a solution,
unfortunately, my solution doesn't work.

{Quote
{SET ID {MERGEFILED SSN}}
{SET EXP1{=-{=-{ID}-ID}/2}}
{SET EXP2{=-({ID}*(-1)-{ID})/2}}
{SET EXP3{=-({EXP1}+{EXP2}-{ID})}}"XXX-XX-"{EXP3 \# 0000}}

...works fine, except in the doc that I need it to work. There, it gives me
a syntax error. What am I doing wrong?

 

[Drew]

Yay! It works. Thanks a lot!

However...
Same document, similar situation, except that the data I'm merging is both a
name and an SSN. Can I do the same thing with that? I can get the name by
itself from another data source, but not the SSN. Can I format the field to
ignore the name entirely and just format the number?

For the second solution, try:
"XXX-XX-{=MOD({MERGEFIELD SSN}, 10000) \# 0000}"

--
Cheers
macropod
[MVP - Microsoft Word]

Hi Drew,

If your source data is '###-##-####' and is not simply '#########' formatted to look like '###-##-####', try:
{QUOTE
{SET ID {MERGEFIELD SSN}}
{SET EXP{=({ID}*(-1)-ID)/2}}"XXX-XX-"{EXP \# 0000}}

If your source data is '#########' formatted to look like '###-##-####', try:
{=MOD({MERGEFIELD SSN},10000) \# "XXX-XX-0000"}

--
Cheers
macropod
[MVP - Microsoft Word]

OK, I see why it doesn't work like it should and sort of have a solution,
unfortunately, my solution doesn't work.

{Quote
{SET ID {MERGEFILED SSN}}
{SET EXP1{=-{=-{ID}-ID}/2}}
{SET EXP2{=-({ID}*(-1)-{ID})/2}}
{SET EXP3{=-({EXP1}+{EXP2}-{ID})}}"XXX-XX-"{EXP3 \# 0000}}

...works fine, except in the doc that I need it to work. There, it gives me
a syntax error. What am I doing wrong?


:

All I want to do is format a merge field in a document template to display
only the last 4 digits of a social security number. Sound easy?

It appears that the default behavior of Word makes this extremely difficult,
when, in fact it, should be extremely simple...or maybe I'm just an idiot.

Is there a way to write a field switch to make this happen?

"\# x####" and variations thereof give me a sum.

Thanks.

A

 

[Joyce M]

Hello,
You suggested something I would like to try....stupid question, how do you
get this in ...is quote a quote or spelled out word, do you type in set id
etc?

Thanks for any additional guidance you can provide.

joyce

Hi Drew,

If your source data is '###-##-####' and is not simply '#########' formatted to look like '###-##-####', try:
{QUOTE
{SET ID {MERGEFIELD SSN}}
{SET EXP{=({ID}*(-1)-ID)/2}}"XXX-XX-"{EXP \# 0000}}

If your source data is '#########' formatted to look like '###-##-####', try:
{=MOD({MERGEFIELD SSN},10000) \# "XXX-XX-0000"}

--
Cheers
macropod
[MVP - Microsoft Word]

OK, I see why it doesn't work like it should and sort of have a solution,
unfortunately, my solution doesn't work.

{Quote
{SET ID {MERGEFILED SSN}}
{SET EXP1{=-{=-{ID}-ID}/2}}
{SET EXP2{=-({ID}*(-1)-{ID})/2}}
{SET EXP3{=-({EXP1}+{EXP2}-{ID})}}"XXX-XX-"{EXP3 \# 0000}}

...works fine, except in the doc that I need it to work. There, it gives me
a syntax error. What am I doing wrong?

 

[Graham Mayor]

Press CTRL+F9 for the curly bracket pairs and type the rest.

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


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

Hello,
You suggested something I would like to try....stupid question, how
do you get this in ...is quote a quote or spelled out word, do you
type in set id etc?

Thanks for any additional guidance you can provide.

joyce

Hi Drew,

If your source data is '###-##-####' and is not simply '#########'
formatted to look like '###-##-####', try: {QUOTE
{SET ID {MERGEFIELD SSN}}
{SET EXP{=({ID}*(-1)-ID)/2}}"XXX-XX-"{EXP \# 0000}}

If your source data is '#########' formatted to look like
'###-##-####', try: {=MOD({MERGEFIELD SSN},10000) \# "XXX-XX-0000"}

--
Cheers
macropod
[MVP - Microsoft Word]

OK, I see why it doesn't work like it should and sort of have a
solution, unfortunately, my solution doesn't work.

{Quote
{SET ID {MERGEFILED SSN}}
{SET EXP1{=-{=-{ID}-ID}/2}}
{SET EXP2{=-({ID}*(-1)-{ID})/2}}
{SET EXP3{=-({EXP1}+{EXP2}-{ID})}}"XXX-XX-"{EXP3 \# 0000}}

...works fine, except in the doc that I need it to work. There, it
gives me a syntax error. What am I doing wrong?


:

All I want to do is format a merge field in a document template to
display only the last 4 digits of a social security number. Sound
easy?

It appears that the default behavior of Word makes this extremely
difficult, when, in fact it, should be extremely simple...or maybe
I'm just an idiot.

Is there a way to write a field switch to make this happen?

"\# x####" and variations thereof give me a sum.

Thanks.

A