topic Re: trim spaces from fields in Talend Studio

trim spaces from fields

Anonymous — Sat, 16 Nov 2024 13:10:35 GMT

Hallo,
my input table has fields (string) with a size of 25 if for example the name 'Hunter' is stored in that field
the rest of the field is filled up with spaces.
So the output is:
'Hunter '
and I want to trim it to get the following output
'Hunter'
The input table is a AS400 and I have only read access, the destination Database is Mysql.
I use tMap.

Greetings
Peter

Re: trim spaces from fields

Anonymous — Sat, 18 Dec 2010 15:11:13 GMT

Hi Peter,
I assume you are using tAS400Input step to read the input table. Then if the requirement is to trim all the leading and trailing spaces of the input column, then you can go to the "Advanced settings" tab of the component and enable "Trim" for the field.
Regards,
Abhi

Re: trim spaces from fields

Anonymous — Sat, 18 Dec 2010 16:47:23 GMT

Hi Peter,
Same info holds good for tMysqlInput component also. It has the same feature to trim the sting for desired column.
Go to tMysqlInput component --advanced settings---trim column check box
Thanks,
Prashanta Pathak

Re: trim spaces from fields

Anonymous — Sat, 18 Dec 2010 18:25:18 GMT

Thanks Abhi, I should open my eyes 🙂