CDATA newLine issue

[Former Member]

Hi gurus

we have an issue regarding newLines in CDATA like following example;

<comment><![CDATA[position-text 

line 2 text line 2

line 3 no.:  870011 ]]></comment>

and need to remove the newlines so that we send everything in a single line.

<comment><![CDATA[position-text line 2 text line 2 line 3 no.:  870011 ]]></comment>

i tried with replace string and trim function without success.

can anyone help me?

Regards

PM

[anupam_ghosh2 · Accepted solution]

Hi Peter,

                 you can try this UDF. I tested this in my system, it was able to remove newlines and carriage returns from CDATA section.

public String removeNewline(String s,Container container){
try
  {
   String a="";
   int l=s.length();
   for(int i=0;i<l;++i)
   {
    if(s.charAt(i)=='\n' || s.charAt(i)=='\r')
    {
     continue;
    }
    a=a+s.charAt(i);
   }
   s=a;
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
  return s;
}

Alternatively you can use this code

public String removeNewline(String s,Container container){
try
  {
   s=s.replaceAll("\n", "");
   s=s.replaceAll("\r","");
  }
  catch(Exception e)
  {
   e.printStackTrace();
  }
  return s;
}  

Regards

Anupam

[Former Member]

Hi.  Peter.

You can try a simple sentence in your UDF.

Variable:var1

return var1.replace("\n", "");

Regards

Lucho.