Hi,

I am trying to convert a Lotus Notes field that stores a date but comes across to PDI as a string. The actual data in the field is not validated on entry so there are three different formats yyyy-MM-dd, MM/dd/yyyy and MM/dd/yy. For the str2date to work I need to know the format. I attempted to use the switch/case but this does not seem to take Regex. The Regex evaluation only has one output. What is the best approach to this. Using a series of filters on the failing output, building multiple cases based on the data such as contains / and another contains -. I have looked through the users guide and the forums. Just want to check I am not missing some functionality such as if the switch/case actually should take RegEx

Thanks
Alan