topic Re: Remove special character (horizontal tab) from xml file in Talend Studio

Remove special character (horizontal tab) from xml file

SJ3 — Sat, 16 Nov 2024 08:26:48 GMT

I have used following tJava replaceAll code to replace horizontal tab (\t) with an empty string. Here is my code:

if (input_row.filename!=null) {

context.file_name = input_row.filename.replaceAll("\\n","");

char asciiChar = (char)9;
String replaceString = ""+asciiChar;
context.file_name= input_row.filename.replaceAll(replaceString, "");
context.file_name = input_row.filename.replaceAll("\t","");
context.file_name = input_row.filename.replaceAll("\\t","");}
else
{context.file_name = input_row.filename;}

But this code didn't replace horizontal tabs in my files. I still think Talend can replace special characters in xml files. I have attached my job's screenshots

Re: Remove special character (horizontal tab) from xml file

Anonymous — Mon, 09 Apr 2018 13:27:21 GMT

Your code is not doing what you think. All you need is below (assuming you also want to remove new lines as well as tabs)....

if (input_row.filename!=null) {
     context.file_name = input_row.filename.replaceAll("\n","");
     context.file_name =context.file_name.replaceAll("\t","");
}else{
     context.file_name = input_row.filename;
}

The problem with your code was that you were overwriting your context.file_name with the result of attempting to remove different values. For example, if you have a variable "myString" which holds "abcdef" and you use the following code....

String myString = "abcdef";
context.file_name = myString.replaceAll("a","");
context.file_name = myString.replaceAll("b","");
context.file_name = myString.replaceAll("c","");
context.file_name = myString.replaceAll("d","");

....the result would actually be "abcef" because you are only removing the last value. To remove ALL of the values you would need to do this...

String myString = "abcdef";
context.file_name = myString.replaceAll("a","");
context.file_name = context.file_name.replaceAll("b",""); 
context.file_name = context.file_name.replaceAll("c",""); 
context.file_name = context.file_name.replaceAll("d","");

Re: Remove special character (horizontal tab) from xml file

SJ3 — Fri, 13 Apr 2018 20:27:19 GMT

Hi, thanks for your post! but I am still getting horizontal tabs (\t) in my files:

\t</Head> \t<Form> \t\t<

I am not sure if it's actually reading my files as it's not replacing this character.

Sony

Re: Remove special character (horizontal tab) from xml file

Anonymous — Sat, 14 Apr 2018 18:03:57 GMT

I've just looked at your job and think you are probably right. What exactly do you have in your tFixedFlow component? I doubt it is the content of the file that the SCP component has downloaded. You need to read that into the job after downloading it.