Filtering by specific number of characters

I was wondering if it is possible to filter based on a specific number of characters? I have a product id field in my data and the id's are all 6 digits. There are also some cells in the field though that list out multiple ids in a cell in the following format ( 123456 | 123457 | 123458 | ...). Is it possible for me to filter down to just the cells that contain 6 characters?

Common Use Cases

Accepted answers

Hey @tbrown06! Try putting this formula in your Filter tool:

length(tostring([Field1]))==6

Hope this helps!

All comments

Hey @tbrown06! Try putting this formula in your Filter tool:

length(tostring([Field1]))==6

Hope this helps!

Step 1: Create Record Id to enforce uniqueness

Step 2: Use text to columns and split values into multiple columns

Step 4: Transpose with record Id as group

Step 5: Create a flag for each value whether it's length is 6

Step 6: Summarize and Avg by RecordId and Value

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703