Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

REG_EXTRACT - To extract specified pattern using regular expressions in Informatica

  1. Forget Code
  2. Informatica
  3. REG_EXTRACT - To extract specified pattern using regular expressions
Syntax
REG_EXTRACT( port, ‘reg ex pattern’, subPatternNum )


Example : To extract specified set of numbers in the text
REG_EXTRACT(employee,'(.*)[:-](.*)',2)


EmployeeOutput
NSN:LIBS-12292423-060115111437060115111437
NSN:4298701410513:050613105002050613105002