topic Re: [resolved] How i can remove a line break in a csv? in Talend Studio

[resolved] How i can remove a line break in a csv?

Anonymous — Sat, 16 Nov 2024 11:41:23 GMT

Hello community!
I'm trying remove a linea break in a csv file, but in my Map i can't do this with usual java code, i'm little newby in talenD world, can you help me please?
Thanks!

Re: [resolved] How i can remove a line break in a csv?

willm1 — Wed, 09 Apr 2014 18:25:42 GMT

Hi Vlopez... I don't know what you tried in Java, but here's something that would work in tMap:
row1.columnName.replaceAll("\\r\\n|\\r|\\n", " ")
See other options if this does not do it - http://stackoverflow.com/questions/2163045/how-to-remove-line-breaks-from-a-file-in-java

Re: [resolved] How i can remove a line break in a csv?

Anonymous — Thu, 10 Apr 2014 08:12:03 GMT

Hi,
Or you can take a try for this solution: tFileInputFullRow-->tReplace.
Best regards
Sabrina

Re: [resolved] How i can remove a line break in a csv?

Anonymous — Fri, 11 Apr 2014 09:15:07 GMT

Thanks guys, both for fast reply.
I try the solution offered by xdshi and this works.

Thanks so much!

Re: [resolved] How i can remove a line break in a csv?

Anonymous — Fri, 11 Apr 2014 09:21:23 GMT

Hi,
Glad you could solve the issue. Could you please click the "Set this topic as resolved"? Feel free let me know if there is any further help we can give.
Best regards
Sabrina

Re: [resolved] How i can remove a line break in a csv?

Anonymous — Fri, 11 Apr 2014 13:56:51 GMT

hi! i click this link but don't work , what i should do?

Re: [resolved] How i can remove a line break in a csv?

Anonymous — Mon, 14 Apr 2014 04:27:24 GMT

Hi,
I have marked it as resolved. Thanks for your feedback.
Best regards
Sabrina

Re: [resolved] How i can remove a line break in a csv?

Anonymous — Tue, 20 Aug 2019 10:02:22 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? help me