Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a field "Category" whose values are
1. ABC
2. DEF
3. GHI
000
ABCDEF
GHID
How can I dynamically filter so that I want only fields which starts with "1. ABC", 2. DEF, ......"10. DEX"
and remove fields that have only numbers and starts with unwanted texts (145365, ABCDEF, GHID)
thanks
So, the pattern is that it will be a number before . and text after .? May be this
Where IsNum(Trim(SubField(Category, '.', 1))) and IsText(Trim(SubField(Category, '.', 2)))
So, the pattern is that it will be a number before . and text after .? May be this
Where IsNum(Trim(SubField(Category, '.', 1))) and IsText(Trim(SubField(Category, '.', 2)))
thank you @sunny_talwar