topic Re: tFileInputDelimited component Trim all columns option not working in Talend Studio

tFileInputDelimited component Trim all columns option not working

Anonymous — Sat, 16 Nov 2024 06:57:13 GMT

Hi All,

I would like to know about Trim all columns options present in the Advanced Settings of tFileInputDelimited component.

In my case, I am extracting a .csv file with "~" as field separator. I have enabled Trim all columns option in the Advanced Settings.

Consider the following test record.

SEKAR~NO123 ~XXYYY~INDIA ~23

This record has two trailing spaces "NO123 " and "INDIA ". Those two columns were not trimmed while extracting the file.

The record was inserted with trailing space, that led to the lose of data on lookup.

I want to know, whether the Trim option will work, once the columns are extracted, or before splitting each column against the separator. Or if this is a bug.

Kindly help in this issue.

Thanks in advance.

Re: tFileInputDelimited component Trim all columns option not working

Anonymous — Wed, 02 Jan 2019 16:39:11 GMT

Hi,

I used the same line shared in your query and I was able to trim the trailing space.

Please refer the screenshot before and after trimming the spaces.

Before trim results

Addition of trim in file component

After trim results

The trim will happen after the columns are parsed from the row.

In your case, I am suspecting that the trailing data might not be empty space but some other non readable character.

If the error persists, could you please share the sample file where you are having issue for us to verify?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: tFileInputDelimited component Trim all columns option not working

Anonymous — Thu, 03 Jan 2019 05:03:47 GMT

Hi Nikhil,

Thanks for the effort.

Let me try the same, by taking the particular record having trailing space and store it in an another file and let me try to parse it.

Also I have to check whether the trailing one is actually a space or any non-readable junk character.

Re: tFileInputDelimited component Trim all columns option not working

Anonymous — Thu, 03 Jan 2019 05:10:55 GMT

Thanks for the update.

Please do not forget to mark the topic as resolved once you are able to resolve the issue 🙂

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂