Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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