Remove the character "\n" and empty spaces from string

Designing Pipelines
1

i trying to remove the “\n” character along with empty spaces from string thru mapper expression, but it’s not working.

  1. input value JsonStr := [\n “AC”\n]
    expected output := [“AC”]
  2. input value JsonStr := [\n “AC”,\n “BD”,\n “DE” \n]
    expected output := [“AC”,“BD”,“DE”]
    i tried with JsonStr.toString().replaceAll(/\n/,“”). but it’s not working
2

i changed expression as below, it’s working
JsonStr.toString().replaceAll(‘\n’,‘’).replaceAll(’ ‘,’')

3

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?

4

Can you share example of input data(with blank/ null values)

5
  1. input value JsonStr := [\n “AC”\n]
    expected output := [“AC”]
  2. input value JsonStr := [\n “AC”,\n “BD”,\n “DE” \n]
    expected output := [“AC”,“BD”,“DE”]
  3. input value JsonStr := null
    expected output := null
6

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

image

7

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)

8

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.