trim statement

[everest226]

HI i have a field Name PANACNO which his following values .

PANACNO

1:1-2-3-4-5

1:1-2-3-4-5-6

1:1-2-3/2:4-5-6

1:1-2-4-3

1:1-2/2:3-4

1:2-1

1:2-1-3

1:2-3

1:2-3-4

and my statement is following

if(len(PANACNO )>3,
mid(PANACNO ,
Index(PANACNO ,'-',-1) ),1)

which will give me value but with(-).  i only want number.

stalwar1‌

[m_woolf]

What are you wanting to get?

[everest226]

Last number ,basically

[Anonymous]

try subfield(PANACNO,'-',-1)

[everest226]

No it doesnot give me any value beside ( -)

[Anonymous]

what result do you expect for?:

PANACNO

1:1-2-3-4-5

1:1-2-3-4-5-6

1:1-2-3/2:4-5-6

1:1-2-4-3

1:1-2/2:3-4

1:2-1

1:2-1-3

1:2-3

1:2-3-4

[m_woolf]

If you want to fix your expression:

if(len(PANACNO )>3,
mid(PANACNO ,
Index(PANACNO ,'-',-1) )+1,1)

[everest226]

                                        Trying to capture

1:1-2-3-4-5                            5  

1:1-2-3-4-5-6                         6

1:1-2-3/2:4-5-6                        6

1:1-2-4-3                                 3

1:1-2/2:3-4                              4

[Anonymous]

... works for me:

LOAD SubField(PANACNO,'-',-1) as FIELD INLINE [

    PANACNO

    1:1-2-3-4-5

    1:1-2-3-4-5-6

    1:1-2-3/2:4-5-6

    1:1-2-4-3

    1:1-2/2:3-4

    1:2-1

    1:2-1-3

    1:2-3

    1:2-3-4

];

[zebhashmi]

right(PANACNO,1)