Switch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

melissa1005 - 29 Aug 2004 17:28 GMT

Does anyone know of a switch that will only put in the last four digits of a
SSN, ie xxx-xx-1234?

Reply to this Message

Greg Maxey - 29 Aug 2004 23:42 GMT

Melissa

If the data source format is 123456789, it is relatively simple:
{QUOTE "XXX-XX-"{mergefield ssn \# x### }} or an SSN held as 12345678If the
format is 123-45-6789, it gets more complicated.{QUOTE "XXX-XX-"{SET
ID"{mergefield ssn}"}{SET
SSX{={=-{=-{ID}-ID}/2}-(({ID}*(-1)-{ID})*(-1)/2+{ID})}}{SSX \# 0000}}.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> Does anyone know of a switch that will only put in the last four
> digits of a SSN, ie xxx-xx-1234?

Reply to this Message