cancel
Showing results for 
Search instead for 
Did you mean: 

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

nchrk
New Contributor II

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
1 ACCEPTED SOLUTION

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

View solution in original post

7 REPLIES 7

nchrk
New Contributor II

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

nchrk
New Contributor II

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?

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

  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