Field Expression (11 digit numbers problem)

[#1]

Hi;

I would like to see just 11 digit numbers in my field and i try in field expressionif(<field_name> > 10, <field_name>) and my app slow down after that. Also it does not work correctly.

Perhaps it is simple but i did not success...

Please Help me !!!

Thanks in advence

[sparur]

Do You want change number format ? or Do you want select only values more than 10?

[#3]

I want to select only values more than 10

[#4]

I want to select only values more than 10

[#5 · Accepted solution]

Hi Selcuk,

try the following: If(Len(YourField)>10, YourField)

Good luk!

Rainer

[#6]

Thank you Rainer ;

It works but that field is slower than other fields?

Do you know what is the reason of that?

[johnw]

Well, if you're just doing that in the application instead of in the script, it has to execute a bunch of logic every time you use that expression. If that's the problem, I'd create it as a real field in the script:

if(len(YourField)>10,YourField) as YourFieldWithMoreThanTenDigits

And then use the new field instead any time you only want to see it when it has more than ten digits.

[#8]

Yes that is it...

This solving is what i need. Thank you so much...