I need to extract data from Mongodb just like the tutorial at http://wiki.pentaho.com/display/BAD/Create+a+Report+with+MongoDB
Here is an example of one of the field entries:
This is ISO 8601 format. My problem is that my date data doesn't match any of the pre-set "format"s in the pulldown menu within the 'fields' tab of the "Json Input" step.
One of the pre-set formats, for example, is
However as you can see, my data uses dashes instead of forwardslash, has a 'T' instead of a space between date and time, and has a trailing 'Z' at the end of each timestamp. I have tried entering in the format manually, i.e.
But the non-standard 'T' and 'Z' characters (along with possible other things) are causing it to fail. Is there some syntax or method I can use to modify the format field to efficiently pull out this date data?
Thank you so much,