https://community.qlik.com/t5/Talend-Studio/Filtering-numeric-values-and-alpha-numeric-values-in-a-string/m-p/2375838#M138152 Try with regex such as&nbsp;<BR /><PRE>string.matches("^\\p{Digit}+$"))</PRE> Tue, 16 Aug 2016 15:31:46 GMT TRF 2016-08-16T15:31:46Z https://community.qlik.com/t5/Talend-Studio/Filtering-numeric-values-and-alpha-numeric-values-in-a-string/m-p/2375837#M138151 Hello,<BR />I have a MSSQL&nbsp;String column having values like "000123", "ABC123", "00-123", etc.<BR />I want to INSERT into a MySQL table only the Numeric values like "000123" because the target datatype is INT.<BR />The rejected values i.e. the values which are alpha-numeric or having any special characters should be sent to a CSV file.<BR />Can you tell me the component to be used or the process to filter just the String having numeric values ? Sat, 16 Nov 2024 10:27:20 GMT https://community.qlik.com/t5/Talend-Studio/Filtering-numeric-values-and-alpha-numeric-values-in-a-string/m-p/2375837#M138151 Anonymous 2024-11-16T10:27:20Z https://community.qlik.com/t5/Talend-Studio/Filtering-numeric-values-and-alpha-numeric-values-in-a-string/m-p/2375838#M138152 Try with regex such as&nbsp;<BR /><PRE>string.matches("^\\p{Digit}+$"))</PRE> Tue, 16 Aug 2016 15:31:46 GMT https://community.qlik.com/t5/Talend-Studio/Filtering-numeric-values-and-alpha-numeric-values-in-a-string/m-p/2375838#M138152 TRF 2016-08-16T15:31:46Z