getting an extract of a field

[#1]

Hello everyone i need your help on something i have a field that kind of looks this way "xvi-0956LK-xva0OL" I need to create a new field from the old one where i only display the middle part " 0956LK". Thanks for your help PS: this need to be done in the edit script part not in the reporting part

[RedSky001]

=SubField('xvi-0956LK-xva0OL','-',2)

[jagan]

Hi,

You can also try using

=TextBetween('xvi-0956LK-xva0OL','-','-')

Hope this helps you.

Regards,

Jagan.

[#4]

Hi,

SubField('xvi-0956LK-xva0OL','-',2) as NewField

Thx,

Regards,

Prasath

[RedSky001]

I guess you didn't read the first reply