Copy text

case:

From this sample text 'test\azerty', I only need the part before the '\'. do a calculation like this:

SUBSTRING('#REPLACE-FORMFIELD-FORMFIELDHERE#', 0, INDEXOF('#REPLACE-FORMFIELD-FORMFIELDHERE#', '\\'))