topic Re: check if a field contains an integer or something else with tFilterRow in Talend Studio

check if a field contains an integer or something else with tFilterRow

Anonymous — Sat, 16 Nov 2024 06:09:07 GMT

Hello,

I would like to check in the tFilterRow advanced mode if the ID (integer) field of my csv file contains a value different from an integer or not. The objective is to reject lines in which this ID field is empty or contains a string or a character ... But I do not know how to do it. Here is an example of my file:

id ,name,etat
18209,COLLECTIVITE LOCALE,ACT
18210,836,DEGROUPAGE,2,ACT
,836,DEG,2,ACT
wsadza,GLOBECAST,ACT
836,TRANSPAC,ACT

Here is what I tried but that does not reject the empty values and others

input_row.ID%input_row.ID != 0

Thank you for your attention

Re: check if a field contains an integer or something else with tFilterRow

akumar2301 — Thu, 04 Apr 2019 15:57:07 GMT

input_row.ID != null  && input_row.ID.matches("\\d+")

Re: check if a field contains an integer or something else with tFilterRow

Anonymous — Thu, 04 Apr 2019 16:05:49 GMT

Hello,

Thank's for your answer but I have this error :

"The method matches(String) is undefined for the type Integer"

Indeed the field ID is of type integer and I do not want anything other than an integer.

Re: check if a field contains an integer or something else with tFilterRow

akumar2301 — Thu, 04 Apr 2019 16:10:21 GMT

In this case , record will be rejected by tFileInputDelimier itself ( if it
is Integer and data is String) also you can make this field not nullable in
schema definition.

so Null value records will also get rejected.

Re: check if a field contains an integer or something else with tFilterRow

Anonymous — Thu, 04 Apr 2019 16:15:41 GMT

Great Abhishek,

Since I want to redirect the rejected lines to a file, how can I do it? I was thinking of tFilterRow but that's not the case.

thank you in advance

Re: check if a field contains an integer or something else with tFilterRow

akumar2301 — Thu, 04 Apr 2019 16:19:03 GMT

Remove "Die on Error" option in tFileInputDelimited .

You will have option to link rejects to a file.