topic Re: Talend tMap if condition for mathematical symbol as string in Talend Studio

Talend tMap if condition for mathematical symbol as string

Anonymous — Thu, 24 Aug 2017 12:01:25 GMT

I have a column in a table and some values has back slash / towards end. i want to remove these slash value and retain the rest of text. so lets say i have a text "myjunkdata/", it should give me back "myjunkdata". However below condition is not working.

(StringHandling.RIGHT(row1.CertificateName,1) == "/") ? StringHandling.LEFT(row1.CertificateName,StringHandling.LEN(row1.CertificateName)-1) : row1.CertificateName

example data below

Certified SOA Security Specialist/
Information Security Management Principles Foundation Certificate/
Check Point Certified Security Administrator  R77/
Check Point Certified Security Expert  R77/
Check Point Managed Security Expert/
Cisco Certified Network Associate Security
Cisco Certified Network Professional Security
Cisco Certified Internetwork Expert Security
Cisco Certified Network Professional Security

Can anyone help?

Re: Talend tMap if condition for mathematical symbol as string

Anonymous — Thu, 24 Aug 2017 12:11:53 GMT

Hi,

row1.CertificateName.replace("/","")

Good luck

SGV

Re: Talend tMap if condition for mathematical symbol as string

Anonymous — Thu, 24 Aug 2017 12:13:26 GMT

Not helpful. there are / symbols in the middle area too, which i want to retain. i only want to remove the ones appearing at the end. Thanks!

Re: Talend tMap if condition for mathematical symbol as string

Anonymous — Thu, 24 Aug 2017 12:17:10 GMT

Can you please try with below one

StringHandling.RIGHT(row1.CertificateName,1).equals("/")? StringHandling.LEFT(row1.CertificateName,StringHandling.LEN(row1.CertificateName)-1) : row1.CertificateName

Re: Talend tMap if condition for mathematical symbol as string

Anonymous — Thu, 24 Aug 2017 12:28:10 GMT

(row1.CertificateName.lastIndexOf("/") == row1.CertificateName.length()-1)?

row1.CertificateName.subSequence(0, test.length()-1) : row1.CertificateName