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!
Solved! Go to Solution.
@BraulioCarsolio One way of doing this
Works perfectly. Thank you so much!