REG_EXTRACT - To extract specified pattern using regular expressions in Informatica

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