Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
bhaveshp90
Creator III
Creator III

Remove values which will not start with numbers

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

Labels (2)
1 Solution

Accepted Solutions
sunny_talwar

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

View solution in original post

2 Replies
sunny_talwar

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
Creator III
Creator III
Author

thank you @sunny_talwar