Taking the first and last numbers

Dear All Master Outsystems

Please help me,

I have ID in the sample table : 24567

How do I take the first and last Id which I will later assign to a local Variable that I created so the result will be 2 & 7


Hi Hothorasman,

use this expression to get the first and last char of the Id:

Substr(LongIntegerToText(ID),0,1) + Substr(LongIntegerToText(ID),Length(ID)-1,1)


Dear José Gonçalves ,

Thanks for your solution this work

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.