0

For example, how to successfully compare "André" and "Andre"?

I tried some Reg_replace options without any success.

Jose Manuel de Frutos
  • 1,040
  • 1
  • 7
  • 19
DDJ
  • 5
  • 4
  • Please specify what programming language are you using. – Jose Manuel de Frutos Jun 21 '23 at 19:06
  • This is Informatica cloud. “Reg_replace” is an expression function in Informatica cloud. – DDJ Jun 21 '23 at 20:11
  • 1
    Hi - what do you mean by successfully compare? The two strings you’ve provided are different and you appear to be saying that an e with an accent and an e without an accent are the same, but on what basis are you defining them as the same? – NickW Jun 21 '23 at 22:21
  • I have 2 tables with names. One of them has accents and other one was created as part of a migration and most of the names dropped the accents. The comparison strategy that we defined is Accent insensitive. So “André” should be match for “Andre” – DDJ Jun 22 '23 at 11:59
  • There is no such thing as “accent insensitive” - at least as far as how computers represent characters. The e and the é are completely different characters (have a look at an ascii table) - so you would need to define which characters you consider to be identical and then explicitly code those business rules into your SQL - possibly via regex or some similar mechanism – NickW Jun 22 '23 at 13:14
  • You can do accent insensitive comparisons in SQL server with collate and the correct collation name. For example “COLLATE Latin1_general_CI_AI” changes Latin char to Case Insensitive and Accent insensitive English char. We also have Transliterator in Java that can do the same thing. – DDJ Jun 22 '23 at 14:29

1 Answers1

0

I don't think there is an out-of-the-box function available in IICS. Try using Java transformation to remove the diacritics. Here's one SO post I've found that should provide some help.

Note there may be some more up to date libraries now.

Maciejg
  • 3,088
  • 1
  • 17
  • 30
  • I think this is the closest to a solution for this. As always thank you Maciejg – DDJ Jun 29 '23 at 21:00