I want to convert this expression for a column to hql.
iiF(ISNULL(NAME),'#',iif(reg_match(UPPER(NAME),'.,\sCLASS.'),REG_EXTRACT(NAME,'(.),\s*(Class\sU.)$','I'),NAME)
As I tried to go through Informatica Documentation for reg_match and reg_extract but was not sure how it is being applied here.
Do help me understand how is this working and what will be its conversion in hql
