truncating data in a given string

[#1]

Hi,

I have a field having data like this 876-1209 (c-BENlhnhg 9.l0./10)  and I want truncate the data after bracket begins and my output should be 876-1209

Can you pls let me know which function works, I tried using sub string but couldn't success.

Thanks,

[marcus_sommer · Accepted solution]

Try: subfield(YourField, '(', 1)

- Marcus

[eespiritu]

Hi,

This is other option:  left(YourString,index(YourString,'(')-1)

Regards,

Enrique

[#4]

Thanks Marcus it is working as expected.

Thanks,