Hi all
I am trying to normalize the below data format to solr accepted data string using Data conversion stage. The test pipeline doesnt pick the dates though regex101 matches the pattern
Source Date:2019-10-01T16:06:27.5859855+02:00
Regex:^\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}.\d{7}[\+\-]\d{2}:\d{2}
Conveted Date: yyyy-mm-dd'T'hh:mm:ss.SSSSSSS'Z' ( i tried the below formats as well)
yyyy-mm-dd'T'hh:mm:ss.SSSSSSS'Z'hh:ss
yyyy-mm-dd'T'hh:mm:ss.SSSSSSS'Z'hh
But none of the attempts picked the data field that i need to convert
Found the answer myself,posting it here
Regex:^\d{4}-\d{2}-\d{2}T\d{2}:\d{2}:\d{2}.\d{7}[\+\-]\d{2}:\d{2} ---> yyyy-mm-dd'T'hh:mm:ss.SSSSSSSXXX