I have three fields in play the Filler, Collect_No & Value_Parts. Below is a description of each field.
When using the substring function (0....7)on the Filler value, & mapping it to Value_Parts, the value RRF5765 is obtained.
Applying the very same function on Filler & mapping it to Collect_No gives the below exception
Please help me with the issue.
Any thought on the issue is appreciated.
Thanks in Advance
adding to the Inaki's comment, you can use the length function to check the length before substring. Substring function would not validate the length and through exception when required length data is not in the input.
It would be better to use UDF for substring then standard substring function.