Taking the first and last numbers

Solved

Question

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

14 Mar

Champion

Solution

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)

Regards

14 Mar

Thanks for your solution this work

21 Mar

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