how i remove several break line in a CSV to postgresql?

[Anonymous]

I have this problem now, i have a string field with several information and line breaks, the possible solution does not work, does anyone know how to fix it? or how tFileInputFullRow works?

the option row.namecolonne.replaceALL("....") not work in tmap

in this file i have 602 rows, but the database shows 607.

help me

[JR1]

Yes, replaceAll works in tMap. Try this (remember: Java is case-sensitve):

row3.impact.replaceAll("(\\r\\n|\\r|\\n)", " ")

[Anonymous]

I used your instruction, but i have this problem, ignoring the relation with S_Liste_Controle T_Liste_Controle.

Capture5.PNG

[JR1]

Sorry but I do not really get what your question is.

[Anonymous]

I used your instruction  row3.impact.replaceAll("(\\r\\n|\\r|\\n)", " ")  in tMap, so i have now the problem with the picture, Talend shows the next error "» n'existe pasException in component tMap_1 (J_M_Liste_Controle)
java.lang.NullPointerException"

[JR1]

Please try this:

row3.impact == null ? null : row3.impact.replaceAll("(\\r\\n|\\r|\\n)", " ")