topic Remove values which will not start with numbers in QlikView

Remove values which will not start with numbers

bhaveshp90 — Sat, 16 Nov 2024 04:13:56 GMT

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

sunny_talwar — Fri, 08 Mar 2019 20:13:03 GMT

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)))

bhaveshp90 — Fri, 08 Mar 2019 21:37:03 GMT