{"id":111749,"date":"2021-08-24T13:28:42","date_gmt":"2021-08-24T04:28:42","guid":{"rendered":"https:\/\/support.questetra.com\/?p=111749"},"modified":"2023-08-17T18:37:22","modified_gmt":"2023-08-17T09:37:22","slug":"tsv-string-convert-2021","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-convert-2021\/","title":{"rendered":"TSV String, Convert"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-default\" id=\"\" style=\"border-color:#003e04;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#267137;color:#ffffff;border-top-left-radius:0px;border-top-right-radius:0px\">TSV String, Convert<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> Changes the column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like &#8220;0,1,3,0&#8221;. The new TSV text can also be stored in formats such as TSV file format and CSV file format.<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"far fa-edit fa-lg\"><\/i><\/span> A1: Set Original TSV Text<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B1: Set New Column Order (eg &#8220;0,1,3,0&#8221; )<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> C1: Select STRING DATA that stores New TSV Text (update)<\/li>\n<li> D1: Select FILE DATA that stores UTF8-TSV file (append)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> D2: Set SaveAs FileName for UTF8-TSV (eg &#8220;#{#q_name}.tsv&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> E1: Select FILE DATA that stores UTF16LE-TSV file (append)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> E2: Set SaveAs FileName for UTF16LE-TSV (eg &#8220;#{#q_name}.csv&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> F1: Select FILE DATA that stores UTF8-CSV file (append)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> F2: Set SaveAs FileName for UTF8-CSV (eg &#8220;#{#q_name}.csv&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> G1: Select FILE DATA that stores Plain-UTF8-CSV file (append)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> G2: Set SaveAs FileName for Plain-UTF8-CSV (&#8220;#{#q_name}.csv&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<li> H1: Select FILE DATA that stores Plain-SJIS-CSV file (append)<\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> H2: Set SaveAs FileName for Plain-SJIS-CSV (&#8220;#{#q_name}.csv&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInputTsv      = configs.get( &quot;StrConfA1&quot; );         \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n  if( strInputTsv    === &quot;&quot; ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A1: TSV} is empty \\n&quot; );\n  }\n  const arrInputTsv    = strInputTsv.split(&quot;\\n&quot;);\n  let   numColMaxWidth = 0;\n  for( let i = 0; i &lt; arrInputTsv.length; i++ ){\n    let arrCells = arrInputTsv[i].split(&quot;\\t&quot;);\n    if( numColMaxWidth &lt; arrCells.length ){ numColMaxWidth = arrCells.length; }\n  }\n  engine.log( &quot; AutomatedTask TsvDataCheck: &quot; + \n              numColMaxWidth + &quot;w &quot; + arrInputTsv.length + &quot;h&quot; );\n\nlet   strColIds        = configs.get( &quot;StrConfB1&quot; );         \/\/ NotRequired \/\/\/\/\/\/\/\/\/\/\/\/\/\n  if( strColIds      === &quot;&quot; ){\n    for( let i = 0; i &lt; numColMaxWidth; i++ ){\n      strColIds += i + &quot;&quot;;\n      if( i !== numColMaxWidth - 1 ){\n        strColIds += &quot;,&quot;;\n      }\n    }\n  } \/\/ strColIds: &quot;0,1,2,3,,&quot;\n  const regCsv = \/^[-?0-9][-?0-9,]*[0-9]$\/; \/\/ RegExp\n  if( ! regCsv.test( strColIds ) ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {B1: ColumnOrder} allows only numbers and commas \\n&quot; );\n  }\n\nconst strPocketOutputTsv    = configs.getObject( &quot;SelectConfC1&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\n\nconst strPid = processInstance.getProcessInstanceId() + &quot;&quot;;\nconst filesPocketUtf8tsv    = configs.getObject( &quot;SelectConfD1&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\nlet   strSaveasUtf8tsv      = configs.get      ( &quot;StrConfD2&quot; );    \/\/ NotRequired \/\/\/\/\/\/\/\n  if( strSaveasUtf8tsv    === &quot;&quot; ){\n      strSaveasUtf8tsv      = strPid + &quot;-urf8.tsv&quot;;\n  }\nconst filesPocketUtf16letsv = configs.getObject( &quot;SelectConfE1&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\nlet   strSaveasUtf16letsv   = configs.get      ( &quot;StrConfE2&quot; );    \/\/ NotRequired \/\/\/\/\/\/\/\n  if( strSaveasUtf16letsv === &quot;&quot; ){\n      strSaveasUtf16letsv   = strPid + &quot;-urf16.csv&quot;;\n  }\nconst filesPocketUtf8csv    = configs.getObject( &quot;SelectConfF1&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\nlet   strSaveasUtf8csv      = configs.get      ( &quot;StrConfF2&quot; );    \/\/ NotRequired \/\/\/\/\/\/\/\n  if( strSaveasUtf8csv    === &quot;&quot; ){\n      strSaveasUtf8csv      = strPid + &quot;-urf8.csv&quot;;\n  }\nconst filesPocketPutf8csv   = configs.getObject( &quot;SelectConfG1&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\nlet   strSaveasPutf8csv     = configs.get      ( &quot;StrConfG2&quot; );    \/\/ NotRequired \/\/\/\/\/\/\/\n  if( strSaveasPutf8csv   === &quot;&quot; ){\n      strSaveasPutf8csv     = strPid + &quot;-purf8.csv&quot;;\n  }\nconst filesPocketPsjiscsv   = configs.getObject( &quot;SelectConfH1&quot; ); \/\/ NotRequired \/\/\/\/\/\/\/\nlet   strSaveasPsjiscsv     = configs.get      ( &quot;StrConfH2&quot; );    \/\/ NotRequired \/\/\/\/\/\/\/\n  if( strSaveasPsjiscsv   === &quot;&quot; ){\n      strSaveasPsjiscsv     = strPid + &quot;-psjis.csv&quot;;\n  }\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\nlet arrColIds = strColIds.split(&quot;,&quot;);\n\nlet strOutputTsv = &quot;&quot;;\nfor( let i = 0; i &lt; arrInputTsv.length; i++ ){\n  if( arrInputTsv[i] === &quot;&quot; ){ continue; } \/\/ Skip blank lines\n  let arrInputCells = arrInputTsv[i].split(&quot;\\t&quot;);\n  for( let j = 0; j &lt; arrColIds.length; j++ ){\n    let numCelId = parseInt( arrColIds[j] );\n    if( 0 &lt;= numCelId && numCelId &lt; arrInputCells.length ){\n      strOutputTsv += arrInputCells[numCelId];\n    }else{\n      strOutputTsv += &quot;&quot;;\n    }\n    if( j !== arrColIds.length - 1 ){\n      strOutputTsv += &quot;\\t&quot;;\n    }\n  }\n  strOutputTsv += &quot;\\n&quot;;\n}\nstrOutputTsv = strOutputTsv.slice( 0, -1 ); \/\/ delete last &quot;\\n&quot;\n\nlet strOutputTsvEscaped = &quot;&quot;; \/\/ Escaped with another double quote, Enclosed in double quotes\nfor( let i = 0; i &lt; arrInputTsv.length; i++ ){\n  if( arrInputTsv[i] === &quot;&quot; ){ continue; } \/\/ Skip blank lines\n  let arrInputCells = arrInputTsv[i].split(&quot;\\t&quot;);\n  for( let j = 0; j &lt; arrColIds.length; j++ ){\n    let numCelId = parseInt( arrColIds[j] );\n    if( 0 &lt;= numCelId && numCelId &lt; arrInputCells.length ){\n      strOutputTsvEscaped += &#39;&quot;&#39; + \/\/ (RFC 4180 2-5)\n                             arrInputCells[numCelId].replace( \/&quot;\/g, &#39;&quot;&quot;&#39; ) + \/\/ (RFC 4180 2-7)\n                             &#39;&quot;&#39;;\n    }else{\n      strOutputTsvEscaped += &#39;&quot;&quot;&#39;;\n    }\n    if( j !== arrColIds.length - 1 ){\n      strOutputTsvEscaped += &quot;\\t&quot;;\n    }\n  }\n  strOutputTsvEscaped += &quot;\\n&quot;;\n}\nstrOutputTsvEscaped = strOutputTsvEscaped.slice( 0, -1 ); \/\/ delete last &quot;\\n&quot;\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketOutputTsv !== null ){ \/\/ STRING\n  engine.setData( strPocketOutputTsv,    strOutputTsv );\n}\nif( filesPocketUtf8tsv !== null ){ \/\/ FILE\n  let filesAttachedUtf8tsv = engine.findData( filesPocketUtf8tsv ); \/\/ java.util.ArrayList\n  if( filesAttachedUtf8tsv === null ) {\n    engine.log( &quot; AutomatedTask FilesArray {Utf8tsv}: (empty)&quot; );\n    filesAttachedUtf8tsv = new java.util.ArrayList();\n  }else{\n    engine.log( &quot; AutomatedTask FilesArray {Utf8tsv}: &quot; +\n                filesAttachedUtf8tsv.size() + &quot; files&quot; );\n  }\n  filesAttachedUtf8tsv.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      strSaveasUtf8tsv,\n      &quot;text\/tab-separated-values; charset=UTF-8&quot;,\n      strOutputTsv\n    )\n  );\n  engine.setData( filesPocketUtf8tsv, filesAttachedUtf8tsv );\n}\nif( filesPocketUtf16letsv !== null ){ \/\/ FILE\n  let filesAttachedUtf16letsv = engine.findData( filesPocketUtf16letsv ); \/\/ java.util.ArrayList\n  if( filesAttachedUtf16letsv === null ) {\n    engine.log( &quot; AutomatedTask FilesArray {Utf16letsv}: (empty)&quot; );\n    filesAttachedUtf16letsv = new java.util.ArrayList();\n  }else{\n    engine.log( &quot; AutomatedTask FilesArray {Utf16letsv}: &quot; +\n                filesAttachedUtf16letsv.size() + &quot; files&quot; );\n  }\n  filesAttachedUtf16letsv.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      strSaveasUtf16letsv,\n      &quot;text\/tab-separated-values; charset=x-UTF-16LE-BOM&quot;,\n      strOutputTsv\n    )\n  );\n  engine.setData( filesPocketUtf16letsv, filesAttachedUtf16letsv );\n}\nif( filesPocketUtf8csv !== null ){ \/\/ FILE\n  let filesAttachedUtf8csv = engine.findData( filesPocketUtf8csv ); \/\/ java.util.ArrayList\n  if( filesAttachedUtf8csv === null ) {\n    engine.log( &quot; AutomatedTask FilesArray {Utf8csv}: (empty)&quot; );\n    filesAttachedUtf8csv = new java.util.ArrayList();\n  }else{\n    engine.log( &quot; AutomatedTask FilesArray {Utf8csv}: &quot; +\n                filesAttachedUtf8csv.size() + &quot; files&quot; );\n  }\n  filesAttachedUtf8csv.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      strSaveasUtf8csv,\n      &quot;text\/csv; charset=UTF-8&quot;,\n      strOutputTsvEscaped.replace( \/\\t\/g, &quot;,&quot; )\n    )\n  );\n  engine.setData( filesPocketUtf8csv, filesAttachedUtf8csv );\n}\nif( filesPocketPutf8csv !== null ){ \/\/ FILE\n  let filesAttachedPutf8csv = engine.findData( filesPocketPutf8csv ); \/\/ java.util.ArrayList\n  if( filesAttachedPutf8csv === null ) {\n    engine.log( &quot; AutomatedTask FilesArray {Putf8csv}: (empty)&quot; );\n    filesAttachedPutf8csv = new java.util.ArrayList();\n  }else{\n    engine.log( &quot; AutomatedTask FilesArray {Putf8csv}: &quot; +\n                filesAttachedPutf8csv.size() + &quot; files&quot; );\n  }\n  filesAttachedPutf8csv.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      strSaveasPutf8csv,\n      &quot;text\/tab-separated-values; charset=UTF-8&quot;,\n      strOutputTsv.replace( \/,\/g, &quot;&quot; ).replace( \/\\t\/g, &quot;,&quot; )\n    )\n  );\n  engine.setData( filesPocketPutf8csv, filesAttachedPutf8csv );\n}\nif( filesPocketPsjiscsv !== null ){ \/\/ FILE\n  let filesAttachedPsjiscsv = engine.findData( filesPocketPsjiscsv ); \/\/ java.util.ArrayList\n  if( filesAttachedPsjiscsv === null ) {\n    engine.log( &quot; AutomatedTask FilesArray {Psjiscsv}: (empty)&quot; );\n    filesAttachedPsjiscsv = new java.util.ArrayList();\n  }else{\n    engine.log( &quot; AutomatedTask FilesArray {Psjiscsv}: &quot; +\n                filesAttachedPsjiscsv.size() + &quot; files&quot; );\n  }\n  filesAttachedPsjiscsv.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      strSaveasPsjiscsv,\n      &quot;text\/tab-separated-values; charset=Shift_JIS&quot;,\n      strOutputTsv.replace( \/,\/g, &quot;&quot; ).replace( \/\\t\/g, &quot;,&quot; )\n    )\n  );\n  engine.setData( filesPocketPsjiscsv, filesAttachedPsjiscsv );\n}\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/*\nNotes:\n- Used when incorporating &quot;the step in which TSV text is automatically edited&quot; into the workflow.\n    - When the process reaches this automated task, the TSV stored in string data is automatically processed.\n        - Column reordering\n        - File output (`text\/tab-separated-values`,`text\/csv`)\n- The output order is specified by enumerating the column IDs of the input TSV (lile &quot;0&quot; and &quot;3&quot;).\n    - If an inaccessible ID (such as &quot;999&quot; or &quot;-1&quot;) is specified, an empty string (length 0) will be inserted.\n        - The number of columns can be added. (eg; combining TSVs, adding header line, etc.)\n    - If not specified, all columns will be output as they were originally.\n        - If the number of cells differs depending on the row, the output will be adjusted to the maximum number.\n- Blank lines (line breaks only) in the input TSV text are ignored.\n- If SaveAs is not set, the file name will be `{pid}-urf8.csv` etc.\n\nAPPENDIX:\n- The input TSV is parsed as the simplest tab-delimited text. (`UTF-8` encoding)\n    - Double quotes are interpreted as cell data just like any other character.\n        - It is not possible to have &quot;tab&quot; or &quot;line feed&quot; data in the cell data (in the field).\n    - LF is assumed as the line feed code.\n        - Even if it is CRLF or CR, it can be processed normally.\n    - https:\/\/en.wikipedia.org\/wiki\/Tab-separated_values\n- If you want to combine two TSV data as an input TSV, set Config in two lines.\n    - `#{#q_tsv_string_data_1}`\n    - `#{#q_tsv_string_data_2}`\n- If you want to add header line as input TSV, add the header line to the first line of Config.\n    - `header-cel-A` TAB `header-cel-B` TAB `header-cel-C`\n    - `#{#q_tsv_string_data}`\n- The number of cells in the output TSV is the same for all rows. (Fixed Column Width)\n    - The line feed code is not added to the last line.\n- `UTF-8`\n    - Compactly encodes more than 1 million Unicode characters in the world with 1 to 4 bytes.\n    - It became the most common character code in 2008 and is used in 97% of web pages as of 2021.\n    - UTF-8 is superset of US-ASCII (single-byte characters). (upward compatible)\n        - That is, ASCII files are also UTF-8 files. (US-ASCII is a subset of UTF-8)\n        - Similarly, ASCII files are also Shift_JIS files.\n- `UTF-16`\n    - Encodes over 1 million Unicode characters in the world with 2-4 bytes.\n    - If there are many Asian characters such as Japanese and Chinese, encode them compactly.\n- File output can be output in several formats.\n    - UTF8 TSV **Recommended**\n        - MIME type: `text\/tab-separated-values; charset=UTF-8`\n            - Encoding: `UTF-8` no BOM (utf8n, UTF-8N)\n            - Linebreak: `LF`\n            - Delimiter: `TAB`\n            - https:\/\/ja.wikipedia.org\/wiki\/Tab-Separated_Values\n        - It is very often used for File-based Integration.\n            - As a file for Windows software, characters may be garbled (misidentified by Shift_JIS etc.).\n        - The simplest and most versatile tab-delimited text.\n            - Cell values \u200b\u200b(field values) are not enclosed in quotation marks such as double quotes.\n            - Double quotes in cells (in fields) are retained as double quotes.\n    - UTF16LE TSV (Excel compatible CSV) **Recommended**\n        - MIME type: `text\/csv; charset=x-UTF-16LE-BOM`\n            - Encoding: `x-UTF-16LE-BOM`\n            - Linebreak: `LF`\n            - Delimiter: `TAB`\n            - https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values\n            - In many cases, it is called a CSV file and the extension is `.csv`, but in reality it is tab-delimited.\n            - The file will be several bytes larger than `charset=UTF-16` and` charset=UTF-16BE`.\n        - Very often used as a file for Excel import. (OS does not matter \/ Risk of garbled characters is almost avoided)\n            - Often used as a file for Windows software.\n            - The file for File-based Integration may cause a problem.\n            - It cannot be used as a file for legacy software (for example, software that assumes US-ASCII).\n        - The simplest and most versatile tab-delimited text.\n            - Cell values\u200b(field values) are not enclosed in quotation marks such as double quotes.\n            - Double quote characters in cells (in fields) are retained as double quote characters.\n    - UTF8 CSV\n        - MIME type: `text\/csv; charset=UTF-8`\n            - Encoding: `UTF-8` no BOM (utf8n, UTF-8N)\n            - Linebreak: `LF`\n            - Delimiter: `,` (COMMA)\n        - It is very often used for File-based Integration.\n            - As a file for Windows software, characters may be garbled (misidentified by Shift_JIS etc.).\n        - A comma-separated format output by many software.\n            - All cell values \u200b\u200b(field values) are enclosed in double quotes. (RFC 4180 2-5)\n            - Double quote characters in cells are escaped preceded by double quote characters. (RFC 4180 2-7)\n    - Plain UTF8 CSV (Extra Commas Removed)\n        - MIME type: `text\/csv; charset=UTF-8`\n            - Encoding: `UTF-8` no BOM (utf8n, UTF-8N)\n            - Linebreak: `LF`\n            - Delimiter: `,` (COMMA)\n        - Often used for File-based Integration\n            - As a file for Windows software, characters may be garbled (misidentified by Shift_JIS etc.).\n        - Comma separated format with extra comma characters removed.\n            - All comma characters (digit separators, etc.) in the cell (in the field) are removed.\n            - It is often used as a management file for accounting data and aggregated data.\n            - Cell values\u200b(field values) are not enclosed in quotation marks such as double quotes.\n            - If there are double quote characters in the cell (in the field), they are all removed. (RFC 4180 2-5)\n    - Plain SJIS CSV (Extra Commas Removed)\n        - MIME type: `text\/csv; charset=Shift_JIS`\n            - Encoding: `Shift_JIS`\n            - Linebreak: `LF`\n            - Delimiter: `,` (COMMA)\n        - Often used for File-based Integration\n            - It is very often used as a file for importing Excel in Japan. (Almost avoiding the risk of garbled characters)\n            - It is very often used as a file for Windows software in Japan. (Almost avoiding the risk of garbled characters)\n        - Comma separated format with extra comma characters removed.\n            - All comma characters (digit separators, etc.) in the cell (in the field) are removed.\n            - It is often used as a management file for aggregated data, accounting data, transfer data, etc. in Japan.\n            - Cell values (field values) are not enclosed in quotation marks such as double quotes.\n            - If there are double quote characters in the cell (in the field), they are all removed. (RFC 4180 2-5)\n    - If you want to convert to another encoding, consider the downstream arrangement of &quot;Text file, encoding conversion&quot;.\n        - `charset=UTF-16` (Unicode [characters around the world])\n        - `charset=UTF-16BE` (Unicode [characters around the world])\n        - `charset=UTF-16LE` (Unicode [characters around the world])\n        - `charset=UTF-32` (Unicode [characters around the world])\n        - `charset=x-UTF-32LE-BOM` (Unicode [characters around the world])\n        - `charset=ISO-8859-1` (Western language characters)\n        - `charset=Shift_JIS` (Japanese characters)\n        - `charset=Big5` (Traditional Chinese characters)\n        - `charset=GB2312` (Simplified Chinese EUC characters)\n        - `charset=GBK` (Simplified Chinese GB characters)\n        - `charset=KOI8-R` (Russian)\n        - In addition, &quot;UTF8B (UTF-8 with BOM)&quot; cannot be output. (File for Windows \/ pray for its eradication)\n        - https:\/\/docs.oracle.com\/javase\/9\/intl\/supported-encodings.htm\n\n\nNotes-ja:\n- \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u5185\u306b\u300cTSV\u30c6\u30ad\u30b9\u30c8\u304c\u81ea\u52d5\u7684\u306b\u52a0\u5de5\u3055\u308c\u308b\u5de5\u7a0b\u300d\u3092\u7d44\u307f\u8fbc\u3080\u969b\u306b\u5229\u7528\u3057\u307e\u3059\u3002\n    - \u6848\u4ef6\u304c\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u305fTSV\u304c\u81ea\u52d5\u7684\u306b\u52a0\u5de5\u3055\u308c\u307e\u3059\u3002\n        - \u30ab\u30e9\u30e0\u306e\u4e26\u3079\u66ff\u3048\u3001\u53d6\u6368\u9078\u629e\n        - \u30d5\u30a1\u30a4\u30eb\u5316 \uff08 `text\/tab-separated-values`, `text\/csv` \uff09\n- \u51fa\u529b\u9806\u306f\u5165\u529bTSV\u306e\u5217ID\uff08&quot;0&quot; \u3084 &quot;3&quot; \u306a\u3069\uff09\u3092\u5217\u6319\u3057\u3066\u6307\u5b9a\u3057\u307e\u3059\u3002\n    - \u30a2\u30af\u30bb\u30b9\u3067\u304d\u306a\u3044\u5217ID\uff08&quot;999&quot; \u3084 &quot;-1&quot; \u306a\u3069\uff09\u304c\u6307\u5b9a\u3055\u308c\u305f\u5834\u5408\u3001\u7a7a\u6587\u5b57\uff08\u9577\u30550\u306e\u6587\u5b57\u5217\uff09\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002\n        - \u30ab\u30e9\u30e0\u6570\u306e\u8ffd\u52a0\u304c\u53ef\u80fd\u3067\u3059\u3002 \uff08TSV \u540c\u58eb\u306e\u7d50\u5408\u3001\u30d8\u30c3\u30c0\u884c\u306e\u8ffd\u52a0\u3001\u306a\u3069\u306e\u7528\u9014\uff09\n    - \u6307\u5b9a\u304c\u306a\u3044\u5834\u5408\u3001\u5168\u3066\u306e\u5217\uff08\u30ab\u30e9\u30e0\uff09\u3092\u30aa\u30ea\u30b8\u30ca\u30eb\u901a\u308a\u306b\u51fa\u529b\u3057\u307e\u3059\u3002\n        - \u884c\u306b\u3088\u3063\u3066\u30bb\u30eb\u306e\u6570\u304c\u7570\u306a\u308b\u5834\u5408\u3001\u6700\u5927\u6570\u306b\u3042\u308f\u305b\u3066\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n- TSV\u30c6\u30ad\u30b9\u30c8\uff08\u5165\u529b\uff09\u5185\u306e\u7a7a\u884c\uff08\u6539\u884c\u306e\u307f\u306e\u884c\uff09\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n- \u5225\u540d\u4fdd\u5b58\u304c\u672a\u8a2d\u5b9a\u306e\u5834\u5408\u3001`{pid}-urf8.csv` \u3068\u3044\u3063\u305f\u30d5\u30a1\u30a4\u30eb\u540d\u306b\u306a\u308a\u307e\u3059\u3002\n\nAPPENDIX-ja:\n- \u5165\u529bTSV\u306f\u300c\u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u30c6\u30ad\u30b9\u30c8\u300d\u3068\u3057\u3066\u89e3\u6790\u3055\u308c\u307e\u3059\u3002 \uff08`UTF-8` encoding\uff09\n    - \u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\uff08\u4e8c\u91cd\u5f15\u7528\u7b26\uff09\u306b\u3088\u308b\u56f2\u307f\u306f\u3001\u4ed6\u306e\u6587\u5b57\u3068\u540c\u3058\u3088\u3046\u306b\u30bb\u30eb\u30c7\u30fc\u30bf\u3068\u3057\u3066\u89e3\u91c8\u3055\u308c\u307e\u3059\u3002\n        - \u30bb\u30eb\u30c7\u30fc\u30bf\u5185\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\uff09\u306b\u300c\u30bf\u30d6\u300d\u3084\u300c\u6539\u884c\u300d\u306e\u30c7\u30fc\u30bf\u3092\u6301\u305f\u305b\u308b\u3053\u3068\u306f\u3067\u304d\u307e\u305b\u3093\u3002\n    - \u6539\u884c\u30b3\u30fc\u30c9\u306fLF\u304c\u60f3\u5b9a\u3055\u308c\u307e\u3059\u3002\n        - \u4eee\u306bCRLF\u3084CR\u3067\u3042\u3063\u3066\u3082\u3001\u6b63\u5e38\u306b\u51e6\u7406\u53ef\u80fd\u3067\u3059\u3002\n    - https:\/\/en.wikipedia.org\/wiki\/Tab-separated_values\n- \u3082\u3057\u300c2\u3064\u306eTSV\u30c7\u30fc\u30bf\u3092\u7d50\u5408\u300d\u3057\u3066\u5165\u529bTSV\u3068\u3057\u305f\u3044\u5834\u5408\u3001Config \u3092\uff12\u884c\u306b\u5206\u3051\u3066\u8a2d\u5b9a\u3057\u307e\u3059\u3002\n    - `#{#q_tsv_string_data_1}`\n    - `#{#q_tsv_string_data_2}`\n- \u3082\u3057\u300c\u30d8\u30c3\u30c0\u884c\u3092\u8ffd\u52a0\u300d\u3057\u305f\u4e0a\u3067\u5165\u529bTSV\u306b\u3057\u305f\u3044\u5834\u5408\u3001Config \u306e\uff11\u884c\u76ee\u306b\u30d8\u30c3\u30c0\u884c\u3092\u8ffd\u8a18\u3057\u307e\u3059\u3002\n    - `header-cel-A` TAB `header-cel-B` TAB `header-cel-C`\n    - `#{#q_tsv_string_data}`\n- \u51fa\u529bTSV\u306b\u304a\u3051\u308b\u30bb\u30eb\u306e\u6570\u306f\u3001\u5168\u3066\u306e\u884c\u3067\u540c\u3058\u6570\u3068\u306a\u308a\u307e\u3059\u3002(Fixed Column Width)\n    - \u306a\u304a\u3001\u6700\u7d42\u884c\u306b\u6539\u884c\u30b3\u30fc\u30c9\u306f\u4ed8\u4e0e\u3055\u308c\u307e\u305b\u3093\u3002\n- `UTF-8`\n    - \u4e16\u754c100\u4e07\u7a2e\u4ee5\u4e0a\u306eUnicode\u6587\u5b57\u3092\u30011\uff5e4\u30d0\u30a4\u30c8\u3067\u30b3\u30f3\u30d1\u30af\u30c8\u306b\u30a8\u30f3\u30b3\u30fc\u30c9\u3057\u307e\u3059\u3002\n    - 2008\u5e74\u306b\u6700\u3082\u4e00\u822c\u7684\u306a\u6587\u5b57\u30b3\u30fc\u30c9\u3068\u306a\u308a\u30012021\u5e74\u6642\u70b9\u306797%\u306e\u30a6\u30a7\u30d6\u30da\u30fc\u30b8\u3067\u5229\u7528\u3055\u308c\u3066\u3044\u307e\u3059\u3002\n    - UTF-8 \u306f US-ASCII\uff081\u30d0\u30a4\u30c8\u6587\u5b57\uff09\u306e\u4e0a\u4f4d\u4e92\u63db\u3067\u3059\u3002\uff08US-ASCII \u306f UTF-8 \u306e\u30b5\u30d6\u30bb\u30c3\u30c8\u3067\u3059\uff09\n        - \u3059\u306a\u308f\u3061 ASCII \u30d5\u30a1\u30a4\u30eb\u306f UTF-8 \u30d5\u30a1\u30a4\u30eb\u3067\u3082\u3042\u308a\u307e\u3059\u3002\n        - \u540c\u69d8\u306b ASCII \u30d5\u30a1\u30a4\u30eb\u306f Shift_JIS \u30d5\u30a1\u30a4\u30eb\u3067\u3082\u3042\u308a\u307e\u3059\u3002\n- `UTF-16`\n    - \u4e16\u754c100\u4e07\u7a2e\u4ee5\u4e0a\u306eUnicode\u6587\u5b57\u3092\u30012\uff5e4\u30d0\u30a4\u30c8\u3067\u30a8\u30f3\u30b3\u30fc\u30c9\u3057\u307e\u3059\u3002\n    - \u65e5\u672c\u8a9e\u3084\u4e2d\u56fd\u8a9e\u306a\u3069\u306e\u30a2\u30b8\u30a2\u6587\u5b57\u304c\u591a\u3044\u5834\u5408\u306f\u3001\u30b3\u30f3\u30d1\u30af\u30c8\u306b\u30a8\u30f3\u30b3\u30fc\u30c9\u3057\u307e\u3059\u3002\n- \u30d5\u30a1\u30a4\u30eb\u51fa\u529b\u306f\u3001\u5e7e\u3064\u304b\u306e\u66f8\u5f0f\u3067\u51fa\u529b\u53ef\u80fd\u3067\u3059\u3002\n    - UTF8 TSV **\u3010\u63a8\u5968\u3011**\n        - MIME type: `text\/tab-separated-values; charset=UTF-8`\n            - Encoding (\u7b26\u53f7\u5316\u65b9\u5f0f): `UTF-8` no BOM (utf8n, UTF-8N)\n            - Linebreak (\u6539\u884c\u30b3\u30fc\u30c9): `LF`\n            - Delimiter (\u533a\u5207\u308a\u8a18\u53f7): `TAB`\n            - https:\/\/ja.wikipedia.org\/wiki\/Tab-Separated_Values\n        - \u30b7\u30b9\u30c6\u30e0\u9023\u643a\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3068\u3066\u3082\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\n            - Windows\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u7528\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u306f\u3001\u6587\u5b57\u5316\u3051\u3059\u308b\uff08Shift_JIS\u7b49\u306b\u8aa4\u8a8d\u3055\u308c\u308b\uff09\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n        - \u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u3067\u6c4e\u7528\u7684\u306a\u30bf\u30d6\u533a\u5207\u308a\u30c6\u30ad\u30b9\u30c8\u3067\u3059\u3002\n            - \u30bb\u30eb\u5024\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5024\uff09\u304c\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u7b49\u306e\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n            - \u30bb\u30eb\u5185\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\uff09\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u306f\u3001\u305d\u306e\u307e\u307e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u3068\u3057\u3066\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n    - UTF16LE TSV (Excel\u4e92\u63db CSV) **\u3010\u63a8\u5968\u3011**\n        - MIME type: `text\/csv; charset=x-UTF-16LE-BOM`\n            - Encoding (\u7b26\u53f7\u5316\u65b9\u5f0f): `x-UTF-16LE-BOM`\n            - Linebreak (\u6539\u884c\u30b3\u30fc\u30c9): `LF`\n            - Delimiter (\u533a\u5207\u308a\u8a18\u53f7): `TAB`\n            - https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values\n            - \u591a\u304f\u306e\u5834\u5408CSV\u30d5\u30a1\u30a4\u30eb\u3068\u547c\u3070\u308c\u3001\u62e1\u5f35\u5b50\u3082`.csv`\u3068\u3055\u308c\u307e\u3059\u304c\u3001\u5b9f\u614b\u3068\u3057\u3066\u306f\u30bf\u30d6\u533a\u5207\u308a\u3067\u3059\u3002\n            - `charset=UTF-16` \u3084 `charset=UTF-16BE` \u3088\u308a\u3001\u6570\u30d0\u30a4\u30c8\u5927\u304d\u306a\u30d5\u30a1\u30a4\u30eb\u306b\u306a\u308a\u307e\u3059\u3002\n        - Excel\u30a4\u30f3\u30dd\u30fc\u30c8\u7528\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3068\u3066\u3082\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\uff08OS\u4e0d\u554f\uff0f\u6587\u5b57\u5316\u3051\u30ea\u30b9\u30af\u307b\u307c\u56de\u907f\uff09\n            - Windows\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u7528\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\n            - \u30b7\u30b9\u30c6\u30e0\u9023\u643a\u7528\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u306f\u3001\u4e0d\u5177\u5408\u306e\u539f\u56e0\u3068\u306a\u308b\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n            - \u30ec\u30ac\u30b7\u30fc\u30bd\u30d5\u30c8\uff08\u305f\u3068\u3048\u3070 US-ASCII \u3092\u524d\u63d0\u3068\u3059\u308b\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\uff09\u7528\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u306f\u3001\u5229\u7528\u3067\u304d\u307e\u305b\u3093\u3002\n        - \u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u3067\u6c4e\u7528\u7684\u306a\u30bf\u30d6\u533a\u5207\u308a\u30c6\u30ad\u30b9\u30c8\u3067\u3059\u3002\n            - \u30bb\u30eb\u5024\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5024\uff09\u304c\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u7b49\u306e\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n            - \u30bb\u30eb\u5185\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\uff09\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u306f\u3001\u305d\u306e\u307e\u307e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u3068\u3057\u3066\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n    - UTF8 CSV\n        - MIME type: `text\/csv; charset=UTF-8`\n            - Encoding (\u7b26\u53f7\u5316\u65b9\u5f0f): `UTF-8` no BOM (utf8n, UTF-8N)\n            - Linebreak (\u6539\u884c\u30b3\u30fc\u30c9): `LF`\n            - Delimiter (\u533a\u5207\u308a\u8a18\u53f7): `,` (COMMA)\n        - \u30b7\u30b9\u30c6\u30e0\u9023\u643a\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3068\u3066\u3082\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\n            - Windows\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u7528\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u306f\u3001\u6587\u5b57\u5316\u3051\u3059\u308b\uff08Shift_JIS\u7b49\u306b\u8aa4\u8a8d\u3055\u308c\u308b\uff09\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n        - \u591a\u304f\u306e\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u304c\u51fa\u529b\u3059\u308b\u6c4e\u7528\u7684\u306a\u30ab\u30f3\u30de\u533a\u5207\u308a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3059\u3002\n            - \u5168\u3066\u306e\u30bb\u30eb\u5024\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5024\uff09\u306f\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u307e\u3059\u3002(RFC 4180 2-5)\n            - \u30bb\u30eb\u5185\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u306f\u3001\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u3092\u524d\u7f6e\u3057\u3066\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u307e\u3059\u3002(RFC 4180 2-7)\n    - Plain UTF8 CSV (Extra Commas Removed)\n        - MIME type: `text\/csv; charset=UTF-8`\n            - Encoding (\u7b26\u53f7\u5316\u65b9\u5f0f): `UTF-8` no BOM (utf8n, UTF-8N)\n            - Linebreak (\u6539\u884c\u30b3\u30fc\u30c9): `LF`\n            - Delimiter (\u533a\u5207\u308a\u8a18\u53f7): `,` (COMMA)\n        - \u30b7\u30b9\u30c6\u30e0\u9023\u643a\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3057\u3070\u3057\u3070\u5229\u7528\u3055\u308c\u307e\u3059\u3002\n            - Windows\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u7528\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u306f\u3001\u6587\u5b57\u5316\u3051\u3059\u308b\uff08Shift_JIS\u7b49\u306b\u8aa4\u8a8d\u3055\u308c\u308b\uff09\u5834\u5408\u304c\u3042\u308a\u307e\u3059\u3002\n        - \u4f59\u5206\u306a\u30ab\u30f3\u30de\u6587\u5b57\u304c\u9664\u53bb\u3055\u308c\u305f\u30ab\u30f3\u30de\u533a\u5207\u308a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3059\u3002\n            - \u30bb\u30eb\u5185\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\uff09\u306e\u30ab\u30f3\u30de\u6587\u5b57\uff08\u6841\u533a\u5207\u308a\u6587\u5b57\u7b49\uff09\u304c\u3001\u5168\u3066\u9664\u53bb\u3055\u308c\u307e\u3059\u3002\n            - \u4f1a\u8a08\u30c7\u30fc\u30bf\u3084\u96c6\u8a08\u30c7\u30fc\u30bf\u306a\u3069\u306e\u7ba1\u7406\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\n            - \u30bb\u30eb\u5024\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5024\uff09\u304c\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u7b49\u306e\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n            - \u30bb\u30eb\u5185\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\uff09\u306b\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u304c\u3042\u3063\u305f\u5834\u5408\u3001\u5168\u3066\u9664\u53bb\u3055\u308c\u307e\u3059\u3002(RFC 4180 2-5)\n    - Plain SJIS CSV (Extra Commas Removed)\n        - MIME type: `text\/csv; charset=Shift_JIS`\n            - Encoding (\u7b26\u53f7\u5316\u65b9\u5f0f): `Shift_JIS`\n            - Linebreak (\u6539\u884c\u30b3\u30fc\u30c9): `LF`\n            - Delimiter (\u533a\u5207\u308a\u8a18\u53f7): `,` (COMMA)\n        - \u30b7\u30b9\u30c6\u30e0\u9023\u643a\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3057\u3070\u3057\u3070\u5229\u7528\u3055\u308c\u307e\u3059\u3002\n            - \u65e5\u672c\u306b\u304a\u3051\u308bExcel\u30a4\u30f3\u30dd\u30fc\u30c8\u7528\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3068\u3066\u3082\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\uff08\u6587\u5b57\u5316\u3051\u30ea\u30b9\u30af\u307b\u307c\u56de\u907f\uff09\n            - \u65e5\u672c\u306b\u304a\u3051\u308bWindows\u30bd\u30d5\u30c8\u30a6\u30a7\u30a2\u7528\u306e\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3068\u3066\u3082\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\uff08\u6587\u5b57\u5316\u3051\u30ea\u30b9\u30af\u307b\u307c\u56de\u907f\uff09\n        - \u4f59\u5206\u306a\u30ab\u30f3\u30de\u6587\u5b57\u304c\u9664\u53bb\u3055\u308c\u305f\u30ab\u30f3\u30de\u533a\u5207\u308a\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u3067\u3059\u3002\n            - \u30bb\u30eb\u5185\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\uff09\u306e\u30ab\u30f3\u30de\u6587\u5b57\uff08\u6841\u533a\u5207\u308a\u6587\u5b57\u7b49\uff09\u304c\u3001\u5168\u3066\u9664\u53bb\u3055\u308c\u307e\u3059\u3002\n            - \u65e5\u672c\u306b\u304a\u3051\u308b\u96c6\u8a08\u30c7\u30fc\u30bf\u30fb\u4f1a\u8a08\u30c7\u30fc\u30bf\u30fb\u632f\u8fbc\u30c7\u30fc\u30bf\u306a\u3069\u306e\u7ba1\u7406\u30d5\u30a1\u30a4\u30eb\u3068\u3057\u3066\u3001\u3088\u304f\u5229\u7528\u3055\u308c\u307e\u3059\u3002\n            - \u30bb\u30eb\u5024\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5024\uff09\u304c\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u7b49\u306e\u5f15\u7528\u7b26\u3067\u56f2\u307e\u308c\u308b\u3053\u3068\u306f\u3042\u308a\u307e\u305b\u3093\u3002\n            - \u30bb\u30eb\u5185\uff08\u30d5\u30a3\u30fc\u30eb\u30c9\u5185\uff09\u306b\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u304c\u3042\u3063\u305f\u5834\u5408\u3001\u5168\u3066\u9664\u53bb\u3055\u308c\u307e\u3059\u3002(RFC 4180 2-5)\n    - \u4ed6\u306e\u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306b\u5909\u63db\u3057\u305f\u3044\u5834\u5408\u306f\u3001\u300e\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb, \u30a8\u30f3\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u306e\u5909\u63db\u300f\u306e\u4e0b\u6d41\u914d\u7f6e\u3092\u691c\u8a0e\u3057\u307e\u3059\u3002\n        - `charset=UTF-16` (Unicode\uff3b\u4e16\u754c\u4e2d\u306e\u6587\u5b57\uff3d)\n        - `charset=UTF-16BE` (Unicode\uff3b\u4e16\u754c\u4e2d\u306e\u6587\u5b57\uff3d)\n        - `charset=UTF-16LE` (Unicode\uff3b\u4e16\u754c\u4e2d\u306e\u6587\u5b57\uff3d)\n        - `charset=UTF-32` (Unicode\uff3b\u4e16\u754c\u4e2d\u306e\u6587\u5b57\uff3d)\n        - `charset=x-UTF-32LE-BOM` (Unicode\uff3b\u4e16\u754c\u4e2d\u306e\u6587\u5b57\uff3d)\n        - `charset=ISO-8859-1` (\u30e8\u30fc\u30ed\u30c3\u30d1\u8a00\u8a9e\u306e\u6587\u5b57)\n        - `charset=Shift_JIS` (\u65e5\u672c\u8a9e\u306e\u6587\u5b57)\n        - `charset=Big5` (\u7e41\u4f53\u4e2d\u56fd\u8a9e\u306e\u6587\u5b57)\n        - `charset=GB2312` (\u7c21\u4f53\u4e2d\u56fd\u8a9eEUC\u6587\u5b57)\n        - `charset=GBK` (\u7c21\u4f53\u4e2d\u56fd\u8a9eGB\u306e\u6587\u5b57)\n        - `charset=KOI8-R` (\u30ed\u30b7\u30a2\u8a9e)\n        - \u306a\u304a &quot;UTF8B (BOM\u4ed8 UTF-8)&quot; \u306f\u51fa\u529b\u3067\u304d\u307e\u305b\u3093\u3002\uff08Windows\u7528\u30d5\u30a1\u30a4\u30eb\uff0f\u305d\u306e\u64b2\u6ec5\u3092\u7948\u5ff5\uff09\n        - https:\/\/docs.oracle.com\/javase\/9\/intl\/supported-encodings.htm\n        - https:\/\/docs.oracle.com\/javase\/jp\/9\/intl\/supported-encodings.htm\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAADkElEQVRYR8WXW0gUURjHf+MtK7to\nERF2AUUrNsmCEnzYLkJJlhBBJfWwFe66CFkbaA\/1nCAlIblG5kNh+xR0kS7kluCSFSRsmRU+ZFlk\nt7VytfIyMbNNu267O2ej2PM2M+f7n\/\/5zv\/7\/mckYjwk4fUbmILMViTWIpOLxCIg9Ve8B5kXSHQi\ncxuJi5gZEsHWJ9DEXH5QCViAZBFQ4BtgJ4lqTLyNFBOZgB0LEjXAVMGFg6d5kTmEBXu4+PAEGjgF\nlP3lwsFh9ZixhsIKTcBOMxI7\/9HiPhiZC1goCcb8k8C\/3bluJiYS8J15vcjONy3YRHJ8Mjf7bvJ1\n5KtIiJaJskBN+An41N4jIriSzBLq8utIjEuk8l4lp54ochEeXpLI1KrDT6CBE0CFCEyjsRFTtgkJ\nidbXrRS0FIiEBc6pxcwB5YWPgNJk4KNInWfNyOLyhstkz8xWQz3fPZS7ymnuaY6GhNInZinNykfA\nzi4kzokgHF5+mKMrj6rn7xO3jKPHQYnzD4FHhpPZjYXzWgYagT0iBK5uvMq6eesYk8dISUxRQ3oH\ne9lxawcd7zpEILQ5ZzGzV8vAQyRy9aIL5xfStKaJ55+fM\/B9gKKFRaoORsZHOO4+TtX9Kj0I\/3eZ\nTiys0DLwKcBYwoIoyt+3eB+1j2pxf3KrlZA6yedHnR86MV4xRlOSHsykaQRkPerTEqfRtrmNtOQ0\nNd1dni71OXe2L3GDI4PRl6QZSZiAdamV6tXVON84Kb5RrC5ak1fDfsN+EuIS1OeWly0UXS\/S24v\/\newAB3SNwrHewPWN7RPD+4X5Md0xce3VNhETAEdiJKMK8OXk4ChyMjY\/h6ndNADekGn4fw7g8zunu\n05S1C5hokAgjluGxVceoWFbBmadn1KYTOLSj0Ury2cAzttzYolaKzphQhhEbkavYRcb0jJDp1cSp\nidE76qXqXhV1XXVRNaKwrVgznu6BbvIv5YcEVTJ0MOegak6CYgxqxUpUCDNSOt6RFUcwzjPS\/rYd\n210bD94\/mEAifWo6pUtKseXYmJKg7AO1F5x8fBL7Ezt93r5QpIPMSJkSZMfubW4MaQaGRodQxBUn\nxakLOF87f7ufQk7xhqT4JIZHh1VfUEa8FM\/khMl8+fEFa7s12KjC2LESGcWFRE9hYb\/LhLmQaBEx\nvZJpJGJ6Kf0\/mYjyWu7PRAx\/TDQSMf01C5RyzH5O\/7rexAJ\/Av2AWTB+TSFiAAAAAElFTkSuQmCC\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1b2O4OQQwHHbr5F-ezFBpObojsy7LVz9s\/view?usp=drivesdk\" target=\"_blank\">Tsv-String-Convert-2021.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-08-20 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/1cWk301QRg3F7xeaTlNy534zG1jb3sDnZ\/view?usp=drive_link\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Convert-2023.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-16 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/1ERfgfYuK5ifGqtj5KhHpUQBpEg0-BMbS\/view?usp=sharing\" target=\"_blank\">Tsv-String-Convert-202111.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2021-08-20 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/drive.google.com\/file\/d\/11BP0oXWFysoPWDpvBnhdWf7l-Kv0Ay43\/view?usp=drive_link\" target=\"_blank\" rel=\"noreferrer noopener\">Tsv-String-Convert-202308.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2023-08-16 (C) Questetra, Inc. (MIT License)<\/li>\n\n\n\n<li>for &#8220;GraalJS standard (engine-type 3)&#8221; on v15.0 or above<\/li>\n\n\n\n<li>Also supports &#8220;extraction of only one row&#8221; (enhanced)<\/li>\n\n\n\n<li><code>\/\/ const regCsv = \/^[-?0-9][-?0-9,]*[0-9]$\/; \/\/ RegExp<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\"> The Add-on import feature is available with <span style=\"background-color:rgba(0, 0, 0, 0);color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<br>Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Used when incorporating a Step in which TSV text is automatically edited into the workflow.\n<ul class=\"wp-block-list\">\n<li>When the process reaches this automated task, the TSV stored in string data is automatically processed.\n<ul class=\"wp-block-list\">\n<li>Column reordering<\/li>\n\n\n\n<li>File output (<code>text\/tab-separated-values<\/code>,<code>text\/csv<\/code>)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The output order is specified by enumerating the column IDs of the input TSV (lile &#8220;0&#8221; and &#8220;3&#8221;).\n<ul class=\"wp-block-list\">\n<li>If an inaccessible ID (such as &#8220;999&#8221; or &#8220;-1&#8221;) is specified, an empty string (length 0) will be inserted.\n<ul class=\"wp-block-list\">\n<li>The number of columns can be added (e.g. combining TSVs, adding header line, etc.).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If not specified, all columns will be output as they were originally.\n<ul class=\"wp-block-list\">\n<li>If the number of cells differs depending on the row, the output will be adjusted to the maximum number.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Blank lines (with line breaks only) in the input TSV text are ignored.<\/li>\n\n\n\n<li>If SaveAs is not set, the file name will be <code>{pid}-urf8.csv<\/code> etc.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?ssl=1\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"675\" data-attachment-id=\"111737\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/tsv-string-convert-2021-capture-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?fit=1200%2C675&amp;ssl=1\" data-orig-size=\"1200,675\" data-comments-opened=\"0\" data-image-title=\"tsv-string-convert-2021-capture-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?resize=1200%2C675&#038;ssl=1\" alt=\"Changes column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like &quot;0,1,3,0&quot;. The new TSV text can also be stored in formats such as TSV file format and CSV file format.\" class=\"wp-image-111737\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?w=1200&amp;ssl=1 1200w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-capture-en.png?resize=768%2C432&amp;ssl=1 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/a><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large is-style-default q-box\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"684\" height=\"630\" data-attachment-id=\"111741\" data-permalink=\"https:\/\/support.questetra.com\/en\/maintenance\/maintenance-20251117\/attachment\/tsv-string-convert-2021-config-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-config-en.png?fit=1198%2C1104&amp;ssl=1\" data-orig-size=\"1198,1104\" data-comments-opened=\"0\" data-image-title=\"tsv-string-convert-2021-config-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-config-en.png?fit=684%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-config-en-684x630.png?resize=684%2C630&#038;ssl=1\" alt=\"Changes column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like &quot;0,1,3,0&quot;. The new TSV text can also be stored in formats such as TSV file format and CSV file format.\" class=\"wp-image-111741\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-config-en.png?resize=684%2C630&amp;ssl=1 684w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-config-en.png?resize=342%2C315&amp;ssl=1 342w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-config-en.png?resize=768%2C708&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-config-en.png?w=1198&amp;ssl=1 1198w\" sizes=\"auto, (max-width: 684px) 100vw, 684px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The input TSV is parsed as the simplest tab-delimited text. (<code>UTF-8<\/code> encoding)\n<ul class=\"wp-block-list\">\n<li>Double quotes are interpreted as cell data just like any other character.\n<ul class=\"wp-block-list\">\n<li>It is not possible to have &#8220;tab&#8221; or &#8220;line feed&#8221; data in the cell data (in the field).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>LF is assumed as the line feed code.\n<ul class=\"wp-block-list\">\n<li>Even if it is CRLF or CR, it can be processed normally.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Tab-separated_values\" rel=\"nofollow\">https:\/\/en.wikipedia.org\/wiki\/Tab-separated_values<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If you want to combine two TSV data as an input TSV, set Config in two lines.\n<ul class=\"wp-block-list\">\n<li><code>#{#q_tsv_string_data_1}<\/code><br><code>#{#q_tsv_string_data_2}<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If you want to add header line as input TSV, add the header line to the first line of Config.\n<ul class=\"wp-block-list\">\n<li><code>header-cel-A<\/code> TAB <code>header-cel-B<\/code> TAB <code>header-cel-C<\/code><br><code>#{#q_tsv_string_data}<\/code><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The number of cells in the output TSV is the same for all rows. (Fixed Column Width)\n<ul class=\"wp-block-list\">\n<li>The line feed code is not added to the last line.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>UTF-8<\/code>\n<ul class=\"wp-block-list\">\n<li>Compactly encodes more than 1 million Unicode characters in the world with 1 to 4 bytes.<\/li>\n\n\n\n<li>It became the most common character code in 2008 and is used in 97% of web pages as of 2021.<\/li>\n\n\n\n<li>UTF-8 is superset of US-ASCII (single-byte characters). (upward compatible)\n<ul class=\"wp-block-list\">\n<li>That is, ASCII files are also UTF-8 files. (US-ASCII is a subset of UTF-8)<\/li>\n\n\n\n<li>Similarly, ASCII files are also Shift_JIS files.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><code>UTF-16<\/code>\n<ul class=\"wp-block-list\">\n<li>Encodes over 1 million Unicode characters in the world with 2-4 bytes.<\/li>\n\n\n\n<li>If there are many Asian characters such as Japanese and Chinese, encode them compactly.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>File output can be output in several formats.\n<ul class=\"wp-block-list\">\n<li>UTF8 TSV <strong>Recommended<\/strong>\n<ul class=\"wp-block-list\">\n<li>MIME type: <code>text\/tab-separated-values; charset=UTF-8<\/code>\n<ul class=\"wp-block-list\">\n<li>Encoding: <code>UTF-8<\/code> no BOM (utf8n, UTF-8N)<\/li>\n\n\n\n<li>Linebreak: <code>LF<\/code><\/li>\n\n\n\n<li>Delimiter: <code>TAB<\/code><\/li>\n\n\n\n<li><a href=\"https:\/\/ja.wikipedia.org\/wiki\/Tab-Separated_Values\" rel=\"nofollow\">https:\/\/ja.wikipedia.org\/wiki\/Tab-Separated_Values<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>It is very often used for File-based Integration.\n<ul class=\"wp-block-list\">\n<li>As a file for Windows software, characters may be garbled (misidentified by Shift_JIS etc.).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The simplest and most versatile tab-delimited text.\n<ul class=\"wp-block-list\">\n<li>Cell values \u200b\u200b(field values) are not enclosed in quotation marks such as double quotes.<\/li>\n\n\n\n<li>Double quotes in cells (in fields) are retained as double quotes.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>UTF16LE TSV (Excel compatible CSV) <strong>Recommended<\/strong>\n<ul class=\"wp-block-list\">\n<li>MIME type: <code>text\/csv; charset=x-UTF-16LE-BOM<\/code>\n<ul class=\"wp-block-list\">\n<li>Encoding: <code>x-UTF-16LE-BOM<\/code><\/li>\n\n\n\n<li>Linebreak: <code>LF<\/code><\/li>\n\n\n\n<li>Delimiter: <code>TAB<\/code><\/li>\n\n\n\n<li><a href=\"https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values\" rel=\"nofollow\">https:\/\/en.wikipedia.org\/wiki\/Comma-separated_values<\/a><\/li>\n\n\n\n<li>In many cases, it is called a CSV file and the extension is <code>.csv<\/code>, but in reality it is tab-delimited.<\/li>\n\n\n\n<li>The file will be several bytes larger than <code>charset=UTF-16<\/code> and <code>charset=UTF-16BE<\/code>.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Very often used as a file for Excel import. (OS does not matter \/ Risk of garbled characters is almost avoided)\n<ul class=\"wp-block-list\">\n<li>Often used as a file for Windows software.<\/li>\n\n\n\n<li>The file for File-based Integration may cause a problem.<\/li>\n\n\n\n<li>It cannot be used as a file for legacy software (for example, software that assumes US-ASCII).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The simplest and most versatile tab-delimited text.\n<ul class=\"wp-block-list\">\n<li>Cell values\u200b(field values) are not enclosed in quotation marks such as double quotes.<\/li>\n\n\n\n<li>Double quote characters in cells (in fields) are retained as double quote characters.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>UTF8 CSV\n<ul class=\"wp-block-list\">\n<li>MIME type: <code>text\/csv; charset=UTF-8<\/code>\n<ul class=\"wp-block-list\">\n<li>Encoding: <code>UTF-8<\/code> no BOM (utf8n, UTF-8N)<\/li>\n\n\n\n<li>Linebreak: <code>LF<\/code><\/li>\n\n\n\n<li>Delimiter: <code>,<\/code> (COMMA)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>It is very often used for File-based Integration.\n<ul class=\"wp-block-list\">\n<li>As a file for Windows software, characters may be garbled (misidentified by Shift_JIS etc.).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>A comma-separated format output by many software.\n<ul class=\"wp-block-list\">\n<li>All cell values \u200b\u200b(field values) are enclosed in double quotes. (RFC 4180 2-5)<\/li>\n\n\n\n<li>Double quote characters in cells are escaped preceded by double quote characters. (RFC 4180 2-7)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Plain UTF8 CSV (Extra Commas Removed)\n<ul class=\"wp-block-list\">\n<li>MIME type: <code>text\/csv; charset=UTF-8<\/code>\n<ul class=\"wp-block-list\">\n<li>Encoding: <code>UTF-8<\/code> no BOM (utf8n, UTF-8N)<\/li>\n\n\n\n<li>Linebreak: <code>LF<\/code><\/li>\n\n\n\n<li>Delimiter: <code>,<\/code> (COMMA)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Often used for File-based Integration\n<ul class=\"wp-block-list\">\n<li>As a file for Windows software, characters may be garbled (misidentified by Shift_JIS etc.).<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Comma separated format with extra comma characters removed.\n<ul class=\"wp-block-list\">\n<li>All comma characters (digit separators, etc.) in the cell (in the field) are removed.<\/li>\n\n\n\n<li>It is often used as a management file for accounting data and aggregated data.<\/li>\n\n\n\n<li>Cell values\u200b(field values) are not enclosed in quotation marks such as double quotes.<\/li>\n\n\n\n<li>If there are double quote characters in the cell (in the field), they are all removed. (RFC 4180 2-5)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Plain SJIS CSV (Extra Commas Removed)\n<ul class=\"wp-block-list\">\n<li>MIME type: <code>text\/csv; charset=Shift_JIS<\/code>\n<ul class=\"wp-block-list\">\n<li>Encoding: <code>Shift_JIS<\/code><\/li>\n\n\n\n<li>Linebreak: <code>LF<\/code><\/li>\n\n\n\n<li>Delimiter: <code>,<\/code> (COMMA)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Often used for File-based Integration\n<ul class=\"wp-block-list\">\n<li>It is very often used as a file for importing Excel in Japan. (Almost avoiding the risk of garbled characters)<\/li>\n\n\n\n<li>It is very often used as a file for Windows software in Japan. (Almost avoiding the risk of garbled characters)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Comma separated format with extra comma characters removed.\n<ul class=\"wp-block-list\">\n<li>All comma characters (digit separators, etc.) in the cell (in the field) are removed.<\/li>\n\n\n\n<li>It is often used as a management file for aggregated data, accounting data, transfer data, etc. in Japan.<\/li>\n\n\n\n<li>Cell values (field values) are not enclosed in quotation marks such as double quotes.<\/li>\n\n\n\n<li>If there are double quote characters in the cell (in the field), they are all removed. (RFC 4180 2-5)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>If you want to convert to another encoding, consider the downstream arrangement of &#8220;Text file, encoding conversion&#8221;.\n<ul class=\"wp-block-list\">\n<li><code>charset=UTF-16<\/code> (Unicode [characters around the world])<\/li>\n\n\n\n<li><code>charset=UTF-16BE<\/code> (Unicode [characters around the world])<\/li>\n\n\n\n<li><code>charset=UTF-16LE<\/code> (Unicode [characters around the world])<\/li>\n\n\n\n<li><code>charset=UTF-32<\/code> (Unicode [characters around the world])<\/li>\n\n\n\n<li><code>charset=x-UTF-32LE-BOM<\/code> (Unicode [characters around the world])<\/li>\n\n\n\n<li><code>charset=ISO-8859-1<\/code> (Western language characters)<\/li>\n\n\n\n<li><code>charset=Shift_JIS<\/code> (Japanese characters)<\/li>\n\n\n\n<li><code>charset=Big5<\/code> (Traditional Chinese characters)<\/li>\n\n\n\n<li><code>charset=GB2312<\/code> (Simplified Chinese EUC characters)<\/li>\n\n\n\n<li><code>charset=GBK<\/code> (Simplified Chinese GB characters)<\/li>\n\n\n\n<li><code>charset=KOI8-R<\/code> (Russian)<\/li>\n\n\n\n<li>In addition, &#8220;UTF8B (UTF-8 with BOM)&#8221; cannot be output. (File for Windows \/ pray for its eradication)<\/li>\n\n\n\n<li><a href=\"https:\/\/docs.oracle.com\/javase\/9\/intl\/supported-encodings.htm\" rel=\"nofollow\">https:\/\/docs.oracle.com\/javase\/9\/intl\/supported-encodings.htm<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/h3>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"6xvlyHXBmQ\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/text-files-convert-character-encoding-2021\/\">Text Files, Convert Character Encoding<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Text Files, Convert Character Encoding&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/addons\/text-files-convert-character-encoding-2021\/embed\/#?secret=IRHZwoocq4#?secret=6xvlyHXBmQ\" data-secret=\"6xvlyHXBmQ\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-questetra-support wp-block-embed-questetra-support\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"xjVv688XAk\"><a href=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-textfile-to-string\/\">Converter (Text File to String type data)<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;Converter (Text File to String type data)&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/bpmn-icons\/converter-textfile-to-string\/embed\/#?secret=dMYS4iL9gZ#?secret=xjVv688XAk\" data-secret=\"xjVv688XAk\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Changes the column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like &#8220;0,1,3,0&#8221;. The new TSV text can also be stored in formats such as TSV file format and CSV file format.<\/p>\n","protected":false},"author":2,"featured_media":111745,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"Changes column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like \"0,1,3,0\". The new TSV text can also be stored in formats such as TSV file format and CSV file format.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"{title}\n\n{excerpt}\n\n{url}","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[168],"tags":[491,377,381,389],"faq_section":[],"class_list":["post-111749","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-expense-claim","tag-newqfile","tag-regexp","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":15,"uagb_excerpt":"Changes the column order of TSV text. The new order is specified by enumerating the column IDs of the original TSV, like \"0,1,3,0\". The new TSV text can also be stored in formats such as TSV file format and CSV file format.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-t4p","jetpack-related-posts":[{"id":78118,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-reorder-columns\/","url_meta":{"origin":111749,"position":0},"title":"TSV String; Re-order Columns","author":"IMAMURA, Genichi","date":"2021-02-01","format":false,"excerpt":"Extracts a new TSV string re-arranged by a column ID list from TSV string. ID repetition in the list is also possible. It can be used to narrow down necessary information or conform to the format. Removes whitespace from both ends of a string.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/Tsv-String-Reorder-Columns-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82375,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-text\/","url_meta":{"origin":111749,"position":1},"title":"TSV String, Sort by Text","author":"IMAMURA, Genichi","date":"2019-12-03","format":false,"excerpt":"Sorts TSV lines in the order of the character code of the specified column. If the column value for each line is Jan Feb March, the text is sorted in the order of \"line that contains Feb\", \"line that contains Jan\" and \"line that contains March\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Sort by Text","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Text-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82388,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-sort-by-numeric\/","url_meta":{"origin":111749,"position":2},"title":"TSV String, Sort by Numeric","author":"IMAMURA, Genichi","date":"2019-12-03","format":false,"excerpt":"Sorts TSV text in the numerical order of the specified column. If each column values are \"123 jpy\", \"1,234 jpy\", and \"12 jpy\", they are sorted in the order of \"line including 12 jpy\", \"line including 123 jpy\", \"line including 1,234 jpy\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Sort by Numeric","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Sort-by-Numeric-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69088,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsvtoexcelcsv\/","url_meta":{"origin":111749,"position":3},"title":"Converter (TSV to Excel-CSV File)","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"A tab-delimited text (TSV) stored in a String type data item is saved as an Excel-compatible CSV file in a File type Data Item.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-excel-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-excel-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-excel-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-excel-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/converter-tsv-excel-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82682,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-string-filter-by-date\/","url_meta":{"origin":111749,"position":4},"title":"TSV String, Filter by Date","author":"IMAMURA, Genichi","date":"2019-12-12","format":false,"excerpt":"Filters TSV strings using a date range. Only the rows where the specified date column is included in the date range are output. If OR multiple ranges, specify in comma separated like \"2020-01-01","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"TSV String, Filter by Date","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/12\/TSV-String-Filter-by-Date-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70901,"url":"https:\/\/support.questetra.com\/en\/addons\/tsv-changeorder\/","url_meta":{"origin":111749,"position":5},"title":"Change Order of Tsv","author":"Hirotaka NISHI","date":"2018-11-15","format":false,"excerpt":"Sorting the columns of the TSV in the order as indicated","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/tsv-change-order-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/08\/tsv-string-convert-2021-nocode-en.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111749","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=111749"}],"version-history":[{"count":10,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111749\/revisions"}],"predecessor-version":[{"id":149737,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/111749\/revisions\/149737"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/111745"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=111749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=111749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=111749"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=111749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}