I am trying to strip non alpha-numeric characters from an Invoice Number field. I am using the column expressions node with the following expression:
upperCase(strip(regexReplace(column(variable(“var_invoiceNum”)) , “[^a-zA-Z0-9]” , “”)))
However, I get the following error message:
Execute failed: Cannot invoke “java.lang.CharSequence.length()” because “this.text” is null
a) what does this error message mean
b) where am I going wrong?