I am using a substring function to get the 1st eight char of the string but the mapping fails if the input has no data, how can I handle this?do we have to write a UDF for this?please help
Thanks