Extract a text from field

[zied_ahmed1]

Hello I need to extract text and make it like a field :

Exemple :

I have this text and i need to extract Americas (so i need to extract the word between the first two  " /"

ALL/Americas/North America/

Thanks for help

[Anders_Eriksson · Accepted solution]

SubField(text, '/', 2)