Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7313 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

Here's a simple custom function that allows you to search for strings of wildcards (and only wildcards) in a block of text. It replaces all numbers with "#", and all major punctuation with "/". I wrote it in response to a question for a way to see if a block of text contains a social security number, which you can search for as "/###/##/####/". It may need to be tweaked for specific purposes, but I imagine some other people might find it handy. The basics of the function are also written in a calculation field, for those of you without Developer and can't read the custom function. Enjoy!

-Terence

PositionWildcards.zip

Posted

I've tested this thing every way possible to get a SSN into the text field and can't do it. I think this is fantastic! Very Clever! Tnx wink.gif

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.