SOLVED
Filter based off number vs text
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
navypoint16
8 - Asteroid
‎01-23-2019
06:11 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I'm trying to filter my data based on the first character of the cell, whether it's a letter or a number. The only differentiating factor is the first character, so I was thinking something along the lines of a LEFT((isDigit),1), but I don't think that's the right way to do it.
Solved! Go to Solution.
Labels:
- Labels:
- Developer
2 REPLIES 2
JoBen
11 - Bolide
‎01-23-2019
06:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @navypoint16, if your filter field is a string, the Left([Field],1)="...", formula should work.
ACE Emeritus
‎01-23-2019
06:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
