Filter out truncated cells

[knozawa]

Hello,

Is there any way to filter out truncated cells?

Here is the sample:

In this case, I would like to filter the Affiliation field and would like to filter out this truncated cell.

Thank you,
Kazumi

[DanS · Accepted solution]

Could you try something like this in a filter tool? 

Length([Field1]) <= *Length of field size* 

Thanks,

Dan

[knozawa]

@DanS,

I also did the same method using following formula:

Length([Affiliation])<300

The field size is 2528, but I wasn't exactly sure the length.

The above formula seems working though.

Thank you!

Kazumi