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?
Solved! Go to Solution.
Hey @tbrown06! Try putting this formula in your Filter tool:
length(tostring([Field1]))==6
Hope this helps!
The format isn't really an issue. I just wanted to filter out the rows formatted that way because they contain multiple product ids. Your solution would work great if I wanted to separate out the ids in those cells and keep the ones that are 6 characters, but I don't need to. Appreciate the help though!