Introducing Radical.sh

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

REG_EXTRACT - Extract a Date From String in Informatica

  1. Forget Code
  2. Informatica
  3. REG_EXTRACT - Extract a Date From String
To extract date in MM-DD-YYYY or DD-MM-YYYY Format 
  1. REG_EXTRACT(employee,'((\d\d)-(\d\d)-(\d\d\d\d))',1)

Note : This does not check valid date
employee dojoutput
asdf12-04-19884sadf12-04-1988
asdf12-04-198813-04-198812-04-1988
asdf12-04bc-1988Empty String
asdf12-99-19884sadf12-99-1988