AnsweredAssumed Answered

substitute and wildcards?

Question asked by ChrisRosa on Nov 21, 2013
Latest reply on Nov 21, 2013 by ChrisRosa

Title

substitute and wildcards?

Post

     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...

(10)fpdownload(10)macromedia(3)com(7)edgekey(3)net(0)

     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.

Outcomes