Transformer des horaires français gmt+1 en horaires standards

gistfile1.txt

[
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Column 2 using expression value.toDate()",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Column 2",
    "expression": "value.toDate()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Column 2 using expression grel:value.partition(\" \")[2].replace(\"janvier\",\"01\").replace(\"février\",\"/01/\").replace(\"mars\",\"/03/\").replace(\"avril\",\"/04/\").replace(\"mai\",\"/05/\").replace(\"juin\",\"/06/\").replace(\"juillet\",\"/07/\").replace(\"août\",\"/08/\").replace(\"septembre\",\"/09/\").replace(\"octobre\",\"/10/\").replace(\"novembre\",\"/11/\").replace(\"décembre\",\"/12/\").replace(\", \",\"-\").replace(\" \",\"\")",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Column 2",
    "expression": "grel:value.partition(\" \")[2].replace(\"janvier\",\"01\").replace(\"février\",\"/01/\").replace(\"mars\",\"/03/\").replace(\"avril\",\"/04/\").replace(\"mai\",\"/05/\").replace(\"juin\",\"/06/\").replace(\"juillet\",\"/07/\").replace(\"août\",\"/08/\").replace(\"septembre\",\"/09/\").replace(\"octobre\",\"/10/\").replace(\"novembre\",\"/11/\").replace(\"décembre\",\"/12/\").replace(\", \",\"-\").replace(\" \",\"\")",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Column 2 using expression grel:\"0\"+value",
    "engineConfig": {
      "facets": [
        {
          "query": "^\\d{1}\\/",
          "name": "Column 2",
          "caseSensitive": false,
          "columnName": "Column 2",
          "type": "text",
          "mode": "regex"
        }
      ],
      "mode": "row-based"
    },
    "columnName": "Column 2",
    "expression": "grel:\"0\"+value",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Column 2 using expression grel:value.replace(\"-\",\" \").partition(\"U\")[0]",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Column 2",
    "expression": "grel:value.replace(\"-\",\" \").partition(\"U\")[0]",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Column 2 using expression grel:value.slice(3,5)+\"/\"+value.slice(0,2)+\"/\"+value.slice(6,16)",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Column 2",
    "expression": "grel:value.slice(3,5)+\"/\"+value.slice(0,2)+\"/\"+value.slice(6,16)",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column Column 2 using expression value.toDate()",
    "engineConfig": {
      "facets": [],
      "mode": "row-based"
    },
    "columnName": "Column 2",
    "expression": "value.toDate()",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  }
]

Fonctionne sur des données de type :

Nom de valeur	Date
test	lundi 9 février 2015, 10:17 UTC+01
test2	,mardi 10 février 2015, 12:17 UTC+01

Transformation en :

Nom de valeur	Date
test	2015-01-09T10:17:00Z
test2	2015-01-10T12:17:00Z