Filter row if filed have combined value like (string+Integer) ?

One Star

Filter row if filed have combined value like (string+Integer) ?

Hi All,

Ship_Cost filed have data like below:
Ship_Cost
1000
500
3000
a400

Now i want Filter the  row a400.
I know it is done through tFilterrow.I used below code in tFilterrow:
(input_row.ship_cost.matches("[^0-9]"+"[0-9]"))
But it is not filter the value a400.

Thanks,
kumar.talend
One Star

Re: Filter row if filed have combined value like (string+Integer) ?

Hello ,

Here you can test your regular expressions:

http://regex101.com/
Seventeen Stars

Re: Filter row if filed have combined value like (string+Integer) ?

hi,

just need [^0-9] to match if some caracter are not number(digit).

regards
laurent

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Have you checked out Talend’s 2019 Summer release yet?

Find out about Talend's 2019 Summer release

Blog

Talend Summer 2019 – What’s New?

Talend continues to revolutionize how businesses leverage speed and manage scale

Watch Now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog