How to know if the fourth character is a number

[BraulioCarsolio]

Hi, community!

I'd really appreciate your help. I have a field named "Case Code", where I can get different inputs, such as:

R9WCCase

M8KR,

6TQ10/1/23-10/13/23

etc...

My question is, how can I set an if statement that keeps the first three characters if the fourth is a number, and to keep the first four in any other situation?

The solution should look like this, based on my previous example:

R9WC

M8KR

6TQ

Thank you so much in advance!

[binuacs · Accepted solution]

@BraulioCarsolio One way of doing this

[BraulioCarsolio]

Works perfectly. Thank you so much!