Talend: get SOUNDEX of String in tMap

Question

I am inserting data from a CSV file to a MySQL database, and one of the columns should contain the SOUNDEX representation of a string.

For example, I have the first name as a column in the CSV and the database should contain its SOUNDEX.

I am using tMap between the file delimited and MySQL output, so the operation should be there. Something like SOUNDEX(row1.FIRST_NAME).

Details: Talend Open Studio, MySQL database

So what do you want? You want us to implement it for you? Are you looking for a library recommendation? — , Jun 30 '20 at 09:26
@StaceyGirl no I am asking how to make it using Talend in this scenario — Majed Badawi, Jun 30 '20 at 09:28

score 1 · Accepted Answer · answered Jun 30 '20 at 19:38

1

You can use Apache Commons Codec to do this. First load the library using tLibraryLoad:

Then use:

new org.apache.commons.codec.language.Soundex().encode("<string>")

answered Jun 30 '20 at 19:38

Ibrahim Mezouar

Thanks a lot! One question, I faced an error due to a ``Ë`` character in the string. Do you think it's doable? – Majed Badawi Jun 30 '20 at 20:02
java.lang.IllegalArgumentException: The character is not mapped: Ë – Majed Badawi Jun 30 '20 at 20:04
I think it's doable, since the vowels are discarded in the soundex algorithm, you can use another Apache Library which can replace Ë with E – Ibrahim Mezouar Jun 30 '20 at 20:07
I don't have experience with such libraries. Any recommendations? – Majed Badawi Jun 30 '20 at 20:08
Take a look here https://stackoverflow.com/q/3322152/899863 – Ibrahim Mezouar Jun 30 '20 at 20:10
Yup ``java.text.Normalizer`` solved it! Thanks again for the help. – Majed Badawi Jun 30 '20 at 20:16

1 Answers1