Validate string Date in Taledn

Four Stars

Validate string Date in Taledn

Hi All,

 

I have to validate date data which is coming as a String in 'MM/YYYY'  format. I need to validate whether input date is valid or not? Validate means it should have 12 months only and proper years.

 

Is there any function for this in Talend?

Twelve Stars

Re: Validate string Date in Taledn

hi,
you can use java regexp match methode for that :
https://docs.oracle.com/javase/7/docs/api/java/util/regex/Pattern.html

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Four Stars

Re: Validate string Date in Taledn

HI

 

I dont understand this. this has so many things. can you be please specific. is there any function in talend which I can use?

Six Stars

Re: Validate string Date in Taledn

You can use TalendDate.isDate(your date, "MM/yyyy").

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

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 3

Read about some useful Context Variable ideas

Blog