79592351

Date: 2025-04-25 10:53:22
Score: 1
Natty:
Report link

You can achieve this in Informatica IICS using Expression transformation. Try using this logic:

REPLACESTR(1, SUBSTR(your_field, 1, LENGTH(your_field) - INSTR(REVERSE(your_field), ' ')), ' ', '' ) || '.' || SUBSTR(your_field, LENGTH(your_field) - INSTR(REVERSE(your_field), ' ') + 2)

Reasons:
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Компания KAZХИМИЯ