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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Filtering numeric values and alpha-numeric values in a string

Hello,
I have a MSSQL String column having values like "000123", "ABC123", "00-123", etc.
I want to INSERT into a MySQL table only the Numeric values like "000123" because the target datatype is INT.
The rejected values i.e. the values which are alpha-numeric or having any special characters should be sent to a CSV file.
Can you tell me the component to be used or the process to filter just the String having numeric values ?
Labels (3)
1 Reply
TRF
Champion II
Champion II

Try with regex such as 
string.matches("^\\p{Digit}+$"))