Dynamic regex expression

Question

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 Answer

@Chaoued one way of doing this

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

Christina_H · Accepted Answer

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

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