Skip to Content
0
Former Member
Dec 21, 2007 at 04:08 AM

Get last character use Substring in PLD

50 Views

Halo:)

I try to get last char using substring formula, but i cant.

example:

Field_001 = ABCDEFGH

Field_002 = IJKLMN

The result that I want is grep 3 last character (FGH) and (LMN).

Would you help me how..

I try to combine with

substring(Field_002,0,-3)

substring(Field_002,-3,0)

substring(Field_002,0,3)

substring(Field_002,3,0)

substring(Field_002,-3)

substring(Field_002,3)

and i try to use sentence too, like :

Sentence(Field_002,3)

But cant work. Would you help me?

Thanks

Edited by: dony donse on Dec 21, 2007 5:08 AM

Edited by: dony donse on Dec 21, 2007 5:15 AM