topic Re: tMap expression - left character / startsWith string then replace with new character in Talend Studio

tMap expression - left character / startsWith string then replace with new character

Cherichoc- — Fri, 15 Nov 2024 23:42:36 GMT

I need assistance in creating an expression in tMap that if the string starts with "0" or "27" then Replace those characters with "+27"

manodwhb — Wed, 22 Sep 2021 01:10:56 GMT

@Phumla Qwabe ,check the below screenshots.

tmap expression:-

row2.col.substring(0,1).equals("0") ? "+27"+row2.col.substring(1,(row2.col).length()) :

row2.col.substring(0,2).equals("27") ? "+27"+row2.col.substring(2,(row2.col).length()) : "000000"

Thanks,

Manohar

Cherichoc- — Wed, 22 Sep 2021 07:25:04 GMT

lets say on there was also '012 572 3535" and i want to also replace the spaces. so after adding "+2712 572 3535" I want to remove the spaces

row2.col.replaceAll(" ", "") is not working

Cherichoc- — Wed, 22 Sep 2021 17:47:10 GMT

lets say on there was also '012 572 3535" and i want to also replace the spaces. so after adding "+2712 572 3535" I want to remove the spaces

row2.col.replaceAll(" ", "") is not working

#tMap #regex #expression