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
Solved! Go to Solution.
Could you try something like this in a filter tool?
Length([Field1]) <= *Length of field size*
Thanks,
Dan
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