This UDF will help you...
//write your code here
StringBuffer result=new StringBuffer();
char[] splChar= {'!','#','$','%','&','<','>'};
int length=splChar.length;
int splCharFound=0;
int i;
for(i=0;i<length;i++)
{
if(input.indexOf(splChar<i>)!=-1)
{ splCharFound=1;
break; // the control comes out even if ther is one Spl Charr
}
}
if(splCharFound==1) //if the String contains Special Characters
{
result.append("<![CDATA[");
result.append(input);
result.append("]]>");
return result.toString();
}
else //if the input doesnt contain any spl character
{
return input;
}
Hi mates, this problem it's now solved, i forgot to xplain the solution. The solution has been a java function in the mapping to split each field whit the according data structure, if u need more info, please, contact whit this forum.
Best regards and thanks.
Add comment