I am trying to use the Expression node to perform some logic: I gave split the first name field up if there is a full stop in the firstname.
What I want to do next is delete any fields thats are less than 1 characters in the first split column.
And then what I need help with is how do I compare the columns and perform updates on calculated function.
For example if the Column 1 field is ‘Mr’ then I want to replace it with the Column 2 value, and set the salutation to ‘Mr’
Hi arvindev
I’m not sure I fully understand your request, but the Column Expression node offers many functions that can help you achieve your goal.
You might need to use functions like len() to compare the length of a string.
There’s also the regexMatcher() function, which can be useful for matching patterns, for example, “Mr”.
Then, you just need to put everything together using conditional statements.
I’m sorry I couldn’t be of more help, as I didn’t fully understand the request.
You can look here for examples
1 Like