Skip to content

Instantly share code, notes, and snippets.

@billmetangmo

billmetangmo/transform_badformat_date_to_iso

Created April 10, 2021 22:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save billmetangmo/4af3eedd130c57bb8f966d353071b95f to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save billmetangmo/4af3eedd130c57bb8f966d353071b95f to your computer and use it in GitHub Desktop.
Download ZIP
Open refine Jython interpreter
Raw
transform_badformat_date_to_iso
from datetime import datetime
date_time_obj = datetime.strptime(str(value),'%Y-%m-%d-%H-%M-%S')
return date_time_obj.isoformat()
# Openrefine supports ISO-8601
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment