Parsed date error

Santi

Hello

There is an error when I am trying to do a parsed date
"Aww ... Smart Date could not find any format matching your data. Please try a custom format."

This is the error I am getting.

The date format I have is like this: December 27, 2010. and I whant to change to this 2010-12-27

Turribeach

Try “MMM DD,YYYY” as a custom format.

Sv3n-Sk4

Hello @Santi
,

Not sure it's the best solution but it works.

I would realise several steps in a prepare recipe :

1. Split on a space delimiter your input column
2. Replace the month by the corresponding number
3. Split on a , delimiter (to delete the , after the day)
4. Concatenate the columns with a - delimiter in the order you like
5. Remove the useless columns

With these steps, I got the result you wanted.

Hope it helped !

Hadrien

Santi

The output is blank

Santi

How can I replace the month to a number?

MickaelH

Hi,

The pattern you should use to parse the date in your example is MMM dd, yyyy

You can refer to the SimpleDateFormat documentation linked to the "Parse date processor": https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html

Regards,

Sv3n-Sk4

Use the step : Find and Replace

But the reponse of @MickaelH
works and is quicker!