- 2 minutes to read

Formula - replaceregex

New 7.0.0.0

Tip

Concatenate multiple named entries in a nodeset. This feature does not produce permutations that would otherwise be the case using for example a regular Xpath-expression.

replaceregex Formula function

replaceregex(oldText,newText,Content) Formula function used to replace a specific char/word with another char/word, the result will contain the newText instead of oldText.

Example data 

<TypedPolling xmlns="http://schemas.microsoft.com/Sql/2008/05/TypedPolling/INT007">
	<TypedPollingResultSet0>
		<TypedPollingResultSet0>
			<ProjectNumber>1401518</ProjectNumber>
			<Company>400</Company>
			<Activity>1000</Activity>
			<Version>20250301060028</Version>
			<Action>DELETE</Action>
		</TypedPollingResultSet0>
		<TypedPollingResultSet0>
			<ProjectNumber>1401518</ProjectNumber>
			<Company>400</Company>
			<Activity>1001</Activity>
			<Version>20250301060028</Version>
			<Action>DELETE</Action>
		</TypedPollingResultSet0>
		<TypedPollingResultSet0>
			<ProjectNumber>4831351</ProjectNumber>
			<Company>355</Company>
			<Activity>1063</Activity>
			<Version>20250301060028</Version>
			<Action>DELETE</Action>
		</TypedPollingResultSet0>
		<TypedPollingResultSet0>
			<ProjectNumber>9233120</ProjectNumber>
			<Company>700</Company>
			<Activity>3400</Activity>
			<Version>20250301060028</Version>
			<Action>DELETE</Action>
		</TypedPollingResultSet0>
		<TypedPollingResultSet0>
			<ProjectNumber>9402000</ProjectNumber>
			<Company>734</Company>
			<Activity>5104</Activity>
			<Version>20250301060028</Version>
			<Action>DELETE</Action>
		</TypedPollingResultSet0>
	</TypedPollingResultSet0>
</TypedPolling>

Next Step

How to Add or manage Search Fields
How to Add or manage Log Views

Expression Type Plugins are used in Search Fields
What are Search Fields?
What are Search Field Expressions?
What are Message Types?
What are Log Views?