topic Remove blank space - csv file in Talend Studio

Remove blank space - csv file

Anonymous — Sat, 16 Nov 2024 12:08:34 GMT

Hi everyone,
How to remove blank space at Talend job? I check 'Trim All Columns' at FileInputDelimited Advanced Settings. But when I recheck at SQL Server table. The data inserted is wrong cause it affect another columns value by set it NULL.
Attached are csv file, image files of my job and error I received.
Please help me on this matter. I'm still new to Talend.
Thanks in advance!

Re: Remove blank space - csv file

Anonymous — Wed, 28 Nov 2012 06:49:22 GMT

Hi,
I have seen your pic and found that something wrong with the string "getati sintetik dalam bentul<primer", what is the full source strings? Can you find "getati sintetik dalam bentul<primer" has been inserted in your DB?
Best regards
Sabrina

Re: Remove blank space - csv file

Anonymous — Wed, 28 Nov 2012 09:18:29 GMT

Hi Sabrina,
The full one is this - " Pembuatan kimia asas, baja dan sebatian nitrogen, plastik dan
getati sintetik dalam bentul< primer"
Looks like the string is in embedded newline format at Excel field. Do you know how to solve this?
Thanks!

Re: Remove blank space - csv file

Anonymous — Wed, 28 Nov 2012 10:03:59 GMT

Hi,
How about setting the length of string longer in schema or change it in source file by manual. Actually, I have no idea about it. But I will consult my colleague and give you a satisfied response asap.

Best regards
Sabrina

Re: Remove blank space - csv file

Anonymous — Wed, 28 Nov 2012 10:26:53 GMT

hi all
seems that you have a carriage return in your String.
Use editor that is possible to see "invisible caracter" and check if you have \n or \r (or both) in your String.
In that case, if you have \n as a row delimiter, it's effectively a new line for the parser.
Change delimiter or a best way for me, clean you data before use it (propagate further)
hope it help
regards
laurent

Re: Remove blank space - csv file

Anonymous — Wed, 28 Nov 2012 21:40:49 GMT

If you need the line break in your values, enclose values with " . In this case this line break will not used as data set delimiter.

Re: Remove blank space - csv file

Anonymous — Thu, 29 Nov 2012 08:01:57 GMT