substitute and wildcards?
I'm using Filemaker to make some logfiles from Windows Server 2003 a bit more readable. Specifically I'm trying to extract and cleanup the DNS name on a log line. Here's a sample of how it looks in the log...
What I'm trying to do, is substitute the parenthesis and numbers with just a period, to make the domain name more readable. I'm finding that "(*)" doesn't work, as I'm sure the quotes are escaping the wildcard. And it seems "("&*&")" isn't even allowed with a substitute function. I could easily remove the parenthesis alone, but that would leave the numbers.
Thanks for any tips.