05-16-2023 10:06 AM
i trying to remove the “\n” character along with empty spaces from string thru mapper expression, but it’s not working.
Solved! Go to Solution.
05-17-2023 05:27 AM
You can use this expression: $JsonStr != null && $JsonStr != “” ? $JsonStr .replaceAll(“\n”,“”) : $JsonStr
Explanation: This will first check if the JsonStr is null or empty, if it’s not then it’ll do the replacing else it’ll just put input jsonStr as output. In your case where JsonStr is null it’ll show output null
05-16-2023 10:17 AM
i changed expression as below, it’s working
JsonStr.toString().replaceAll(‘\n’,‘’).replaceAll(’ ‘,’')
05-16-2023 10:33 AM
expression failing when input string contains blanks or null values using this expression “JsonStr.toString().replaceAll(‘\n’,‘’).replaceAll(’ ‘,’')”
any suggestions how to resolve this when we receive blank/null values?
05-17-2023 01:08 AM
Can you share example of input data(with blank/ null values)
05-17-2023 05:02 AM