Hey. I need to see if "/" is present in the column11 and if it's then just pass it as is or do the substring part. How do I get this to work? It's giving me an error. This is for a TimeDate column. I can get a 20060813 or 2006/08/13.I'm using the below and it's giving me an error saying that It should be DT_BOOL and I'm trying to return DT_I4.
findstring(Column11,"/",2) ? Column11 : SUBSTRING(TRIM(Column11),1,4) + "-" + SUBSTRING(TRIM(Column11),5,2) + "-" + SUBSTRING(TRIM(Column11),7,2)
Thank you
Tej
Tej,
Your test should be: findstring(Column11,"/",2)!=0 . You're testing for true or false(Boolean). findstring returns the location of the string to be found.
Frank
|||Hey Frank. I tried (dt_bool)findstring(Column11,"/",2)
Is that correct or an error? Please let me know. I'll use what you asked me to in this case but just wanted to make sure. Thank you.
|||Yes, that will work also.
Frank
