• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » How to use two Java Routines on one column in tMap

#1 2010-04-01 18:13:09

jmaydon
New member
Registered: 2010-02-25
Posts: 6

How to use two Java Routines on one column in tMap

Tags: [routine, tmap]

Still very new to Talend (and Java) and I'm trying to figure out how to run two routines on the same column. This is the scenerio: I have a phone number column. The data in that column comes with speacial characters like + or - that I need to strip out. Also, some of the phone numbers come with a leading "1" that needs to be removed. I have two seperate routines, one to remove special characters and one to remove the leading "1" if the number is equal to 11 characters. My problem is I dont' know the syntax in the Expression Builder to make them work together.

Offline

#2 2010-04-02 05:04:54

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

Re: How to use two Java Routines on one column in tMap

Hello

My problem is I dont' know the syntax in the Expression Builder to make them work together.

For example:
RoutineName2.removeLeading(RoutineName1.removeSpecialCharacters(row1.columnName))

Best regards
Shong


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

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » How to use two Java Routines on one column in tMap

Board footer

Powered by FluxBB