{"id":200316,"date":"2026-11-19T10:33:51","date_gmt":"2026-11-19T01:33:51","guid":{"rendered":"https:\/\/support.questetra.com\/?p=200316"},"modified":"2026-11-19T10:33:54","modified_gmt":"2026-11-19T01:33:54","slug":"converter-tsv-string-to-butterfly-svg-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-butterfly-svg-2026\/","title":{"rendered":"Converter: #TSV String to #Butterfly-SVG File"},"content":{"rendered":"\n<h3 class=\"wp-block-heading\">Overview<\/h3>\n\n\n\n<h4 class=\"wp-block-heading has-background\" style=\"background-color:#ffccff;margin-top:var(--wp--preset--spacing--30);margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--20);padding-bottom:0;padding-left:var(--wp--preset--spacing--20)\"><strong> Converter: #TSV String to #Butterfly-SVG File<\/strong><\/h4>\n\n\n\n<p class=\"has-text-align-right has-background has-small-font-size mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#ffccff;margin-top:0;margin-right:0;margin-bottom:0;margin-left:0;padding-top:0;padding-right:var(--wp--preset--spacing--30);padding-bottom:0;padding-left:var(--wp--preset--spacing--30)\"> \u30b3\u30f3\u30d0\u30fc\u30bf: #TSV \u6587\u5b57\u5217 to #Butterfly-SVG \u30d5\u30a1\u30a4\u30eb<\/p>\n\n\n\n<p class=\"has-background mt-0 pt-0 wp-block-paragraph\" style=\"background-color:#fff0ff;margin-top:0;margin-right:0;margin-bottom:var(--wp--preset--spacing--60);margin-left:0;padding-top:var(--wp--preset--spacing--20);padding-right:var(--wp--preset--spacing--30);padding-bottom:var(--wp--preset--spacing--20);padding-left:var(--wp--preset--spacing--40)\">Converts a numeric TSV string into a stacked butterfly chart SVG file. The middle text column is detected as the aggregation unit (e.g. &#8220;2026-11&#8221; or &#8220;FY2026&#8221;), with left columns rendered extending leftward and right columns extending rightward.<\/p>\n\n\n\n<figure class=\"wp-block-image alignright has-custom-border is-style-default\" style=\"margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px\"><img decoding=\"async\" src=\"data:image;base64,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAACx0lEQVRYR8WXz0sUYRjHP5O0CLX+\nuHTIQ7sHIby0BdIh0EU6hwmd20Vx9mb9AUvlQQSRVhBq0WW3gxcFKzx4000kBKO2QNgSssgS6uDu\noQQJJt4ZZ3ecH+s4O+kLyy7s+z7fz\/PM87zPMxKnvKRj6afpBbpRiCDRAkQOzhdQKCEhvvMkeOnW\n7tEAWVrYZwi4B6qom1UCUgSYII747bhqAzwhxhkeH0PYLCTE48i8cCJwBnhKCkn13I+VQua+nSF7\ngDQ54K4fyhUbCjkSxM02rQD+en5YT2GChJpLlXUYQHvmWV89txq7bcyJKoCW7Vt1JJxb7hIBwnp1\nVAHSPAQeuLVSa99U1xTzW\/Msflt02vYIWdXDCCBKptkPgI07GzQFmhhcGXSCKCHTWgXQbrjnRvGe\niz20nWvzxJO8lqS9uZ3t39u1INRc0CJgk\/nCi47WDk8AxkOOEAcVoQGkyat3vGH5BbD3d4\/RwijD\nb4fNzrxCJqoDfAEuGXdMd03TeaHTUwRC50NqDgjx8Q\/jJN8k7ewUkLmqAyielBwOieiFg+Fa4tpJ\nGelIgODZIJnuDDt\/dhh67a41rN5aZfnHspPnVWwDgOURiF1CPBvN0hvqJfcxx8DKgH+BUnhPgohj\nEhrFG6QG1n6usVne9ASw9H2J3CfR3w4tQxLalOHszVn6wn0I8XpXppixRs9UhpaLaPLGJP2X+2ls\naKxXH1sAMFxE2l1guYqNEHOf51j4uuAJplgqsv5r3Xi2jKyNd0c2Ix1iZnPGzyS0aUZaOxbVYGlI\nY9fH2N3fZeTdiKcImA6VCRCytmOx61QHEh3zf45kUAm9LndyQyk8QyZmfoYnNZZbPK8dAf1fbVAR\nV5jXSakMxLy9mOgQWnWIUVp83IIIYfFqlqrv1cz8wEREFKJIRFBoQeKKukU0FokSCgUk8rU8dp8D\nflS8Cxv\/AFp57iGwqv7bAAAAAElFTkSuQmCC\n\" alt=\"Auto Step icon\" class=\"has-border-color has-ast-global-color-4-border-color\" style=\"border-width:0.5em\"\/><\/figure>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details open><summary class=\"wp-block-coblocks-accordion-item__title has-background has-border-background-color\">Configs for this Auto Step<\/summary><div class=\"wp-block-coblocks-accordion-item__content\" style=\"border-color:#e7e5e4\">\n<dl style=\"margin: 0 0 -0.7em 0\">\n<div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Main\"><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfA<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">A: Set TSV String<span style=\"color:#990000;\"> *<\/span><span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B1: Set Pixel Widths (Unit, Bar, Total) as CSV (def: 60,200,60)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB2L<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B2L: Set Left Series Colors (from center) (#c23,#e54,#f85,#fa9)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB2R<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B2R: Set Right Series Colors (from center) (#17c,#29e,#8ce,#bdf)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB3<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B3: Set Max Scale Value (default: 100)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB4<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B4: Set Scale Labels (from center 0 to max) (def &#8220;0,50,100%&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB5<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B5: Set Value Prefix\/Suffix in CSV (eg. &#8220;$,&#8221;, &#8220;,usd&#8221;)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">BoolConfB6<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B6: Legend (Color Marker + Series Name), Hide or Show<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">BoolConfB7<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B7: Scale Labels, Hide or Show<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfC<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">C: Select FILE DATA to store Generated SVG (append)<span style=\"color:#990000;\"> *<\/span><\/dd>\n<\/div>\n<div style=\"margin:4px 0px 1em; border:1px dotted #aaa; padding:4px 0 0 4px\" title=\"Advanced\"><dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">StrConfB8<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">B8: Set SVG File Name (default: butterfly-chart.svg)<span style=\"color:#000099;\"><sup style=\"font-style:italic;\">#{EL}<\/sup><\/span><\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfD1<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">D1: Select NUMERIC for Number of TSV Lines (update)<\/dd>\n<dt style=\"font-weight: 300; font-size: 50%; margin: -1em 0 0 0; color: #aaa;\">SelectConfD2<\/dt><dd style=\"margin: -0.5em 0 0.1em 1em\">D2: Select NUMERIC for TSV Rows (ignore blanks) (update)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item\"><details><summary class=\"wp-block-coblocks-accordion-item__title has-background has-border-background-color\">Script (click to open)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\" style=\"border-color:#e7e5e4\">\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ Script Example of Business Process Automation\n\/\/ for &#39;engine type: 3&#39; (&quot;GraalJS standard mode&quot;)\n\n\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strTsv        = configs.get       ( &quot;StrConfA&quot; );     \/\/ REQUIRED\n  const arr2dTsv    = parseAsRectangular( strTsv );\n  if( arr2dTsv.length === 0 ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A: TSV} is empty \\n&quot; );\n  }\n  if( arr2dTsv.length === 1 ){\n    throw new Error( &quot;\\n AutomatedTask ConfigError:&quot; +\n                     &quot; Config {A: TSV} requires at least 2 lines (header and data) \\n&quot; );\n  }\n\n\/\/ \u8868\u793a\u5e45: [\u30e6\u30cb\u30c3\u30c8\u540d, \u7247\u5074\u68d2\u30b0\u30e9\u30d5, \u7247\u5074\u5408\u8a08\u5024]\nconst strWidths     = configs.get       ( &quot;StrConfB1&quot; ) || &quot;60,200,60&quot;; \/\/ default\nconst arrWidths     = strWidths.split(&quot;,&quot;);\nconst numWidthUnit  = parseInt (arrWidths[0], 10) || 60;\nconst numWidthBar   = parseInt (arrWidths[1], 10) || 200;\nconst numWidthTotal = parseInt (arrWidths[2], 10) || 60;\n\n\/\/ \u8272\u30d1\u30ec\u30c3\u30c8: \u540c\u7cfb\u30b0\u30e9\u30c7\u30fc\u30b7\u30e7\u30f3\uff08\u4e2d\u592e\u304b\u3089\u5916\u5074\u3078\uff09\nconst strColorsL    = configs.get       ( &quot;StrConfB2L&quot; ) || &quot;#c23,#e54,#f85,#fa9&quot;; \/\/ default \u8d64\u6a59\u30b0\u30e9\u30c7\u30fc\u30b7\u30e7\u30f3\nconst arrColorsL    = strColorsL.split(&quot;,&quot;).map(s =&gt; s.trim());\nconst strColorsR    = configs.get       ( &quot;StrConfB2R&quot; ) || &quot;#17c,#29e,#8ce,#bdf&quot;; \/\/ default \u9752\u7cfb\u30b0\u30e9\u30c7\u30fc\u30b7\u30e7\u30f3\nconst arrColorsR    = strColorsR.split(&quot;,&quot;).map(s =&gt; s.trim());\n\nconst parsedScale   = parseFloat( configs.get( &quot;StrConfB3&quot; ) );\nconst numMaxScale   = (parsedScale &gt; 0) ? parsedScale : 100;\n\n\/\/ \u7247\u5074\u76ee\u76db\u308a\u30e9\u30d9\u30eb (\u4e2d\u592e0\u304b\u3089\u6700\u5927\u5024\u3078)\nconst strLabels     = configs.get       ( &quot;StrConfB4&quot; ) || &quot;0,50,100%&quot;;\nconst arrLabels     = strLabels.split(&quot;,&quot;);\nconst leftLabels    = arrLabels.slice().reverse(); \/\/ \u5de6\u5074\u7528 (\u6700\u5927\u5024 -&gt; 0)\nconst rightLabels   = arrLabels;                  \/\/ \u53f3\u5074\u7528 (0 -&gt; \u6700\u5927\u5024)\n\nconst strPrefSuf    = configs.get       ( &quot;StrConfB5&quot; ) || &quot;,&quot;; \/\/ \u30c7\u30d5\u30a9\u30eb\u30c8\u306f\u30ab\u30f3\u30de\u306e\u307f\nconst arrPrefSuf    = strPrefSuf.split(&quot;,&quot;);\nconst strPrefix     = arrPrefSuf[0] || &quot;&quot;;\nconst strSuffix     = arrPrefSuf.length &gt; 1 ? arrPrefSuf[1] : &quot;&quot;;\nconst isShowLegend  = configs.getObject ( &quot;BoolConfB6&quot; );\nconst isShowLabels  = configs.getObject ( &quot;BoolConfB7&quot; );\nconst strFileName   = configs.get       ( &quot;StrConfB8&quot; ) || &quot;butterfly-chart.svg&quot;;\nconst filesPocketC  = configs.getObject ( &quot;SelectConfC&quot; ); \/\/ REQUIRED\nconst numPocketD1   = configs.getObject ( &quot;SelectConfD1&quot; );\nconst numPocketD2   = configs.getObject ( &quot;SelectConfD2&quot; );\n\n\n\/\/\/\/ == Data Parsing & Label Column Detection ==\n\/\/ \u30c7\u30fc\u30bf\u884c\uff082\u884c\u76ee\u4ee5\u964d\uff09\u3092\u8d70\u67fb\u3057\u3066\u3001\u96c6\u8a08\u5358\u4f4d\u3068\u306a\u308b\u300c\u4e2d\u592e\u30e9\u30d9\u30eb\u5217\uff08\u975e\u6570\u5024\u5217\uff09\u300d\u3092\u7279\u5b9a\nconst numCols = arr2dTsv[0].length;\nlet labelColIndex = -1;\n\nfor (let c = 0; c &lt; numCols; c++) {\n  let isNumericCol = true;\n  for (let r = 1; r &lt; arr2dTsv.length; r++) {\n    const rawVal = arr2dTsv[r][c].trim();\n    if (rawVal === &quot;&quot;) continue;\n    \/\/ \u30ab\u30f3\u30de\u3001\u7a7a\u767d\u3001\u901a\u8ca8\u8a18\u53f7(\u00a5, \uffe5, $, \u20ac)\u306e\u307f\u3092\u9664\u53bb\u3057\u3066\u7d14\u7c8b\u306a\u6570\u5024\u304b\u5224\u5b9a\n    const numCandidate = rawVal.replace(\/[,\\s\u00a5\uffe5$\u20ac%]\/g, &quot;&quot;);\n    if (numCandidate === &quot;&quot; || isNaN(Number(numCandidate))) {\n      isNumericCol = false;\n      break;\n    }\n  }\n  if (!isNumericCol) {\n    labelColIndex = c;\n    break; \/\/ \u975e\u6570\u5024\uff08\u30e9\u30d9\u30eb\uff09\u304c\u542b\u307e\u308c\u308b\u5217\u3092\u4e2d\u5fc3\u30e9\u30d9\u30eb\u5217\u3068\u7279\u5b9a\n  }\n}\n\n\/\/ \u5168\u5217\u304c\u7d14\u7c8b\u306a\u6570\u5024\uff08\u4f8b: 202601 \u7b49\u306eYYYYMM\u5f62\u5f0f\uff09\u3067\u898b\u3064\u304b\u3089\u306a\u3044\u5834\u5408\u306e\u30d5\u30a9\u30fc\u30eb\u30d0\u30c3\u30af\uff08\u4e2d\u592e\u5217\uff09\nif (labelColIndex === -1) {\n  labelColIndex = Math.floor(numCols \/ 2);\n  engine.log(&quot; AutomatedTask Warning: Label column not detected by text format. Defaulted to column index &quot; + labelColIndex + &quot;.&quot;);\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 (SVG\u6587\u5b57\u5217\u306e\u751f\u6210) ==\nconst marginL = 15; \/\/ \u5de6\u5074\u306e\u4f59\u767d\nconst marginR = 15; \/\/ \u53f3\u5074\u306e\u4f59\u767d\nconst xTotalL = marginL;\nconst xBarL   = xTotalL + numWidthTotal;\nconst xUnit   = xBarL   + numWidthBar;\nconst xBarR   = xUnit   + numWidthUnit;\nconst xTotalR = xBarR   + numWidthBar;\nconst svgTotalWidth = xTotalR + numWidthTotal + marginR;\n\nlet svgY = 12; \/\/ Y\u5ea7\u6a19\u306e\u521d\u671f\u30aa\u30d5\u30bb\u30c3\u30c8\nlet svgContent = `&lt;style&gt;text { font-family: sans-serif; font-size: 12px; fill: #333; }&lt;\/style&gt;\\n`;\n\n\/\/ XML\u30a8\u30b9\u30b1\u30fc\u30d7\u7528\u95a2\u6570\nfunction escapeXml(unsafe) {\n  if (unsafe === null || unsafe === undefined) return &quot;&quot;;\n  return String(unsafe).replace(\/[&lt;&gt;&&#39;&quot;]\/g, function (c) {\n    switch (c) {\n      case &#39;&lt;&#39;: return &#39;&lt;&#39;;\n      case &#39;&gt;&#39;: return &#39;&gt;&#39;;\n      case &#39;&&#39;: return &#39;&amp;&#39;;\n      case &#39;\\&#39;&#39;: return &#39;&apos;&#39;;\n      case &#39;&quot;&#39;: return &#39;&quot;&#39;;\n    }\n  });\n}\n\n\/\/ --- 1. \u51e1\u4f8b\u306e\u63cf\u753b ---\n\/\/ TSV\u306e\u7269\u7406\u7684\u4e26\u3073\u9806\uff08\u5de6\u7aef\u52170\u304b\u3089\u53f3\u7aef\u5217numCols-1\u307e\u3067\u81ea\u7136\u306b\u6d41\u3059\uff09\u306b\u7d71\u4e00\nif (isShowLegend) {\n  let lx = marginL;\n  const legendItems = [];\n\n  \/\/ \u5de6\u7cfb\u5217: \u52170\u304b\u3089 labelColIndex - 1 \u3078\uff08\u753b\u9762\u306e\u5de6\u7aef\u304b\u3089\u4e2d\u592e\u3078\u5411\u304b\u3046\u9806\uff09\n  for (let i = 0; i &lt; labelColIndex; i++) {\n    const distFromCenter = (labelColIndex - 1) - i;\n    const color = arrColorsL[distFromCenter % arrColorsL.length];\n    legendItems.push({ type: &quot;series&quot;, name: arr2dTsv[0][i], color: color });\n  }\n  \/\/ \u4e2d\u592e\u30e9\u30d9\u30eb\u5217\u306e\u30d8\u30c3\u30c0\u30fc\u540d\n  legendItems.push({ type: &quot;unit&quot;, name: &quot;[&quot; + arr2dTsv[0][labelColIndex] + &quot;]&quot; });\n  \/\/ \u53f3\u7cfb\u5217: labelColIndex + 1 \u304b\u3089 numCols - 1 \u3078\uff08\u4e2d\u592e\u304b\u3089\u53f3\u7aef\u3078\u5411\u304b\u3046\u9806\uff09\n  for (let i = labelColIndex + 1; i &lt; numCols; i++) {\n    const distFromCenter = i - (labelColIndex + 1);\n    const color = arrColorsR[distFromCenter % arrColorsR.length];\n    legendItems.push({ type: &quot;series&quot;, name: arr2dTsv[0][i], color: color });\n  }\n\n  for (let idx = 0; idx &lt; legendItems.length; idx++) {\n    const item = legendItems[idx];\n    const safeName = escapeXml(item.name);\n    \/\/ \u6587\u5b57\u5e45\u306e\u7c21\u6613\u63a8\u5b9a\uff08\u30de\u30eb\u30c1\u30d0\u30a4\u30c8\u6587\u5b57\u306f\u5e45\u5e83\u3081\u306b\u8a08\u7b97\uff09\n    let charWidthSum = 0;\n    for (let c = 0; c &lt; item.name.length; c++) {\n      charWidthSum += (item.name.charCodeAt(c) &gt; 255) ? 12 : 7;\n    }\n    const estimateW = charWidthSum + (item.type === &quot;series&quot; ? 18 : 8);\n\n    if (lx + estimateW &gt; svgTotalWidth - marginR && lx &gt; marginL) {\n      lx = marginL;\n      svgY += 18;\n    }\n\n    if (item.type === &quot;series&quot;) {\n      svgContent += `&lt;rect x=&quot;${lx}&quot; y=&quot;${svgY}&quot; width=&quot;10&quot; height=&quot;10&quot; fill=&quot;${escapeXml(item.color)}&quot; rx=&quot;2&quot;\/&gt;\\n`;\n      svgContent += `&lt;text x=&quot;${lx + 14}&quot; y=&quot;${svgY + 9}&quot; fill=&quot;${escapeXml(item.color)}&quot;&gt;${safeName}&lt;\/text&gt;\\n`;\n    } else {\n      svgContent += `&lt;text x=&quot;${lx}&quot; y=&quot;${svgY + 9}&quot; fill=&quot;#555&quot; font-weight=&quot;bold&quot;&gt;${safeName}&lt;\/text&gt;\\n`;\n    }\n    lx += estimateW + 10;\n  }\n  svgY += 24; \/\/ \u4e0b\u90e8\u30de\u30fc\u30b8\u30f3\n}\n\n\/\/ --- 2. \u76ee\u76db\u308a\u306e\u63cf\u753b ---\nif (isShowLabels) {\n  \/\/ \u5de6\u76ee\u76db\u308a (\u5916\u5074 -&gt; \u4e2d\u592e0)\n  const stepWL = numWidthBar \/ (leftLabels.length - 1 || 1);\n  for (let i = 0; i &lt; leftLabels.length; i++) {\n    const xPos = parseFloat((xBarL + (stepWL * i)).toFixed(2));\n    const anchor = i === 0 ? &quot;start&quot; : i === leftLabels.length - 1 ? &quot;end&quot; : &quot;middle&quot;;\n    svgContent += `&lt;text x=&quot;${xPos}&quot; y=&quot;${svgY + 10}&quot; fill=&quot;#777&quot; font-size=&quot;11&quot; text-anchor=&quot;${anchor}&quot;&gt;${escapeXml(leftLabels[i])}&lt;\/text&gt;\\n`;\n  }\n\n  \/\/ \u53f3\u76ee\u76db\u308a (\u4e2d\u592e0 -&gt; \u5916\u5074)\n  const stepWR = numWidthBar \/ (rightLabels.length - 1 || 1);\n  for (let i = 0; i &lt; rightLabels.length; i++) {\n    const xPos = parseFloat((xBarR + (stepWR * i)).toFixed(2));\n    const anchor = i === 0 ? &quot;start&quot; : i === rightLabels.length - 1 ? &quot;end&quot; : &quot;middle&quot;;\n    svgContent += `&lt;text x=&quot;${xPos}&quot; y=&quot;${svgY + 10}&quot; fill=&quot;#777&quot; font-size=&quot;11&quot; text-anchor=&quot;${anchor}&quot;&gt;${escapeXml(rightLabels[i])}&lt;\/text&gt;\\n`;\n  }\n\n  svgY += 18;\n}\n\n\/\/ --- 3. \u68d2\u30b0\u30e9\u30d5\u306e\u63cf\u753b ---\nconst rowHeight = 18; \/\/ 1\u884c\u306e\u9ad8\u3055\nfor (let i = 1; i &lt; arr2dTsv.length; i++) {\n  \/\/ \u5de6\u7cfb\u5217\u306e\u8a08\u7b97\uff08\u4e2d\u592e\u304b\u3089\u5916\u5074\u3078: labelColIndex - 1 \u304b\u3089 0 \u3078\uff09\n  let totalValL = 0;\n  const barsL = [];\n  for (let j = labelColIndex - 1; j &gt;= 0; j--) {\n    const rawVal = arr2dTsv[i][j] ? arr2dTsv[i][j].replace(\/[^0-9.-]\/g, &quot;&quot;) : &quot;&quot;;\n    const cellValue = parseFloat(rawVal) || 0;\n    totalValL += cellValue;\n    const distFromCenter = (labelColIndex - 1) - j;\n    const color = arrColorsL[distFromCenter % arrColorsL.length];\n    barsL.push({ name: arr2dTsv[0][j], val: cellValue, color: color });\n  }\n\n  \/\/ \u53f3\u7cfb\u5217\u306e\u8a08\u7b97\uff08\u4e2d\u592e\u304b\u3089\u5916\u5074\u3078: labelColIndex + 1 \u304b\u3089 numCols - 1 \u3078\uff09\n  let totalValR = 0;\n  const barsR = [];\n  for (let j = labelColIndex + 1; j &lt; numCols; j++) {\n    const rawVal = arr2dTsv[i][j] ? arr2dTsv[i][j].replace(\/[^0-9.-]\/g, &quot;&quot;) : &quot;&quot;;\n    const cellValue = parseFloat(rawVal) || 0;\n    totalValR += cellValue;\n    const distFromCenter = j - (labelColIndex + 1);\n    const color = arrColorsR[distFromCenter % arrColorsR.length];\n    barsR.push({ name: arr2dTsv[0][j], val: cellValue, color: color });\n  }\n\n  \/\/ \u2460 \u5de6\u5408\u8a08\u5024\uff08\u5de6\u68d2\u30b0\u30e9\u30d5\u306e\u3059\u3050\u5de6\u306b\u53f3\u63c3\u3048\u914d\u7f6e\uff09\n  const totalStrL = `${strPrefix}${totalValL.toLocaleString()}${strSuffix}`;\n  svgContent += `&lt;text x=&quot;${xBarL - 6}&quot; y=&quot;${svgY + 13}&quot; text-anchor=&quot;end&quot;&gt;${escapeXml(totalStrL)}&lt;\/text&gt;\\n`;\n\n  \/\/ \u2461 \u5de6\u5074\u68d2\u30b0\u30e9\u30d5\uff08\u80cc\u666f\u30b0\u30ec\u30fc \uff0b \u4e2d\u592exUnit\u304b\u3089\u5de6\u65b9\u5411\u3078\u7a4d\u307f\u4e0a\u3052\uff09\n  svgContent += `&lt;rect x=&quot;${xBarL}&quot; y=&quot;${svgY + 4}&quot; width=&quot;${numWidthBar}&quot; height=&quot;10&quot; fill=&quot;#eee&quot; rx=&quot;2&quot;\/&gt;\\n`;\n  const scaleFactorL = totalValL &gt; numMaxScale ? (numWidthBar \/ totalValL) : (numWidthBar \/ numMaxScale);\n  let currentXL = xUnit; \/\/ \u4e2d\u592e\u8ef8\u5074\uff08\u53f3\u7aef\uff09\u304b\u3089\u30b9\u30bf\u30fc\u30c8\u3057\u3066\u5de6\u3078\u9032\u3080\n  for (let b = 0; b &lt; barsL.length; b++) {\n    if (barsL[b].val &gt; 0) {\n      const barW = parseFloat((barsL[b].val * scaleFactorL).toFixed(2));\n      if (barW &gt; 0) {\n        currentXL = parseFloat((currentXL - barW).toFixed(2));\n        const valStr = `${strPrefix}${barsL[b].val.toLocaleString()}${strSuffix}`;\n        const tooltipText = escapeXml(`${barsL[b].name}: ${valStr}`);\n        svgContent += `&lt;rect x=&quot;${currentXL}&quot; y=&quot;${svgY + 4}&quot; width=&quot;${barW}&quot; height=&quot;10&quot; fill=&quot;${escapeXml(barsL[b].color)}&quot;&gt;\\n`;\n        svgContent += `  &lt;title&gt;${tooltipText}&lt;\/title&gt;\\n`;\n        svgContent += `&lt;\/rect&gt;\\n`;\n      }\n    }\n  }\n\n  \/\/ \u2462 \u4e2d\u592e\u30e6\u30cb\u30c3\u30c8\u540d\uff08\u4e2d\u592e\u63c3\u3048\uff09\n  const centerXUnit = parseFloat((xUnit + (numWidthUnit \/ 2)).toFixed(2));\n  svgContent += `&lt;text x=&quot;${centerXUnit}&quot; y=&quot;${svgY + 13}&quot; text-anchor=&quot;middle&quot;&gt;${escapeXml(arr2dTsv[i][labelColIndex])}&lt;\/text&gt;\\n`;\n\n  \/\/ \u2463 \u53f3\u5074\u68d2\u30b0\u30e9\u30d5\uff08\u80cc\u666f\u30b0\u30ec\u30fc \uff0b \u4e2d\u592exBarR\u304b\u3089\u53f3\u65b9\u5411\u3078\u7a4d\u307f\u4e0a\u3052\uff09\n  svgContent += `&lt;rect x=&quot;${xBarR}&quot; y=&quot;${svgY + 4}&quot; width=&quot;${numWidthBar}&quot; height=&quot;10&quot; fill=&quot;#eee&quot; rx=&quot;2&quot;\/&gt;\\n`;\n  const scaleFactorR = totalValR &gt; numMaxScale ? (numWidthBar \/ totalValR) : (numWidthBar \/ numMaxScale);\n  let currentXR = xBarR; \/\/ \u4e2d\u592e\u8ef8\u5074\uff08\u5de6\u7aef\uff09\u304b\u3089\u30b9\u30bf\u30fc\u30c8\u3057\u3066\u53f3\u3078\u9032\u3080\n  for (let b = 0; b &lt; barsR.length; b++) {\n    if (barsR[b].val &gt; 0) {\n      const barW = parseFloat((barsR[b].val * scaleFactorR).toFixed(2));\n      if (barW &gt; 0) {\n        const valStr = `${strPrefix}${barsR[b].val.toLocaleString()}${strSuffix}`;\n        const tooltipText = escapeXml(`${barsR[b].name}: ${valStr}`);\n        svgContent += `&lt;rect x=&quot;${currentXR}&quot; y=&quot;${svgY + 4}&quot; width=&quot;${barW}&quot; height=&quot;10&quot; fill=&quot;${escapeXml(barsR[b].color)}&quot;&gt;\\n`;\n        svgContent += `  &lt;title&gt;${tooltipText}&lt;\/title&gt;\\n`;\n        svgContent += `&lt;\/rect&gt;\\n`;\n        currentXR = parseFloat((currentXR + barW).toFixed(2));\n      }\n    }\n  }\n\n  \/\/ \u2464 \u53f3\u5408\u8a08\u5024\uff08\u53f3\u68d2\u30b0\u30e9\u30d5\u306e\u3059\u3050\u53f3\u306b\u5de6\u63c3\u3048\u914d\u7f6e\uff09\n  const totalStrR = `${strPrefix}${totalValR.toLocaleString()}${strSuffix}`;\n  svgContent += `&lt;text x=&quot;${xTotalR + 6}&quot; y=&quot;${svgY + 13}&quot; text-anchor=&quot;start&quot;&gt;${escapeXml(totalStrR)}&lt;\/text&gt;\\n`;\n\n  svgY += rowHeight; \/\/ \u6b21\u306e\u884c\u3078Y\u5ea7\u6a19\u3092\u79fb\u52d5\n}\n\n\/\/ --- 4. \u5168\u4f53\u3092SVG\u30bf\u30b0\u3067\u30e9\u30c3\u30d7 ---\nconst finalSvgHeight = svgY + 10;\nlet strSvg = `&lt;?xml version=&quot;1.0&quot; encoding=&quot;UTF-8&quot;?&gt;\\n`;\nstrSvg += `&lt;svg xmlns=&quot;http:\/\/www.w3.org\/2000\/svg&quot; viewBox=&quot;0 0 ${svgTotalWidth} ${finalSvgHeight}&quot; width=&quot;${svgTotalWidth}&quot; height=&quot;${finalSvgHeight}&quot;&gt;\\n`;\nstrSvg += `&lt;rect width=&quot;100%&quot; height=&quot;100%&quot; fill=&quot;#ffffff&quot;\/&gt;\\n`; \/\/ \u80cc\u666f\u306e\u900f\u904e\u9632\u6b62\u7528\u767d\u5857\u308a\nstrSvg += svgContent;\nstrSvg += `&lt;\/svg&gt;`;\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\n\/\/ SVG\u30d5\u30a1\u30a4\u30eb\u306e\u4fdd\u5b58 (C)\nif (filesPocketC !== null) { \n  let filesSvg = engine.findData(filesPocketC);\n  if (filesSvg === null) {\n    filesSvg = new java.util.ArrayList();\n  }\n  \n  let finalFileName = strFileName;\n  if (!finalFileName.toLowerCase().endsWith(&quot;.svg&quot;)) {\n    finalFileName += &quot;.svg&quot;;\n  }\n\n  filesSvg.add(\n    new com.questetra.bpms.core.event.scripttask.NewQfile(\n      finalFileName,\n      &quot;image\/svg+xml; charset=UTF-8&quot;,\n      strSvg\n    )\n  );\n  engine.setData(filesPocketC, filesSvg);\n}\n\n\/\/ \u30aa\u30ea\u30b8\u30ca\u30eb\u306eTSV\u6587\u5b57\u5217\u306e\u884c\u6570 (D1)\nif ( numPocketD1 !== null) { \n  const totalLines = strTsv.replace(\/\\r\\n?\/g, &quot;\\n&quot;).split(&quot;\\n&quot;).length;\n  engine.setData( numPocketD1, new java.math.BigDecimal(totalLines) );\n}\n\n\/\/ \u7a7a\u884c\u3092\u9664\u3044\u305fTSV\u884c\u6570 (D2)\nif ( numPocketD2 !== null) { \n  engine.setData( numPocketD2, new java.math.BigDecimal(arr2dTsv.length) );\n}\n\n} \/\/\/\/\/\/\/\/ END &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/**\n * Parses TSV string as a two-dimensional rectangular data matrix and creates a 2D array.\n * @param {string} strTsv - The input TSV string\n * @returns {Array&lt;Array&lt;string&gt;&gt;} Rectangular 2D array\n *\/\nfunction parseAsRectangular( strTsv ){\n  const arrTsv = strTsv.replace(\/\\r\\n?\/g, &quot;\\n&quot;).split(&quot;\\n&quot;);\n  let numMinWidth   = Infinity;\n  let numMaxWidth   = 0;\n  let numBlanklines = 0;\n  \n  const parsedRows = [];\n  for( let i = 0; i &lt; arrTsv.length; i++ ){\n    const line = arrTsv[i];\n    if( line === &quot;&quot; ){\n      numBlanklines++;\n      continue;\n    }\n    const arrCells = line.split(&quot;\\t&quot;);\n    const len = arrCells.length;\n    if( len &lt; numMinWidth ){ numMinWidth = len; }\n    if( len &gt; numMaxWidth ){ numMaxWidth = len; }\n    parsedRows.push( arrCells );\n  }\n  if( numMinWidth === Infinity ){\n    numMinWidth = 0;\n  }\n  engine.log( &quot; AutomatedTask TsvDataCheck:&quot; + \n              &quot; MinWidth:&quot; + numMinWidth +\n              &quot; MaxWidth:&quot; + numMaxWidth +\n              &quot; Lines:&quot; + arrTsv.length +\n              &quot; (BlankLines:&quot; + numBlanklines + &quot;)&quot; );\n\n  for( let i = 0; i &lt; parsedRows.length; i++ ){\n    const row = parsedRows[i];\n    while( row.length &lt; numMaxWidth ){\n      row.push( &quot;&quot; );\n    }\n  }\n  return parsedRows;\n}\n\n\n\/*\n### NOTES-en\n- A stacked butterfly chart (SVG file) is automatically generated each time a Case reaches this Automated Step.\n    - The TSV format expects the unit label (such as &quot;Quarter&quot; or &quot;YYYY-MM&quot;) to be in the middle column, flanked by left data series and right data series.\n    - Data rows from the second line onward are inspected to automatically detect the aggregation unit column (the column containing non-numeric strings).\n        - Characters like currency symbols ($ \/ \u00a5 \/ \u20ac) and thousands separator commas (,) are stripped before evaluating numeric values.\n        - If all columns are numeric (e.g. pure numbers like &quot;202601&quot;), the center column is chosen as a fail-safe fallback.\n    - The generated &quot;SVG file&quot; will be appended to the specified File-type data item.\n        - Left series are accumulated and rendered from the center baseline outwards to the left.\n        - Right series are accumulated and rendered from the center baseline outwards to the right.\n        - Each segment includes a `&lt;title&gt;` tooltip showing the series name and formatted value on hover.\n        - If the stacked total value on either side exceeds the &quot;Max Scale Value (B3)&quot;, the bars on that side are automatically scaled down to fit within `numWidthBar`.\n- The input TSV is parsed as the &quot;simplest tab-separated string&quot;.\n- The number of lines in the input TSV string can also be saved as Case Data.\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\u5de6\u53f3\u5bfe\u79f0\u306e\u7a4d\u307f\u4e0a\u3052\u30d0\u30bf\u30d5\u30e9\u30a4\u30c1\u30e3\u30fc\u30c8\uff08SVG\u30d5\u30a1\u30a4\u30eb\uff09\u304c\u751f\u6210\u3055\u308c\u307e\u3059\u3002\n    - \u5165\u529bTSV\u306f\u3001\u4e2d\u592e\u306e\u96c6\u8a08\u5358\u4f4d\u30e9\u30d9\u30eb\uff08\u300c\u56db\u534a\u671f\u300d\u3084\u300c\u5e74\u6708\u300d\u306a\u3069\uff09\u3092\u631f\u3093\u3067\u3001\u5de6\u5074\u306b\u5de6\u7cfb\u5217\u30c7\u30fc\u30bf\u3001\u53f3\u5074\u306b\u53f3\u7cfb\u5217\u30c7\u30fc\u30bf\u304c\u914d\u7f6e\u3055\u308c\u305f\u5f62\u5f0f\u3092\u60f3\u5b9a\u3057\u3066\u3044\u307e\u3059\u3002\n    - 2\u884c\u76ee\u4ee5\u964d\u306e\u30c7\u30fc\u30bf\u884c\u3092\u89e3\u6790\u3057\u3001\u975e\u6570\u5024\u6587\u5b57\u5217\u304c\u542b\u307e\u308c\u308b\u5217\uff08\u4e2d\u592e\u5217\uff09\u304c\u96c6\u8a08\u5358\u4f4d\u30e9\u30d9\u30eb\u3068\u3057\u3066\u81ea\u52d5\u5224\u5b9a\u3055\u308c\u307e\u3059\u3002\n        - \u901a\u8ca8\u8a18\u53f7\uff08\uffe5, $, \u20ac\uff09\u3084\u6841\u533a\u5207\u308a\u30ab\u30f3\u30de\uff08,\uff09\u306f\u9664\u53bb\u3055\u308c\u305f\u4e0a\u3067\u6570\u5024\u5224\u5b9a\u304c\u884c\u308f\u308c\u308b\u305f\u3081\u3001&quot;FY2026&quot; \u3084 &quot;2026-Q1&quot; \u3068\u3044\u3063\u305f\u82f1\u5b57\u30fb\u8a18\u53f7\u4ed8\u304d\u30e9\u30d9\u30eb\u3082\u6b63\u78ba\u306b\u5224\u5b9a\u3055\u308c\u307e\u3059\u3002\n        - \u5168\u5217\u304c\u7d14\u7c8b\u306a\u6570\u5024\u6587\u5b57\u5217\uff08&quot;202601&quot; \u306a\u3069\uff09\u306e\u5834\u5408\u306f\u3001\u30d5\u30a7\u30a4\u30eb\u30bb\u30fc\u30d5\u3068\u3057\u3066\u4e2d\u592e\u4ed8\u8fd1\u306e\u5217\u304c\u96c6\u8a08\u5358\u4f4d\u30e9\u30d9\u30eb\u3068\u3057\u3066\u63a1\u7528\u3055\u308c\u307e\u3059\u3002\n    - \u751f\u6210\u3055\u308c\u305f &quot;SVG\u30d5\u30a1\u30a4\u30eb&quot; \u306f\u3001\u6307\u5b9a\u3055\u308c\u305f\u30d5\u30a1\u30a4\u30eb\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u8ffd\u52a0\u4fdd\u5b58\u3055\u308c\u307e\u3059\u3002\n        - \u4e2d\u592e\u30e9\u30d9\u30eb\u5217\u306e\u5de6\u5074\u306b\u3042\u308b\u5404\u7cfb\u5217\u306f\u3001\u4e2d\u592e\u8ef8\u304b\u3089\u5916\u5074\uff08\u5de6\u65b9\u5411\uff09\u3078\u7a4d\u307f\u4e0a\u3052\u63cf\u753b\u3055\u308c\u307e\u3059\u3002\n        - \u4e2d\u592e\u30e9\u30d9\u30eb\u5217\u306e\u53f3\u5074\u306b\u3042\u308b\u5404\u7cfb\u5217\u306f\u3001\u4e2d\u592e\u8ef8\u304b\u3089\u5916\u5074\uff08\u53f3\u65b9\u5411\uff09\u3078\u7a4d\u307f\u4e0a\u3052\u63cf\u753b\u3055\u308c\u307e\u3059\u3002\n        - \u5404\u30b0\u30e9\u30d5\u8981\u7d20\u306b\u306f `&lt;title&gt;` \u30bf\u30b0\u304c\u57cb\u3081\u8fbc\u307e\u308c\u3001\u30de\u30a6\u30b9\u30db\u30d0\u30fc\u6642\u306b\u300c\u7cfb\u5217\u540d: \u6570\u5024\u300d\u306e\u30c4\u30fc\u30eb\u30c1\u30c3\u30d7\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002\n        - \u3044\u305a\u308c\u304b\u306e\u5074\u306e\u7a4d\u307f\u4e0a\u3052\u5408\u8a08\u5024\u304c\u300c\u30b0\u30e9\u30d5\u76ee\u76db\u308a\u306e\u6700\u5927\u5024\uff08B3\uff09\u300d\u3092\u8d85\u3048\u305f\u5834\u5408\u3001\u7247\u5074\u8868\u793a\u5e45\uff08`numWidthBar`\uff09\u306b\u53ce\u307e\u308b\u3088\u3046\u81ea\u52d5\u7e2e\u5c0f\u3055\u308c\u307e\u3059\u3002\n- \u5165\u529bTSV\u306f\u300c\u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u30bf\u30d6\u533a\u5207\u308a\u6587\u5b57\u5217\u300d\u3068\u3057\u3066\u30d1\u30fc\u30b9\u3055\u308c\u307e\u3059\u3002\n- \u5165\u529bTSV\u6587\u5b57\u5217\u306e\u884c\u6570\u3082\u30b1\u30fc\u30b9\u30c7\u30fc\u30bf\u3068\u3057\u3066\u683c\u7d0d\u53ef\u80fd\u3067\u3059\u3002\n\n#### TSV example\nSG&A\tR&D\tLabor\tMaterial\tQuarter\tDomestic\tNorthAmerica\tEurope\tAPAC\n10\t12\t18\t22\t2025-Q1\t28\t20\t14\t10\n11\t13\t19\t23\t2025-Q2\t30\t22\t15\t11\n12\t14\t20\t24\t2025-Q3\t31\t23\t16\t12\n13\t15\t21\t26\t2025-Q4\t34\t26\t18\t14\n11\t14\t19\t24\t2026-Q1\t31\t23\t16\t12\n12\t15\t20\t25\t2026-Q2\t33\t25\t17\t13\n13\t16\t21\t26\t2026-Q3\t35\t26\t18\t14\n\n### APPENDIX-en\n- Blank lines within the input TSV string are ignored.\n- Pixel Widths (B1): Set CSV values as &quot;Unit Width, Bar Width (one side), Total Width (one side)&quot;. The entire chart width will be LeftMargin + Total + Bar + Unit + Bar + Total + RightMargin.\n- Scale Labels (B4): Specify scale values from center (0) to outer edge (max). Left-side labels are automatically reversed.\n- The order of colors specified in CSV applies from the center baseline outwards to the sides:\n    - Left Series Colors (B2L): The 1st color is assigned to the column immediately to the left of the center label, the 2nd color to the next column outward, and so on.\n    - Right Series Colors (B2R): The 1st color is assigned to the column immediately to the right of the center label, the 2nd color to the next column outward, and so on.\n- The legend order matches the visual left-to-right order of the TSV table and stacked bars.\n- Special characters like `&lt;`, `&gt;`, `&` in the TSV string are automatically XML-escaped to prevent SVG corruption.\n- You can specify a prefix and suffix for total values on both ends:\n    - To add only a prefix: Set `$,` \u2192 `$62`\n    - To add only a suffix: Set `,M` \u2192 `62M`\n    - To add both: Set `approx. , units` \u2192 `approx. 62 units`\n\n### APPENDIX-ja\n- \u5165\u529bTSV\u6587\u5b57\u5217\u5185\u306e\u7a7a\u884c\u306f\u7121\u8996\u3055\u308c\u307e\u3059\u3002\n- \u8868\u793a\u5e45\uff08B1\uff09\uff1a\u300c\u30e6\u30cb\u30c3\u30c8\u540d\u5e45, \u68d2\u30b0\u30e9\u30d5\u5e45(\u7247\u5074), \u5408\u8a08\u5024\u5e45(\u7247\u5074)\u300d\u3092CSV\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002SVG\u5168\u4f53\u306e\u6a2a\u5e45\u306f\u300c\u5de6\u4f59\u767d + \u5408\u8a08\u5024 + \u68d2\u30b0\u30e9\u30d5 + \u30e6\u30cb\u30c3\u30c8\u540d + \u68d2\u30b0\u30e9\u30d5 + \u5408\u8a08\u5024 + \u53f3\u4f59\u767d\u300d\u3068\u306a\u308a\u307e\u3059\u3002\n- \u76ee\u76db\u308a\u6587\u5b57\u5217\uff08B4\uff09\uff1a\u300c\u4e2d\u592e(0)\u304b\u3089\u6700\u5927\u5024\u306b\u5411\u304b\u3046\u9806\u300d\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002\u5de6\u5074\u76ee\u76db\u308a\u306b\u306f\u81ea\u52d5\u7684\u306b\u53cd\u8ee2\u3057\u305f\u9806\u5e8f\u3067\u914d\u7f6e\u3055\u308c\u307e\u3059\u3002\n- \u7cfb\u5217\u8272\u306eCSV\u8a2d\u5b9a\u306f\u3001\u5de6\u53f3\u3068\u3082\u306b\u300c\u4e2d\u592e\u8ef8\u304b\u3089\u5916\u5074\u306b\u5411\u304b\u3046\u9806\u300d\u3067\u9069\u7528\u3055\u308c\u307e\u3059\u3002\n    - \u5de6\u7cfb\u5217\uff08B2L\uff09\uff1a1\u756a\u76ee\u306e\u8272\u304c\u4e2d\u592e\u30e9\u30d9\u30eb\u306e\u76f4\u5de6\u306e\u5217\u306b\u30012\u756a\u76ee\u306e\u8272\u304c\u3055\u3089\u306b\u305d\u306e\u5916\u5074\u306e\u5217\u306b\u9069\u7528\u3055\u308c\u307e\u3059\u3002\n    - \u53f3\u7cfb\u5217\uff08B2R\uff09\uff1a1\u756a\u76ee\u306e\u8272\u304c\u4e2d\u592e\u30e9\u30d9\u30eb\u306e\u76f4\u53f3\u306e\u5217\u306b\u30012\u756a\u76ee\u306e\u8272\u304c\u3055\u3089\u306b\u305d\u306e\u5916\u5074\u306e\u5217\u306b\u9069\u7528\u3055\u308c\u307e\u3059\u3002\n- \u51e1\u4f8b\u306f\u3001\u30c1\u30e3\u30fc\u30c8\u304a\u3088\u3073TSV\u306e\u4e26\u3073\u3068\u540c\u3058\u304f\u300c\u5de6\u7aef\u304b\u3089\u4e2d\u592e\u3092\u7d4c\u3066\u53f3\u7aef\u3078\u6d41\u308c\u308b\u81ea\u7136\u306a\u9806\u5e8f\u300d\u3067\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n- TSV\u5185\u306e `&lt;` \u3084 `&` \u3068\u3044\u3063\u305f\u7279\u6b8a\u8a18\u53f7\u306f\u3001SVG\u30d5\u30a1\u30a4\u30eb\u306e\u7834\u640d\u3092\u9632\u3050\u305f\u3081\u306b\u81ea\u52d5\u7684\u306bXML\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u307e\u3059\u3002\n- \u5de6\u53f3\u306e\u5408\u8a08\u5024\u304a\u3088\u3073\u30c4\u30fc\u30eb\u30c1\u30c3\u30d7\u306b\u306f\u5171\u901a\u306e\u63a5\u982d\u8f9e\u30fb\u63a5\u5c3e\u8f9e\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002\n    - \u524d\u3060\u3051\u306b\u3064\u3051\u305f\u3044\u5834\u5408: `\uffe5,` \u3068\u8a2d\u5b9a \u2192 `\uffe562`\n    - \u5f8c\u308d\u3060\u3051\u306b\u3064\u3051\u305f\u3044\u5834\u5408: `,\u767e\u4e07\u5186` \u3068\u8a2d\u5b9a \u2192 `62\u767e\u4e07\u5186`\n    - \u524d\u5f8c\u4e21\u65b9\u306b\u3064\u3051\u305f\u3044\u5834\u5408: `\u7d04,\u4ef6` \u3068\u8a2d\u5b9a \u2192 `\u7d0462\u4ef6`\n*\/\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Download<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a rel=\"noreferrer noopener\" href=\"https:\/\/drive.google.com\/file\/d\/10_UM22aLclJtFQSM2MtSUnhBn5S8V57a\/view?usp=drivesdk\" target=\"_blank\">converter-tsv-string-to-butterfly-svg-2026.xml<\/a>\n<ul class=\"wp-block-list\">\n<li>2026-11-10 (C) Questetra, Inc. (MIT License)<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<div class=\"has-small-font-size\" style=\"text-align: right;\"><div style=\"display: inline-block; background: #FBE7DD; text-align: center;\">\n<span class=\"material-icons\">warning<\/span> Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<br>\n(Installing <em><strong>Addon Auto-Steps<\/strong><\/em> are available only on the <em><strong><span style=\"color: #1970B9\">Professional<\/span><\/strong><\/em> edition.)\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Notes<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A stacked butterfly chart (SVG file) is automatically generated each time a Case reaches this Automated Step.\n<ul class=\"wp-block-list\">\n<li>The TSV format expects the unit label (such as &#8220;Quarter&#8221; or &#8220;YYYY-MM&#8221;) to be in the middle column, flanked by left data series and right data series.<\/li>\n\n\n\n<li>Data rows from the second line onward are inspected to automatically detect the aggregation unit column (the column containing non-numeric strings).\n<ul class=\"wp-block-list\">\n<li>Characters like currency symbols ($ \/ \\ \/ ?) and thousands separator commas (,) are stripped before evaluating numeric values.<\/li>\n\n\n\n<li>If all columns are numeric (e.g. pure numbers like &#8220;202601&#8221;), the center column is chosen as a fail-safe fallback.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The generated &#8220;SVG file&#8221; will be appended to the specified File-type data item.\n<ul class=\"wp-block-list\">\n<li>Left series are accumulated and rendered from the center baseline outwards to the left.<\/li>\n\n\n\n<li>Right series are accumulated and rendered from the center baseline outwards to the right.<\/li>\n\n\n\n<li>Each segment includes a <code>&lt;title><\/code> tooltip showing the series name and formatted value on hover.<\/li>\n\n\n\n<li>If the stacked total value on either side exceeds the &#8220;Max Scale Value (B3)&#8221;, the bars on that side are automatically scaled down to fit within <code>numWidthBar<\/code>.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The input TSV is parsed as the &#8220;simplest tab-separated string&#8221;.<\/li>\n\n\n\n<li>The number of lines in the input TSV string can also be saved as Case Data.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Capture<\/span><\/h3>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6afe610aecd20&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6afe610aecd20\" class=\"wp-block-image size-large has-lightbox wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"536\" data-attachment-id=\"200287\" data-permalink=\"https:\/\/support.questetra.com\/en\/converter-tsv-string-to-butterfly-svg-2026-en-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1200%2C628&amp;ssl=1\" data-orig-size=\"1200,628\" data-comments-opened=\"0\" data-image-title=\"converter-tsv-string-to-butterfly-svg-2026-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1024%2C536&amp;ssl=1\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en-1024x536.png?resize=1024%2C536&#038;ssl=1\" alt=\"Converter: #TSV String to #Butterfly-SVG File\" class=\"wp-image-200287\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=1024%2C536&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=600%2C315&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=768%2C402&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?w=1200&amp;ssl=1 1200w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6afe610aed870&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6afe610aed870\" class=\"wp-block-image size-full has-custom-border is-style-rounded has-lightbox is-style-rounded--1 wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"726\" height=\"259\" data-attachment-id=\"200289\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-chart-example-svg-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-example-svg.png?fit=726%2C259&amp;ssl=1\" data-orig-size=\"726,259\" data-comments-opened=\"0\" data-image-title=\"butterfly-chart-example-svg\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-example-svg.png?fit=726%2C259&amp;ssl=1\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-example-svg.png?resize=726%2C259&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200289\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-example-svg.png?w=726&amp;ssl=1 726w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-example-svg.png?resize=600%2C214&amp;ssl=1 600w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6afe610aee2ae&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6afe610aee2ae\" class=\"wp-block-image size-full has-custom-border is-style-rounded has-lightbox is-style-rounded--2 wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"727\" height=\"297\" data-attachment-id=\"200291\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-chart-male-female-svg-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-male-female-svg.png?fit=727%2C297&amp;ssl=1\" data-orig-size=\"727,297\" data-comments-opened=\"0\" data-image-title=\"butterfly-chart-male-female-svg\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-male-female-svg.png?fit=727%2C297&amp;ssl=1\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-male-female-svg.png?resize=727%2C297&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200291\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-male-female-svg.png?w=727&amp;ssl=1 727w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-male-female-svg.png?resize=600%2C245&amp;ssl=1 600w\" sizes=\"auto, (max-width: 727px) 100vw, 727px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6afe610aeedb8&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6afe610aeedb8\" class=\"wp-block-image size-large has-custom-border is-style-rounded has-lightbox is-style-rounded--3 wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"241\" data-attachment-id=\"200295\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-chart-necc-svg-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc-svg.png?fit=1111%2C262&amp;ssl=1\" data-orig-size=\"1111,262\" data-comments-opened=\"0\" data-image-title=\"butterfly-chart-necc-svg\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc-svg.png?fit=1024%2C241&amp;ssl=1\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc-svg.png?resize=1024%2C241&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200295\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc-svg.png?resize=1024%2C241&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc-svg.png?resize=600%2C141&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc-svg.png?resize=768%2C181&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc-svg.png?w=1111&amp;ssl=1 1111w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6afe610aef87e&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6afe610aef87e\" class=\"wp-block-image size-large has-custom-border is-style-rounded has-lightbox is-style-rounded--4 wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"227\" data-attachment-id=\"200293\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-chart-necc2-svg-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc2-svg.png?fit=1104%2C245&amp;ssl=1\" data-orig-size=\"1104,245\" data-comments-opened=\"0\" data-image-title=\"butterfly-chart-necc2-svg\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc2-svg.png?fit=1024%2C227&amp;ssl=1\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc2-svg.png?resize=1024%2C227&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200293\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc2-svg.png?resize=1024%2C227&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc2-svg.png?resize=600%2C133&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc2-svg.png?resize=768%2C170&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-chart-necc2-svg.png?w=1104&amp;ssl=1 1104w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">Appendix<\/span><\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Blank lines within the input TSV string are ignored.<\/li>\n\n\n\n<li>Pixel Widths (B1): Set CSV values as &#8220;Unit Width, Bar Width (one side), Total Width (one side)&#8221;. The entire chart width will be LeftMargin + Total + Bar + Unit + Bar + Total + RightMargin.<\/li>\n\n\n\n<li>Scale Labels (B4): Specify scale values from center (0) to outer edge (max). Left-side labels are automatically reversed.<\/li>\n\n\n\n<li>The order of colors specified in CSV applies from the center baseline outwards to the sides:\n<ul class=\"wp-block-list\">\n<li>Left Series Colors (B2L): The 1st color is assigned to the column immediately to the left of the center label, the 2nd color to the next column outward, and so on.<\/li>\n\n\n\n<li>Right Series Colors (B2R): The 1st color is assigned to the column immediately to the right of the center label, the 2nd color to the next column outward, and so on.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>The legend order matches the visual left-to-right order of the TSV table and stacked bars.<\/li>\n\n\n\n<li>Special characters like <code>&lt;<\/code>, <code>><\/code>, <code>&amp;<\/code> in the TSV string are automatically XML-escaped to prevent SVG corruption.<\/li>\n\n\n\n<li>You can specify a prefix and suffix for total values on both ends:\n<ul class=\"wp-block-list\">\n<li>To add only a prefix: Set <code>$,<\/code> \u2192 <code>$62<\/code><\/li>\n\n\n\n<li>To add only a suffix: Set <code>,M<\/code> \u2192 <code>62M<\/code><\/li>\n\n\n\n<li>To add both: Set <code>approx. , units<\/code> \u2192 <code>approx. 62 units<\/code><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" style=\"margin-top:var(--wp--preset--spacing--60)\"><span style=\"text-decoration: underline;\">See Also<\/span><\/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=\"no1h81YErs\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-svg-file-2026\/\">Converter: #TSV String to #SVG File<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cConverter: #TSV String to #SVG File\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-svg-file-2026\/embed\/#?secret=RbyPwHE6b5#?secret=no1h81YErs\" data-secret=\"no1h81YErs\" 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=\"wlsyDaMHaB\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-markdown-chart-string-2026\/\">Converter: #TSV String to #MdChart String<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cConverter: #TSV String to #MdChart String\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-markdown-chart-string-2026\/embed\/#?secret=8PeLkHCJdZ#?secret=wlsyDaMHaB\" data-secret=\"wlsyDaMHaB\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Converts a numeric TSV string into a stacked butterfly chart SVG file. The middle text column is detected as the aggregation unit (e.g. &#8220;2026-11&#8221; or &#8220;FY2026&#8221;), with left columns rendered extending leftward and right columns extending rightward.<\/p>\n","protected":false},"author":2,"featured_media":200287,"comment_status":"closed","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":"","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":[4405,389],"faq_section":[],"class_list":["post-200316","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-markdown-en","tag-tsv-csv"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1200%2C628&ssl=1",1200,628,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=600%2C315&ssl=1",600,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=768%2C402&ssl=1",768,402,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1024%2C536&ssl=1",1024,536,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1200%2C628&ssl=1",1200,628,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1200%2C628&ssl=1",1200,628,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=1200%2C628&ssl=1",1200,628,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=900%2C628&ssl=1",900,628,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=1200%2C628&ssl=1",1200,628,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=600%2C628&ssl=1",600,628,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=800%2C628&ssl=1",800,628,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-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\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1200%2C628&ssl=1",1200,628,true]},"uagb_author_info":{"display_name":"IMAMURA, Genichi","author_link":"https:\/\/support.questetra.com\/en\/author\/imamuragenichi\/"},"uagb_comment_info":0,"uagb_excerpt":"Converts a numeric TSV string into a stacked butterfly chart SVG file. The middle text column is detected as the aggregation unit (e.g. \"2026-11\" or \"FY2026\"), with left columns rendered extending leftward and right columns extending rightward.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-Q6U","jetpack-related-posts":[{"id":69088,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsvtoexcelcsv\/","url_meta":{"origin":200316,"position":0},"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":82453,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-excelcsv-to-table\/","url_meta":{"origin":200316,"position":1},"title":"Converter (TSV File to Table type data)","author":"Shiho Tatsumi","date":"2024-08-01","format":false,"excerpt":"This item overwrites the value of a Table type data item with a contents of an Excel compatible CSV file (TSV UTF-16 LE with BOM) stored in a File type data item.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69082,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsvtoexcelcsvsjis\/","url_meta":{"origin":200316,"position":2},"title":"Converter (TSV to Excel-CSV) SJIS","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"Download Converter-TsvToExcelCsvSjis.xml Capture Notes It is also capable of changing the order of columns, filtering, listing duplicately.The file entity consists of comma-separated-values (Shift-JIS)Compare to tab-separated-values (utf-16le-bom) version, the availability of smartphone display and data import increases, but comma information in data misses. See also 2017-04-03 Episode 529: Making PayPal Operation\u2026","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-to-excel-csv-sjis-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-to-excel-csv-sjis-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-to-excel-csv-sjis-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-to-excel-csv-sjis-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-to-excel-csv-sjis-header.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69682,"url":"https:\/\/support.questetra.com\/en\/bpmn-icons\/converter-tabletoexcelcsv\/","url_meta":{"origin":200316,"position":3},"title":"Converter (Table type data to Excel-CSV File)","author":"Shiho Tatsumi","date":"2024-07-05","format":false,"excerpt":"This item stores the values in a Table type data item into a File type data item as an Excel compatible CSV. The file is added and does not affect existing files.","rel":"","context":"In &quot;BPMN Icons&quot;","block_context":{"text":"BPMN Icons","link":"https:\/\/support.questetra.com\/en\/category\/bpmn-icons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/01\/bpmn-icon-service-task-converter.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":108989,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsvtoexcelcsv-2021\/","url_meta":{"origin":200316,"position":4},"title":"Converter (TSV to Excel-CSV FILE)","author":"Hirotaka NISHI","date":"2021-07-07","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":109322,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsvtoexcelcsvsjis-2021\/","url_meta":{"origin":200316,"position":5},"title":"Converter (TSV to Excel-CSV FILE) sjis","author":"Hirotaka NISHI","date":"2021-07-13","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\/2016\/11\/Converter-TableToExcelCsvSjis_fi_en.png?fit=1200%2C630&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/Converter-TableToExcelCsvSjis_fi_en.png?fit=1200%2C630&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/Converter-TableToExcelCsvSjis_fi_en.png?fit=1200%2C630&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/Converter-TableToExcelCsvSjis_fi_en.png?fit=1200%2C630&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/11\/Converter-TableToExcelCsvSjis_fi_en.png?fit=1200%2C630&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-en.png?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/200316","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=200316"}],"version-history":[{"count":14,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/200316\/revisions"}],"predecessor-version":[{"id":200330,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/200316\/revisions\/200330"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/200287"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=200316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=200316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=200316"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=200316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}