Filter by amount of Characters

[Lean_Sawko]

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

[apathetichell]

Is the currency string always the first 3 characters - if so left([fieldname],3) will work

[echuong1 · Accepted solution]

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.