Forum Discussion

nchrk's avatar
nchrk
New Contributor II
3 years ago
Solved

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

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
  • Abhishek_Soni37's avatar
    Abhishek_Soni37
    3 years ago

    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

7 Replies

  • nchrk's avatar
    nchrk
    New Contributor II
    3 years ago

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

  • nchrk's avatar
    nchrk
    New Contributor II
    3 years ago

    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?

    • Abhishek_Soni37's avatar
      Abhishek_Soni37
      Contributor
      3 years ago

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

      • nchrk's avatar
        nchrk
        New Contributor II
        3 years ago
        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