topic Re: how i remove several break line in a CSV to postgresql? in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 04:54:57 GMT

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

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

JR1 — Tue, 20 Aug 2019 13:01:26 GMT

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

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

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

Anonymous — Tue, 20 Aug 2019 14:00:40 GMT

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

Capture5.PNG

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

JR1 — Tue, 20 Aug 2019 14:08:45 GMT

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

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

Anonymous — Tue, 20 Aug 2019 14:11:51 GMT

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"

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

JR1 — Tue, 20 Aug 2019 18:50:28 GMT

Please try this:

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