SOLVED
count the number of digits in a code
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
BillyL14
8 - Asteroid
‎11-24-2020
02:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have a list of codes, for example 568392728921, 473892, 219372178, 478273842374 etc.
I want to filter out codes that have less than 10 digits, is there a way to do that?
Thanks
Solved! Go to Solution.
2 REPLIES 2
16 - Nebula
‎11-24-2020
02:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Yes! You can use the filter tool with the expression
length([Code]) >= 10
If your code is an integer then you can use,
Length(ToString([Code])) >= 10
The records you want will flow out the True Anchor.
Hope this helps,
Philip
‎11-24-2020
02:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
thanks!
