Get last character use Substring in PLD

[Former Member]

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

[former_member583013]

Dony,

You will use the Substring function with 2 parameters.

Example Substring(,)

For your example you will use

example:

Field_001 = ABCDEFGH

Field_002 = IJKLMN

Substring(Field_001,5) for Field_101

Substring(Field_002,3) for Field_102

The charecter count starts from 0....A would be 0, B would be 1

Suda

[Former Member]

Hi Suda,

Thanks for your reply.

Btw, i think very difficult if i must have more than one formula, because every field have different lenght.

Btw...

last update, i use lenght(Field)-3 formula on Field_003, then i use substring(Field_001,Field_003).

Problem solved

Thanks

[former_member583013]

I agree. I am glad I could help you.

Best wishes

Suda