Using regex REPLACE in ThinkAutomation

Hi Edwin,

You could use the Script options in ThinkAutomation to call a Regex.Replace function available to the .Net library via C#. Here is a sample from Microsoft - https://learn.microsoft.com/en-us/dotnet/api/system.text.regularexpressions.regex.replace?view=net-7.0

Here is the code I used to replicate their example:

using System;
using System.Text;
using ThinkAutomationCoreClasses.Scripting;
using System.Text.RegularExpressions;

public class ThinkAutomationScript
{
	
	
    public string execute(currentMessage message)
    {
        try
        {
            // Action execution code
            // Get extracted fields/variable values using message.GetValue("name")
            // Set extracted fields/variable values using message.SetValue("name","value")
           	string input = "This is   text with   far  too   much   " + 
                     "white space.";
            string pattern = "\\s+";
            string replacement = " ";
	    string result = Regex.Replace(input,pattern,replacement);
			
	    return result;
			
        }
        catch (Exception e)
        {
            // Pass the error back to the automation log
            message.AddErrorToLog(e.Message);
            return "";
        }
    }
}

Here is the console output from the call:

Here is my output in ThinkAutomation's logs:

Wonderful! thx for both answers!

regards,
Happy customer ;)