VERIFIED SOLUTION i

'Invalid Expression' message in Sagent

Product Feature: General transform use

 

Issue

This could be caused due to Regular Expression meta-characters used which is not supported by Sagent. For example '()' is not supported.

 

Cause

Sagent has limited Regular Expression meta-characters support. For example, "()" parenthesis is not supported.
Following is the list of expression meta-characters supported in Sagent.
  • []
  • [^]
  • +
  • *
  • ?
  • \
  • .

Resolution

UPDATED: September 17, 2019

This is expected behavior with unsupported meta-characters used in Sagent. Use VB script as a workaround.