Hi Folks,
Forgive me for this dummy question but I've been cracking my head for
hours.
Is there anything special in RecordPath regular expressions? I'm trying to
trim whitespaces by using UpdateRecord (with replacement strategy of Record
Path Value ) replaceRegex over current field value but I can't find any
expression that works.
All my attempts produce an output with the original value however simple
replacements like replaceRegex(/FULL_NAME,'JON', 'ERIC' ) works. I've
already tried expressions like:
replaceRegex(/FULL_NAME,'\s', '' )
replaceRegex(/FULL_NAME,'\s+', '-' )
replaceRegex(/FULL_NAME,'\s{2,}', '-' )
replaceRegex(/SSN,'(\d+)', '$1' )
replaceRegex(/SSN,'\s+$', '' )
If I try the regex in a java regex tester (like
https://www.freeformatter.com/java-regex-tester.html) all expressions
matches/replaces as expected but in the UpdateRecord processor they have no
effect.
What am I missing?
Thanks
