Question
Quavo
US
Last activity: 4 Feb 2020 10:28 EST
@substring function not working correctly with Alpha Characters
Hi!
I am trying to use the function substring to determine an action that must be taken when the first position of a value does not starts with a specific letter:
@substring(.ReferenceNumber,0,1)!="F"
However, when I run my process is not working. I tried to run from the decision table and it keeps giving me a wrong result. I attached a picture with the test Page Result.
What I used, that works great was !@startsWith(.ReferenceNumber,"F"). However, I dont understand why the substring validation is given an unexpected result.
Any Thoughts?
Areteans
IN
Looks like there is some else if condition which is returning FEE value.
I tried with the same function and it is working as expected. Refer to the attached screens for matched and not matched scenarios.
Could you try the same way I tested and see if you are still seeing the wrong results?
PAF
US
Hi Adriana,
Yes you are right we have an issue when directly calling function in cell. I have placed the screen shot of Issue and workaround to solve this. Kindly review below screen shot
Issue Exist Screenshot : IssueDTable.png
Solution Screenshot : SolutionDTable.png
Regards,
Karthick
Quavo
US
Thank you both for your quick responses and time!
Yes, it worked great using the property defined on the top and then comparing with =="F" or !="F", so I will take that solution for now. Have a great day!