Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
=SubField('xvi-0956LK-xva0OL','-',2)
Hi,
You can also try using
=TextBetween('xvi-0956LK-xva0OL','-','-')
Hope this helps you.
Regards,
Jagan.
Hi,
SubField('xvi-0956LK-xva0OL','-',2) as NewField
Thx,
Regards,
Prasath
I guess you didn't read the first reply