Pages: 1

Post reply

#1 2007-11-05 23:31:34

daniel haanpaa
Guest

Trim Function

Tags: [java, tos2.2.1, trim]

This came from a combining of two fields I am trying to transform this
"Smith                                , John             "
into this
"Smith, John"

What is the best way to accomplish this in talend?

#2 2007-11-06 03:23:28

shong
Talend team
Registered: 2007-08-29
Posts: 10289
Website

Re: Trim Function

Hi Daniel haanpaa

You can use the replace(" ","") to remove all the spaces.
Please see the screenshot.

Best regards


Uploaded Images

Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

#3 2007-11-06 07:33:08

Daniel Haanpaa
Guest

Re: Trim Function

thanks

Post reply

Pages: 1

Board footer

Powered by FluxBB