{"id":188077,"date":"2026-06-29T17:16:47","date_gmt":"2026-06-29T08:16:47","guid":{"rendered":"https:\/\/support.questetra.com\/?p=188077"},"modified":"2026-06-29T17:16:48","modified_gmt":"2026-06-29T08:16:48","slug":"converter-csv-string-to-tsv-string-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-csv-string-to-tsv-string-2026\/","title":{"rendered":"Converter: #CSV String to #TSV String"},"content":{"rendered":"\n

Converter: #CSV String to #TSV String<\/strong><\/h4>\n\n\n\n

translate<\/span> \u30b3\u30f3\u30d0\u30fc\u30bf: #CSV \u6587\u5b57\u5217 to #TSV \u6587\u5b57\u5217<\/a><\/p>\n\n\n\n

Converts a CSV string to a TSV string. Line breaks and tab characters within cells enclosed in double quotes are replaced with half-width spaces. Excel-style double-quote escaping (consecutive double quotes) is replaced with a single character.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: Set Input CSV String *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB1<\/dt>
B1: Set Replacement for Line Breaks (default: half-width space)#{EL}<\/sup><\/span><\/dd>\n
StrConfB2<\/dt>
B2: Set Replacement for Tabs (default: half-width space)#{EL}<\/sup><\/span><\/dd>\n
SelectConfC<\/dt>
C: Select String DATA to store Output TSV *<\/span><\/dd>\n<\/div>\n
SelectConfD1<\/dt>
D1: Select NUMERIC for Number of TSV Lines (update)<\/dd>\n
SelectConfD2<\/dt>
D2: Select NUMERIC for Number of TSV Cols (update)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ Script Example of Business Process Automation\n\/\/ for 'engine type: 3' ("GraalJS standard mode")\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInputCsv   = configs.get       ( "StrConfA" );     \/\/ REQUIRED\n  if( strInputCsv === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError: Config {A: CSV} is empty \\n" );\n  }\nconst strRepLb      = configs.get       ( "StrConfB1" ) || " "; \/\/ default\nconst strRepTab     = configs.get       ( "StrConfB2" ) || " "; \/\/ default\nconst strPocketC    = configs.getObject ( "SelectConfC" );  \/\/ REQUIRED\nconst numPocketD1   = configs.getObject ( "SelectConfD1" );\nconst numPocketD2   = configs.getObject ( "SelectConfD2" );\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\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 (SVG\u6587\u5b57\u5217\u306e\u751f\u6210) ==\n\n\/\/ 1. CSV\u304b\u3089TSV\u6587\u5b57\u5217\u3078\u306e\u5909\u63db\uff08\u7f6e\u63db\u6587\u5b57\u3092\u5f15\u6570\u3067\u6e21\u3059\uff09\nconst strOutputTsv = convertCsvToTsv(strInputCsv, strRepLb, strRepTab);\n\n\/\/ 2. \u884c\u6570\u30fb\u5217\u6570\u306e\u7b97\u51fa\uff08\u7528\u610f\u3055\u308c\u305f\u95a2\u6570\u3092\u5229\u7528\u3057\u30662\u6b21\u5143\u914d\u5217\u5316\uff09\nconst arr2dTsv = parseAsRectangular(strOutputTsv);\nconst numTotalLines = arr2dTsv.length;\nconst numCols = numTotalLines > 0 ? arr2dTsv[0].length : 0; \/\/ 1\u884c\u76ee\u306e\u8981\u7d20\u6570\u3092\u5217\u6570\u3068\u3059\u308b\n\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\nif ( strPocketC  !== null) { \n  engine.setData( strPocketC, strOutputTsv );\n}\nif ( numPocketD1 !== null) { \n  engine.setData( numPocketD1, new java.math.BigDecimal( numTotalLines ) );\n}\nif ( numPocketD2 !== null) { \n  engine.setData( numPocketD2, new java.math.BigDecimal( numCols ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\n\n\/**\n * Parses TSV string as a two-dimensional rectangular data matrix and creates a 2D array.\n * @date 2026-06-20\n * @author Questetra, Inc.\n * @license MIT\n * @param {string} strTsv - The input TSV string\n * @returns {Array<Array<string>>} Rectangular 2D array\n *\/\nfunction parseAsRectangular( strTsv ){\n  const arrTsv = strTsv.split("\\n");\n  let numMinWidth   = Infinity;\n  let numMaxWidth   = 0;\n  let numBlanklines = 0;\n  \n  const parsedRows = [];\n  for( let i = 0; i < arrTsv.length; i++ ){\n    const line = arrTsv[i];\n    if( line === "" ){\n      numBlanklines++;\n      continue;\n    }\n    const arrCells = line.split("\\t");\n    const len = arrCells.length;\n    if( len < numMinWidth ){ numMinWidth = len; }\n    if( len > numMaxWidth ){ numMaxWidth = len; }\n    parsedRows.push( arrCells );\n  }\n  \n  if( numMinWidth === Infinity ){\n    numMinWidth = 0;\n  }\n  engine.log( " AutomatedTask TsvDataCheck:" + \n              " MinWidth:" + numMinWidth +\n              " MaxWidth:" + numMaxWidth +\n              " Lines:" + arrTsv.length +\n              " (BlankLines:" + numBlanklines + ")" );\n\n  for( let i = 0; i < parsedRows.length; i++ ){\n    const row = parsedRows[i];\n    while( row.length < numMaxWidth ){\n      row.push( "" );\n    }\n  }\n  return parsedRows;\n}\n\n\n\n\n\/**\n * Converts a CSV string to a TSV string. \uff0f CSV\u6587\u5b57\u5217\u3092TSV\u6587\u5b57\u5217\u306b\u5909\u63db\u3059\u308b\u95a2\u6570\u3002\n * ---\n * - In-cell Line Breaks & Tabs:\n * Line breaks (\\n, \\r) and tabs (\\t) enclosed in double quotes are converted into half-width spaces.\n * - Escaped Quotes:\n * Secured Excel-style escaped double quotes ("") and treats them as a single literal quote.\n * - Newline Support:\n * Supports CR, LF, and CRLF as line separators. Output line breaks are unified to LF (\\n).\n * ---\n * - \u30bb\u30eb\u5185\u306e\u6539\u884c\u30fb\u30bf\u30d6:\n * \u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u306b\u56f2\u307e\u308c\u305f\u30bb\u30eb\u5185\u306e\u6539\u884c\u304a\u3088\u3073\u30bf\u30d6\u306f\u3001\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u306b\u7f6e\u63db\u3055\u308c\u307e\u3059\u3002\n * - \u30af\u30aa\u30fc\u30c8\u306e\u30a8\u30b9\u30b1\u30fc\u30d7:\n * Excel\u5f62\u5f0f\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\uff08""\uff09\u3092\u8a8d\u8b58\u3057\u30011\u3064\u306e\u6587\u5b57\u3068\u3057\u3066\u51e6\u7406\u3057\u307e\u3059\u3002\n * - \u6539\u884c\u30b3\u30fc\u30c9\u5bfe\u5fdc:\n * CR, LF, CRLF \u306e\u5404\u6539\u884c\u30b3\u30fc\u30c9\u306b\u5bfe\u5fdc\u3002\u51fa\u529b\u6642\u306e\u6539\u884c\u306f LF (\\n) \u306b\u7d71\u4e00\u3055\u308c\u307e\u3059\u3002\n * ---\n * @date 2026-06-20\n * @author Questetra, Inc.\n * @license MIT\n * @param {string} csvText - Input CSV string \/ \u5909\u63db\u5143\u306eCSV\u6587\u5b57\u5217\n * @param {string} repLb - \u6539\u884c\u30b3\u30fc\u30c9\u306e\u7f6e\u63db\u6587\u5b57\u5217\n * @param {string} repTab - \u30bf\u30d6\u306e\u7f6e\u63db\u6587\u5b57\u5217\n * @returns {string} TSV formatted string \/ TSV\u5f62\u5f0f\u306e\u6587\u5b57\u5217\n *\/\nfunction convertCsvToTsv(csvText, repLb, repTab) {\n  let lines = [];\n  let row = [""];\n  let inQuotes = false;\n\n  for (let i = 0; i < csvText.length; i++) { \n    let c = csvText[i];\n    let next = csvText[i + 1];\n\n    if (inQuotes) {\n      if (c === '"') {\n        if (next === '"') { \n          \/\/ "" \u306f\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u305f\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\n          row[row.length - 1] += '"';\n          i++; \n        } else { \n          \/\/ \u9589\u3058\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\n          inQuotes = false;\n        }\n      } else {  \n        \/\/ ====== \u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u306b\u56f2\u307e\u308c\u305f\u300c\u30bb\u30eb\u5185\u300d\u306e\u7f6e\u63db\u51e6\u7406 ======\n        if (c === '\\r' && next === '\\n') {\n          \/\/ CRLF\u306e\u5834\u5408\u306f1\u3064\u306e\u6539\u884c\u3068\u3057\u3066\u6271\u3044\u3001i\u30921\u3064\u9032\u3081\u308b\n          row[row.length - 1] += repLb;\n          i++;\n        } else if (c === '\\n' || c === '\\r') {\n          \/\/ LF \u307e\u305f\u306f CR \u5358\u72ec\u306e\u5834\u5408\n          row[row.length - 1] += repLb;\n        } else if (c === '\\t') {\n          \/\/ \u30bf\u30d6\u306e\u5834\u5408\n          row[row.length - 1] += repTab;\n        } else {\n          \/\/ \u901a\u5e38\u306e\u6587\u5b57\n          row[row.length - 1] += c;\n        }\n      }\n    } else {\n      \/\/ ====== \u30bb\u30eb\u5916\uff08\u901a\u5e38\u306eCSV\u533a\u5207\u308a\u30fb\u884c\u533a\u5207\u308a\uff09\u306e\u51e6\u7406 ======\n      if (c === '"') {\n        inQuotes = true;\n      } else if (c === ',') {\n        row.push(""); \/\/ \u6b21\u306e\u5217\u3078\n      } else if (c === '\\r' || c === '\\n') {  \n        if (c === '\\r' && next === '\\n') i++; \/\/ CRLF\u5bfe\u5fdc\n        lines.push(row);\n        row = [""];\n      } else {\n        row[row.length - 1] += c;\n      }\n    }\n  }\n  \/\/ \u6700\u7d42\u884c\u306e\u8ffd\u52a0\n  if (row.length > 1 || row[0] !== "") {\n    lines.push(row);\n  }\n\n  return lines.map(fields => fields.join('\\t')).join('\\n');\n}\n\n\n\n\n\n\/*\n### NOTES-en\n- A TSV string is automatically generated each time a Case reaches this Automated Step.\n    - Refers to the input CSV string.\n    - If the cell data is enclosed in double quotes, the enclosing double quotes are removed.\n    - Line breaks and tab characters within cells are replaced with half-width spaces.\n        - It is also possible to configure replacement strings other than a "half-width space".\n        - Example 3 shows the output when "\u2605" is set as the replacement for line breaks and "\u25c6" for tabs.\n    - Recognizes Excel-style double-quote escaping (consecutive double quotes `""`) and treats them as a single literal quote (`"`).\n\n### NOTES-ja\n- \u3053\u306e\u30a2\u30c9\u30aa\u30f3\u81ea\u52d5\u5de5\u7a0b\u306b\u30b1\u30fc\u30b9\uff08\u6848\u4ef6\uff09\u304c\u5230\u9054\u3059\u308b\u5ea6\u306b\u3001\u81ea\u52d5\u7684\u306b TSV \u6587\u5b57\u5217\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002\n    - CSV \u6587\u5b57\u5217\u3092\u53c2\u7167\u3057\u307e\u3059\u3002\n    - \u30bb\u30eb\u30c7\u30fc\u30bf\u304c\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u306b\u56f2\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u306f\u524a\u9664\u3055\u308c\u307e\u3059\u3002\n    - \u30bb\u30eb\u5185\u306b\u3042\u308b\u6539\u884c\u30b3\u30fc\u30c9\u3068\u30bf\u30d6\u30b3\u30fc\u30c9\u306f\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u306b\u7f6e\u63db\u3055\u308c\u307e\u3059\u3002\n        - \u7f6e\u63db\u6587\u5b57\u5217\u3092\u300c\u534a\u89d2\u30b9\u30da\u30fc\u30b9\u300d\u4ee5\u5916\u306b\u8a2d\u5b9a\u3059\u308b\u30b3\u30c8\u3082\u53ef\u80fd\u3067\u3059\u3002\n        - InputCSV 3 \u306e\u4f8b: \u6539\u884c\u306e\u7f6e\u63db\u6587\u5b57\u5217\u306b\u300c\u2605\u300d\u3001\u30bf\u30d6\u306e\u7f6e\u63db\u6587\u5b57\u5217\u306b\u300c\u25c6\u300d\u3092\u8a2d\u5b9a\u3057\u305f\u5834\u5408\u306e\u51fa\u529b\u3002\n    - Excel\u5f62\u5f0f\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u306e\u30a8\u30b9\u30b1\u30fc\u30d7\uff08""\uff09\u3092\u8a8d\u8b58\u3057\u30011\u3064\u306e\u6587\u5b57\u3068\u3057\u3066\u51e6\u7406\u3057\u307e\u3059\u3002\n\n\n#### InputCSV OutputTSV examples\n- InputCSV 1:\n    - `"99","2026\/04\/01","\u58f2\u4e0a\u9ad8","SaaS","","","\u8ab2\u58f2 10%","","\u524d\u53d7\u91d1",`\n- OutputTSV 1:\n    - `99\t2026\/04\/01\t\u58f2\u4e0a\u9ad8\tSaaS\t\t\t\u8ab2\u58f2 10%\t\t\u524d\u53d7\u91d1\t`\n- InputCSV 2:\n    - `99,2026\/04\/01,\u58f2\u4e0a\u9ad8,SaaS,,"","\u8ab2\u58f2 10%","","\u524d\u53d7\u91d1",`\n- OutputTSV 2:\n    - `99\t2026\/04\/01\t\u58f2\u4e0a\u9ad8\tSaaS\t\t\t\u8ab2\u58f2 10%\t\t\u524d\u53d7\u91d1\t`\n- InputCSV 3:\n    - `"ID","\u6458\u8981","\u91d1\u984d"`\n    - `"100001","1\u884c\u76ee\t\u2190\u3053\u3053\u306f\u30bf\u30d6`\n    - `2\u884c\u76ee","3300"`\n    - `"100002","\u5546\u54c1\u540d ""A4\u30b3\u30d4\u30fc\u7528\u7d19""\t100\u518a`\n    - `\u898b\u7a4d\u756a\u53f7\uff1aQ2026","12000"`\n- OutputTSV 3:\n    - `ID\t\u6458\u8981\t\u91d1\u984d`\n    - `100001\t1\u884c\u76ee\u25c6\u2190\u3053\u3053\u306f\u30bf\u30d6\u26052\u884c\u76ee\t3300`\n    - `100002\t\u5546\u54c1\u540d "A4\u30b3\u30d4\u30fc\u7528\u7d19"\u25c6100\u518a\u2605\u898b\u7a4d\u756a\u53f7\uff1aQ2026\t12000`\n\n\n### APPENDIX-en\n- Supports CR, LF, and CRLF as line separators.\n    - Output line breaks are unified to LF (\\n).\n\n### APPENDIX-ja\n- CR, LF, CRLF \u306e\u5404\u6539\u884c\u30b3\u30fc\u30c9\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u307e\u3059\u3002\n    - \u51fa\u529b\u6642\u306e\u6539\u884c\u306f LF (\\n) \u306b\u7d71\u4e00\u3055\u308c\u307e\u3059\u3002\n*\/\n\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n