topic My input string format is ''24-OCT-23 05.22.45.513000000 AM GMT' and I want to Reject otherthan this pattern in Talend Studio

My input string format is ''24-OCT-23 05.22.45.513000000 AM GMT' and I want to Reject otherthan this pattern

R_varma8309059731 — Fri, 15 Nov 2024 21:18:11 GMT

My input string format is ''24-OCT-23 05.22.45.513000000 AM GMT' and I want to Reject otherthan this pattern and saving in a oracle table.

How we can filter this and reject wrong formats in the input values :

for example 1: ''24-OCT-23 05.22.45.513000000'

for example 2: ''24-OCT-23 05.22.45.513000000 AM'

Anonymous — Fri, 27 Oct 2023 03:28:17 GMT

You can create an routine function to check the date pattern using regex expression, call the routine function on tFilterRow to filter the rows.

eg:

public static boolean checkDatePattern(String str)

{

boolean isDate=false;

String datePattern ="\\d{2}-\\w{3}-\\d{2} \\d{2}.\\d{2}.\\d{2}.\\d{9} \\w{2} \\w{3}";

return isDate=str.matches(datePattern);

}

Regards

Shong