Question

StringSearcher size limit?

  • 11 December 2018
  • 2 replies
  • 0 views

Badge

Hi

Is there a size limit for the "Search in"-string of the StringSearcher-Transformer?

Regards, Tobias


2 replies

Badge +3

@tobibruehlmeier

Is it not the same as the 1000 expressions limit (oracle sql) ?

 

Mostly solved by using an OR statement IN(..) OR IN (..) ..etc.

 

 

Userlevel 3
Badge +17

If you need to find a part that matches a regular expression from first N characters in an attribute value, the SubstringExtractor or the @Substring function can be used to create the value to be set to the Search In parameter.

Reply