Hi,
I have a requirment to always grab last three charcters from string i.e.
123456 ans= 456
I tried couple of optios but it chops like substring, left, right but nothing seems to work,
Right(Arg1, len(Arg1) - 3)
regards,
Substring to grab last three
Moderators: chulett, rschirm, roy
Assuming '%' is your delimiter, use
Code: Select all
Field(Arg1,'%',3)
Narasimha Kade
Finding answers is simple, all you need to do is come up with the correct questions.
Finding answers is simple, all you need to do is come up with the correct questions.