Filter by amount of Characters

Question

Hi all,

I have a column with currencies (always with 3 characters e.g "USD") but some wrong data too in it with more characters. What I want to do is to change this last one to BLANK (""). I found that the most accurate way to do it it's by the string length.

Any formula idea of how to do it?

Thanks

echuong1 · Accepted Answer

You can use a conditional statement:

if Length([Field1]) = 3
then [Field1]
else null()
endif

If the values are always going to be the first three characters, you can also use a left() function to clean this.