on 10-30-2013 1:49 PM
Hello experts,
I have three fields in play the Filler, Collect_No & Value_Parts. Below is a description of each field.
FIELD | MAX LENGTH | VALUE | DATATYPE |
Filler | 21 | RRF57657E012345612340030023004200 | String |
Collect_No | 10 | String | |
Value_Parts | 240 | RRF5765 | String |
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
Sam
Hi Sam,
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.
Regards,
Harish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sam,
Check the queue values. you are using the substring function with a item with length lower than 7 characters, then the function throws the exception. Perhaps in the first case all items are filled and in the second case you have any empty item.
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.