TSV String, Convert date data to yyyy-MM format<\/div>
Converts the date data in the specified column to yyyy-MM or yyyy format and appends the value to the end of all lines.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> C1:Set tsv string. *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> C2:Set column ID of the date field of TSV string.(e.g. “3”) *<\/span>#{EL}<\/sup><\/span><\/li>\n
- C3:Select date format of conveted date data. *<\/span><\/li>\n
- C4:Select STRING type item for appended TSV string.<\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\nmain();\n\nfunction main(){\n\n const tsv = configs.get('conf_tsv');\n const dateFieldId = Number(configs.get('conf_dateFieldId'));\n const dateFormat = configs.get('conf_dateFormat');\n const conf_appendedTsv = configs.get('conf_appendedTsv');\n\n const rowArray = tsv.trim().split('\\n');\n const cells = [];\n let appendedTsv = '';\n for(let i = 0 ; i < rowArray.length ; i++){\n cells[i] = rowArray[i].split('\\t');\n cells[i].push(convertDateFormat(cells[i][dateFieldId], dateFormat));\n appendedTsv += cells[i].join('\\t');\n appendedTsv += '\\n';\n }\n\n if(conf_appendedTsv !== ''){\n engine.setDataByNumber(conf_appendedTsv, appendedTsv.slice(0,-1));\n }\n \n}\n\n\/*\n\u6587\u5b57\u306e\u65e5\u4ed8\u3092\u6307\u5b9a\u3055\u308c\u305f\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306b\u5909\u63db\u3057\u3066\u6587\u5b57\u3067\u8fd4\u3059\u3002\n@param dateStr {string} (e.g. "yyyy" "yyyy-MM")\n@param dateFormat {string} (e.g. "2022-11-01")\n@return Date.parse() \u3067\u89e3\u91c8\u3067\u304d\u306a\u3044\u6587\u5b57\u306e\u5834\u5408\u3001'' \u304c\u8fd4\u3055\u308c\u307e\u3059\u3002\n*\/\nfunction convertDateFormat(dateStr, dateFormat){\n let date;\n try{\n date = new Date(dateStr);\n return dateFormatter.format(dateFormat, date);\n }catch(e){\n engine.log(String(e));\n engine.log('error: ' + dateStr + ' ('+ dateFormat +')');\n return '';\n }\n}\n\n\/*\n- \u6307\u5b9a\u3059\u308b\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u5217ID\u306f\u30bc\u30ed\u304b\u3089\u30b9\u30bf\u30fc\u30c8\u3057\u307e\u3059\u3002\n- \u5909\u63db\u524d\u306e\u6587\u5b57\u5217\u306f Date.parse() \u3067\u89e3\u91c8\u3055\u308c\u308b\u5834\u5408\u306b\u6307\u5b9a\u3057\u305f\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u306e\u65e5\u4ed8\u6587\u5b57\u5217\u306b\u5909\u63db\u3055\u308c\u307e\u3059\u3002\n - YYYY-MM-DDTHH:mm:ss.sssZ (e.g. "2022-10-10T12:34:56.789" "2022-10-10" etc.)\n- \u6307\u5b9a\u3055\u308c\u305f\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u5024\u304c\u9069\u5207\u306b\u5909\u63db\u3055\u308c\u306a\u304b\u3063\u305f\u5834\u5408\u3001\u7a7a\u6587\u5b57('')\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\n- The column ID of the date field you specify starts at zero.\n- The string before conversion is converted to a date string of the specified format when interpreted by Date.parse().\n- If the value of the specified field is not properly converted, an empty character ('') is added.\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- \n
- tsv-string-convert-date-to-yyyyMM-202211.xml<\/a>\n
- \n
- 2022-11-17 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n
- tsv-string-convert-date-to-yyyyMM-2023.xml<\/a>\n
- \n
- 2023-08-16 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n
- for “GraalJS standard (engine-type 3)” on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
The Addon-import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- \n
- The column ID of the date field you specify starts at zero.<\/li>\n\n\n\n
- The string before conversion is converted to a date string of the specified format when interpreted by Date.parse().<\/li>\n\n\n\n
- If the value of the specified field is not properly converted, an empty character (”) is added.<\/li>\n<\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/tsv-string-convert-date-to-yyyyMM-cap1-en-1024x576.png?resize=1024%2C576&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/11\/tsv-string-convert-date-to-yyyyMM-cap2-en-466x630.png?resize=466%2C630&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> See also<\/h3>\n\n\n\n
- <\/i><\/span> C2:Set column ID of the date field of TSV string.(e.g. “3”) *<\/span>#{EL}<\/sup><\/span><\/li>\n