Can I remove characters after a specific symbol?

[#1]

I need to format our product codes so that :

4233702/1001100

EN42343EX/1013100

Become:

4233702

EN42343EX

Removing everything after the forward slash. Can I do this via Qlikview scripting?

[hic · Accepted solution]

Left(FieldName, Index(FieldName, '/') - 1)

HIC

[#3]

Many thanks Henric. Worked a treat

[Uri]

Tack Henrik! (Thank you)

[Bionic]

Hi, What if I need to keep rest text after the email e.g.

Original  Text : My Email is Tim.Kimball@amazon.com. Please Contact.

Desire Replace Text: My Email is Tim.Kimball****. Please Contact.

[thestaffsolutions]

Thanks, needed the exact same thing 😁