Regex - remove values from field

[pberthov]

Hello, 

I need to remove /1 from the field 123456789/1.

I thought using Regex, but not sure what to put in Regular Expression.

Can you please help?

Thanks,

Petra

[MarqueeCrew]

@pberthov ,

Please don't use RegEx.  Instead use REPLACE:

Replace([Field], "/1", '')

Cheers,

Mark

[HomesickSurfer · Accepted solution]

Hi @pberthov 

Assuming that the value after the / may not always be a 1, try this:

Replace([Field1], Right([Field1], 2), "")

Modify [Field1] to your field name that contains the values.