Ok, this is going to be messy, but... Say the string is 123.234.3.4
First you want to find where the first . is: STRSTRC($Field$,".") Grab the rest of the string from that point to the end: SUBSTRC($Field,STRSTRC($Field$,".")+1) Which will return 2.3.4 Now, find the second .: STRSTRC(SUBSTRC($Field,STRSTRC($Field$,".")+1,".") Finally, to get everything after the second .: SUBSTRC($Field$, SUBSTRC($Field,STRSTRC($Field$,".")+1) + STRSTRC(SUBSTRC($Field,STRSTRC($Field$,".")+1,".") + 1) At least, in theory, that should work. J.T. Shyman Column Technologies -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joran, Peter P, CTR, OSD-CIO Sent: Monday, December 10, 2007 10:00 AM To: [email protected] 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
