Dynamic regex expression

[Chaoued]

Hello Team, Is there a regex function that replaces the word from \ to the end with blank ? because Q2_2012 changes !!

Input : Rapport F12/Q2_2012 Versus F13/Q2_2012

Output : Rapport F12 Versus F13

Thanks for your help

[binu_acs · Accepted solution]

@Chaoued one way of doing this

REGEX_Replace([Data], '\/Q\d_\d{4}', '')

[Christina_H · Accepted solution]

This works for this example but may not work for all your data.

REGEX_Replace([Input],"\/\S+","")