Peter: In the past, I've always broken down the IP address into four separate character fields. This would make it easy to mask the leading octets for displaying. Of course, it also requires building workflow. No such thing as a free lunch. :)
--Phil ----- Original Message ---- From: "Joran, Peter P, CTR, OSD-CIO" <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, December 10, 2007 8:00:28 AM Subject: How to partially mask a field All I need to mask the first two octets of our IP addresses. It gets a little complicated as an IP address length varies. For example an IP address could be 1.1.1.1 or 123.123.123.123. Is there a way to do a SUBSTR type of function that can start after the second "."? I'm trying to avoid reformatting the address to eventually get what I want. Then again if I'm going about this the wrong way I'm open to thoughts. Best Regards Pete _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" ____________________________________________________________________________________ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
