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-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-18-2023 01:15 PM
Thanks Soni for your response. But i’m getting error when this property is not available in input schema object in mapper.
Error :- $JsonStr is not defined
how do we check the property exists or not. if exists, replace the values
$.get(‘JsonStr) != null && $.get(‘JsonStr) =“” ? $.get(‘JsonStr).toString().replaceAll(’\n’,’'):$.get('JsonStr)
05-18-2023 11:34 PM
I mentioned $JsonStr because you mentioned it in the sample data that you shared in comment.
$Jsonstr is the name of the input string that is coming from upstream snaps.
Now if you want to check if a specific field is there or not, you can use the below.
$.hasPath(‘$JsonStr’) ? ($JsonStr != null && $JsonStr != “” ? $JsonStr .replaceAll(“\n”,“”) : $JsonStr) : “”
Let me know if it works.