How to extract a part of a string and display it on the listbox?

[skr002244]

Hello, I want to extract a particular portion of a string.So,can anyone tell me the code for it ?

Example-123TY-P1-00TY. In this i want only P1 to be displayed on the listbox .

[arulsettu]

this is for your example

=subfield('10-P1-12,12-P2-302,100-P3-21','-',2)&','&SubField('10-P1-12,12-P2-302,100-P3-21','-',4)

[jagan]

Hi,

Try like this

SubField('123TY-P1-00TY', '-', 2)

OR

=Mid('123TY-P1-00TY', 7,2)

Hope this helps you.

Regards,

Jagan.

[its_anandrjs]

This is as usual working with subfield check this example also let me clear the string is this way or it will in single line

10-P1-12,12-P2-302,100-P3-21

LOAD SubField(Str,'-',-2) as Formated,*;

LOAD * Inline

[

Str

10-P1-12

12-P2-302

100-P3-21

];

Regards

Anand

[skr002244]

Thank you all.