How to extract the numeric values from the String

Five Stars

How to extract the numeric values from the String

Hi iam new to the Talend. i would like to extract the numeric values from the String .ie i have column named Results..this is having the data combination of string data and numeric data in a row .i should extract only numeric data how it would be possible in talend

Forteen Stars TRF
Forteen Stars

Re: How to extract the numeric values from the String

Hi,

If you want to eliminate rows when Results field is not numeric, have a look to tConvertType.


TRF

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.