{"id":200364,"date":"2026-11-19T14:26:22","date_gmt":"2026-11-19T05:26:22","guid":{"rendered":"https:\/\/support.questetra.com\/?p=200364"},"modified":"2026-11-19T14:26:25","modified_gmt":"2026-11-19T05:26:25","slug":"converter-tsv-string-to-butterfly-mdchart-2026","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-butterfly-mdchart-2026\/","title":{"rendered":"Converter: #TSV String to #Butterfly-MdChart String"},"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-MdChart String<\/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-MdChart \u6587\u5b57\u5217<\/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 Markdown-embeddable stacked butterfly chart. 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 DATA to store Converted Markdown String (update)<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 Max Num of MdChart String (default: 8000)<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     = escaper.escapeHtml( arrPrefSuf[0] || &quot;&quot; );\nconst strSuffix     = escaper.escapeHtml( arrPrefSuf.length &gt; 1 ? arrPrefSuf[1] : &quot;&quot; );\nconst isShowLegend  = configs.getObject ( &quot;BoolConfB6&quot; );\nconst isShowLabels  = configs.getObject ( &quot;BoolConfB7&quot; );\nconst numMaxLength  = parseInt(configs.get(&quot;StrConfB8&quot; ), 10) || 8000;\nconst strPocketC    = configs.getObject ( &quot;SelectConfC&quot; );\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 ==\nlet strMarkdown = &quot;&quot;;\n\n\/\/ 1. \u51e1\u4f8b\u306e\u8868\u793a\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 strLegend = &quot;&quot;;\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    strLegend += `&lt;span style=&quot;color:${color}&quot;&gt;\u25a0${escaper.escapeHtml(arr2dTsv[0][i])}&lt;\/span&gt; `;\n  }\n  \/\/ \u4e2d\u592e\u30e9\u30d9\u30eb\u5217\u306e\u30d8\u30c3\u30c0\u30fc\u540d\n  strLegend += `&lt;span style=&quot;color:#555;font-weight:bold&quot;&gt;[${escaper.escapeHtml(arr2dTsv[0][labelColIndex])}]&lt;\/span&gt; `;\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    strLegend += `&lt;span style=&quot;color:${color}&quot;&gt;\u25a0${escaper.escapeHtml(arr2dTsv[0][i])}&lt;\/span&gt; `;\n  }\n  strMarkdown += strLegend + &quot;\\n&quot;;\n}\n\n\/\/ 2. \u76ee\u76db\u308a\u306e\u8868\u793a\nif (isShowLabels) {\n  let strScale = `&lt;div style=&quot;display:flex;align-items:center;color:#777;font-size:11px&quot;&gt;`;\n  strScale += `&lt;span style=&quot;width:${numWidthTotal}px&quot;&gt;&lt;\/span&gt;`;\n\n  \/\/ \u5de6\u76ee\u76db\u308a (\u5916\u5074 -&gt; \u4e2d\u592e0)\n  strScale += `&lt;span style=&quot;display:flex;width:${numWidthBar}px;justify-content:space-between&quot;&gt;`;\n  for (let i = 0; i &lt; leftLabels.length; i++) {\n    strScale += `&lt;span&gt;${escaper.escapeHtml(leftLabels[i])}&lt;\/span&gt;`;\n  }\n  strScale += `&lt;\/span&gt;`;\n\n  \/\/ \u4e2d\u592e\u30e9\u30d9\u30eb\u30b9\u30da\u30fc\u30b9\n  strScale += `&lt;span style=&quot;width:${numWidthUnit}px&quot;&gt;&lt;\/span&gt;`;\n\n  \/\/ \u53f3\u76ee\u76db\u308a (\u4e2d\u592e0 -&gt; \u5916\u5074)\n  strScale += `&lt;span style=&quot;display:flex;width:${numWidthBar}px;justify-content:space-between&quot;&gt;`;\n  for (let i = 0; i &lt; rightLabels.length; i++) {\n    strScale += `&lt;span&gt;${escaper.escapeHtml(rightLabels[i])}&lt;\/span&gt;`;\n  }\n  strScale += `&lt;\/span&gt;`;\n\n  strScale += `&lt;span style=&quot;width:${numWidthTotal}px&quot;&gt;&lt;\/span&gt;&lt;\/div&gt;`;\n  strMarkdown += strScale + &quot;\\n&quot;;\n}\n\n\/\/ 3. \u68d2\u30b0\u30e9\u30d5\u306e\u8868\u793a\nfor (let i = 1; i &lt; arr2dTsv.length; i++) {\n  let strRow = &quot;&quot;;\n\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({ 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({ val: cellValue, color: color });\n  }\n\n  \/\/ 1\u884c\u306eflex\u30b3\u30f3\u30c6\u30ca\u958b\u59cb\n  strRow += `&lt;div style=&quot;display:flex;align-items:center&quot;&gt;`;\n\n  \/\/ \u2460 \u5de6\u5408\u8a08\u5024\uff08\u4e00\u756a\u5de6\u7aef\uff09\n  strRow += `&lt;span style=&quot;width:${numWidthTotal}px;text-align:right&quot;&gt;`;\n  strRow += `${strPrefix}${totalValL.toLocaleString()}${strSuffix}&nbsp;&lt;\/span&gt;`;\n\n  \/\/ \u2461 \u5de6\u5074\u68d2\u30b0\u30e9\u30d5\uff08\u5024\u304c0\u3088\u308a\u5927\u304d\u3044\u30bb\u30b0\u30e1\u30f3\u30c8\u306e\u307f\u51fa\u529b\u3057\u3066\u6587\u5b57\u6570\u3092\u7bc0\u7d04\uff09\n  strRow += `&lt;span style=&quot;width:${numWidthBar}px;background:#eee&quot;&gt;`;\n  strRow += `&lt;span style=&quot;display:flex;flex-direction:row-reverse;height:10px&quot;&gt;`;\n  for (let b = 0; b &lt; barsL.length; b++) {\n    const ratio = Math.max(0, barsL[b].val \/ numMaxScale);\n    const ratioRounded = parseFloat(ratio.toFixed(4));\n    if (ratioRounded &gt; 0) {\n      strRow += `&lt;span style=&quot;flex:${ratioRounded};background:${barsL[b].color}&quot;&gt;&lt;\/span&gt;`;\n    }\n  }\n  const blankRatioL = parseFloat(Math.max(0, 1 - (totalValL \/ numMaxScale)).toFixed(4));\n  if (blankRatioL &gt; 0) {\n    strRow += `&lt;span style=&quot;flex:${blankRatioL}&quot;&gt;&lt;\/span&gt;`;\n  }\n  strRow += `&lt;\/span&gt;&lt;\/span&gt;`;\n\n  \/\/ \u2462 \u4e2d\u592e\u30e6\u30cb\u30c3\u30c8\u540d\n  strRow += `&lt;span style=&quot;width:${numWidthUnit}px;text-align:center;font-size:12px;overflow:hidden;white-space:nowrap&quot;&gt;`;\n  strRow += escaper.escapeHtml( arr2dTsv[i][labelColIndex] );\n  strRow += `&lt;\/span&gt;`;\n\n  \/\/ \u2463 \u53f3\u5074\u68d2\u30b0\u30e9\u30d5\uff08\u5de6\u304b\u3089\u53f3\u3078\u7a4d\u3080: flex-direction: row\uff09\n  strRow += `&lt;span style=&quot;width:${numWidthBar}px;background:#eee&quot;&gt;`;\n  strRow += `&lt;span style=&quot;display:flex;height:10px&quot;&gt;`;\n  for (let b = 0; b &lt; barsR.length; b++) {\n    const ratio = Math.max(0, barsR[b].val \/ numMaxScale);\n    const ratioRounded = parseFloat(ratio.toFixed(4));\n    if (ratioRounded &gt; 0) {\n      strRow += `&lt;span style=&quot;flex:${ratioRounded};background:${barsR[b].color}&quot;&gt;&lt;\/span&gt;`;\n    }\n  }\n  \/\/ \u4f59\u767d\uff08\u5916\u5074\uff09\n  const blankRatioR = parseFloat(Math.max(0, 1 - (totalValR \/ numMaxScale)).toFixed(4));\n  if (blankRatioR &gt; 0) {\n    strRow += `&lt;span style=&quot;flex:${blankRatioR}&quot;&gt;&lt;\/span&gt;`;\n  }\n  strRow += `&lt;\/span&gt;&lt;\/span&gt;`;\n\n  \/\/ \u2464 \u53f3\u5408\u8a08\u5024\uff08\u4e00\u756a\u53f3\u7aef\uff09\n  strRow += `&lt;span style=&quot;width:${numWidthTotal}px&quot;&gt;`;\n  strRow += `&nbsp;${strPrefix}${totalValR.toLocaleString()}${strSuffix}&lt;\/span&gt;`;\n\n  strRow += `&lt;\/div&gt;\\n`;\n\n  \/\/ \u6587\u5b57\u6570\u5236\u9650\u30c1\u30a7\u30c3\u30af (B8)\n  if (strMarkdown.length + strRow.length &gt; numMaxLength) {\n    engine.log(&quot;Warning: Reached Max Length (&quot; + numMaxLength + &quot;) at row &quot; + i + &quot;. Stopping chart generation to prevent unclosed HTML tags.&quot;);\n    break; \n  }\n  strMarkdown += strRow;\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, strMarkdown );\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 (ButterflyMdChart string) 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 &quot;ButterflyMdChart string&quot; is an HTML string where `div` and `span` elements are arranged using flexbox.\n        - Left series are accumulated and rendered from the center baseline outwards to the left (`flex-direction: row-reverse`).\n        - Right series are accumulated and rendered from the center baseline outwards to the right (`flex-direction: row`).\n        - Flex values are rounded to 4 decimal places to minimize HTML string length and prevent hitting character limits.\n- The input TSV is parsed as the &quot;simplest tab-separated string&quot;.\n    - Double quotes and other characters within the TSV string are retained as is.\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\uff08ButterflyMdChart\u6587\u5b57\u5217\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    - &quot;ButterflyMdChart\u6587\u5b57\u5217&quot; \u306f `div` \u3068 `span` \u304c flex \u914d\u7f6e\u3055\u308c\u305fHTML\u6587\u5b57\u5217\u3067\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        - flex\u6bd4\u7387\u306f\u5c0f\u6570\u70b9\u7b2c4\u4f4d\u306b\u4e38\u3081\u3089\u308c\u3001HTML\u6587\u5b57\u5217\u9577\u306e\u6d88\u8cbb\uff088,000\u6587\u5b57\u4e0a\u9650\uff09\u3092\u6291\u3048\u308b\u3088\u3046\u6700\u9069\u5316\u3055\u308c\u3066\u3044\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    - TSV\u6587\u5b57\u5217\u5185\u306e\u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u7b49\u3082\u3001\u305d\u306e\u307e\u307e\u4fdd\u6301\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 row width will be Total + Bar + Unit + Bar + Total.\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- 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\u3002\u884c\u5168\u4f53\u306e\u8868\u793a\u5e45\u306f\u300c\u5408\u8a08\u5024 + \u68d2\u30b0\u30e9\u30d5 + \u30e6\u30cb\u30c3\u30c8\u540d + \u68d2\u30b0\u30e9\u30d5 + \u5408\u8a08\u5024\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- \u5de6\u53f3\u306e\u5408\u8a08\u5024\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\/1KXlDdiN1mWdCgcgR84raLLli06XAwhrk\/view?usp=drivesdk\" target=\"_blank\">converter-tsv-string-to-butterfly-mdchart-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 (ButterflyMdChart string) 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 &#8220;ButterflyMdChart string&#8221; is an HTML string where <code>div<\/code> and <code>span<\/code> elements are arranged using flexbox.\n<ul class=\"wp-block-list\">\n<li>Left series are accumulated and rendered from the center baseline outwards to the left (<code>flex-direction: row-reverse<\/code>).<\/li>\n\n\n\n<li>Right series are accumulated and rendered from the center baseline outwards to the right (<code>flex-direction: row<\/code>).<\/li>\n\n\n\n<li>Flex values are rounded to 4 decimal places to minimize HTML string length and prevent hitting character limits.<\/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;.\n<ul class=\"wp-block-list\">\n<li>Double quotes and other characters within the TSV string are retained as is.<\/li>\n<\/ul>\n<\/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;6b01f20adf03b&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b01f20adf03b\" 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=\"200365\" data-permalink=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-butterfly-mdchart-2026\/attachment\/converter-tsv-string-to-butterfly-mdchart-2026-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-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-mdchart-2026-en\" data-image-description=\"&lt;p&gt;Converts a numeric TSV string into a Markdown-embeddable stacked butterfly chart. The middle text column is detected as the aggregation unit (e.g. &amp;#8220;2026-11&amp;#8221; or &amp;#8220;FY2026&amp;#8221;), with left columns rendered extending leftward and right columns extending rightward.&lt;\/p&gt;\n\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-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-mdchart-2026-en-1024x536.png?resize=1024%2C536&#038;ssl=1\" alt=\"Converter: #TSV String to #Butterfly-MdChart String\" class=\"wp-image-200365\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-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-mdchart-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-mdchart-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-mdchart-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;6b01f20ae028d&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b01f20ae028d\" class=\"wp-block-image size-large 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=\"1024\" height=\"301\" data-attachment-id=\"200341\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-mdchart-example-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-example.png?fit=1192%2C350&amp;ssl=1\" data-orig-size=\"1192,350\" data-comments-opened=\"0\" data-image-title=\"butterfly-mdchart-example\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-example.png?fit=1024%2C301&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-mdchart-example-1024x301.png?resize=1024%2C301&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200341\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-example.png?resize=1024%2C301&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-example.png?resize=600%2C176&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-example.png?resize=768%2C226&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-example.png?w=1192&amp;ssl=1 1192w\" 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;6b01f20ae13d0&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b01f20ae13d0\" class=\"wp-block-image size-large 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=\"1024\" height=\"373\" data-attachment-id=\"200343\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-mdchart-male-female-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-male-female.png?fit=1180%2C430&amp;ssl=1\" data-orig-size=\"1180,430\" data-comments-opened=\"0\" data-image-title=\"butterfly-mdchart-male-female\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-male-female.png?fit=1024%2C373&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-mdchart-male-female.png?resize=1024%2C373&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200343\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-male-female.png?resize=1024%2C373&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-male-female.png?resize=600%2C219&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-male-female.png?resize=768%2C280&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-male-female.png?w=1180&amp;ssl=1 1180w\" 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;6b01f20ae261c&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b01f20ae261c\" 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=\"179\" data-attachment-id=\"200347\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-mdchart-mrr-necc-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc.png?fit=1777%2C311&amp;ssl=1\" data-orig-size=\"1777,311\" data-comments-opened=\"0\" data-image-title=\"butterfly-mdchart-mrr-necc\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc.png?fit=1024%2C179&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-mdchart-mrr-necc.png?resize=1024%2C179&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200347\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc.png?resize=1024%2C179&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc.png?resize=600%2C105&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc.png?resize=768%2C134&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc.png?resize=1536%2C269&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc.png?w=1777&amp;ssl=1 1777w\" 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;6b01f20ae37ca&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6b01f20ae37ca\" 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=\"177\" data-attachment-id=\"200345\" data-permalink=\"https:\/\/support.questetra.com\/en\/butterfly-mdchart-mrr-necc2-2\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc2.png?fit=1771%2C306&amp;ssl=1\" data-orig-size=\"1771,306\" data-comments-opened=\"0\" data-image-title=\"butterfly-mdchart-mrr-necc2\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc2.png?fit=1024%2C177&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-mdchart-mrr-necc2.png?resize=1024%2C177&#038;ssl=1\" alt=\"\" class=\"has-border-color wp-image-200345\" style=\"border-color:#009900;border-width:3px;border-radius:9px\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc2.png?resize=1024%2C177&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc2.png?resize=600%2C104&amp;ssl=1 600w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc2.png?resize=768%2C133&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc2.png?resize=1536%2C265&amp;ssl=1 1536w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/butterfly-mdchart-mrr-necc2.png?w=1771&amp;ssl=1 1771w\" 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 row width will be Total + Bar + Unit + Bar + Total.<\/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>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=\"xGafZyV7Vf\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-butterfly-svg-2026\/\">Converter: #TSV String to #Butterfly-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 #Butterfly-SVG File\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-butterfly-svg-2026\/embed\/#?secret=uMMPM65SSF#?secret=xGafZyV7Vf\" data-secret=\"xGafZyV7Vf\" 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=\"ysSqpJnNlX\"><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=ALDEI0mYBM#?secret=ysSqpJnNlX\" data-secret=\"ysSqpJnNlX\" 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=\"2XlaUZxGvc\"><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=dOZu3G3cEo#?secret=2XlaUZxGvc\" data-secret=\"2XlaUZxGvc\" 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=\"GPauZPgUt7\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-valueranges-tsv-export-2021\/\">Google Sheets: ValueRanges, Export as TSV<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cGoogle Sheets: ValueRanges, Export as TSV\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/google-sheets-valueranges-tsv-export-2021\/embed\/#?secret=x00MFfEQNw#?secret=GPauZPgUt7\" data-secret=\"GPauZPgUt7\" 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=\"SkyT6TirFo\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-tsv-create-pivot-by-quarter-2026\/\">Date #TSV: Create Pivot by Quarter<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cDate #TSV: Create Pivot by Quarter\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/date-tsv-create-pivot-by-quarter-2026\/embed\/#?secret=w7pThDW3RQ#?secret=SkyT6TirFo\" data-secret=\"SkyT6TirFo\" 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=\"21Luu3s8Gl\"><a href=\"https:\/\/support.questetra.com\/en\/addons\/date-tsv-group-by-quarter-2026\/\">Date #TSV: Group by Quarter<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"\u201cDate #TSV: Group by Quarter\u201d \u2014 Questetra Support\" src=\"https:\/\/support.questetra.com\/en\/addons\/date-tsv-group-by-quarter-2026\/embed\/#?secret=L7RDfWNGi7#?secret=21Luu3s8Gl\" data-secret=\"21Luu3s8Gl\" 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 Markdown-embeddable stacked butterfly chart. 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":200365,"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-200364","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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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-mdchart-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 Markdown-embeddable stacked butterfly chart. 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-Q7G","jetpack-related-posts":[{"id":200316,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-butterfly-svg-2026\/","url_meta":{"origin":200364,"position":0},"title":"Converter: #TSV String to #Butterfly-SVG File","author":"IMAMURA, Genichi","date":"2026-11-19","format":false,"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.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: #TSV String to #Butterfly-SVG File","src":"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&resize=350%2C200","width":350,"height":200,"srcset":"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&resize=350%2C200 1x, 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&resize=525%2C300 1.5x, 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&resize=700%2C400 2x, 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&resize=1050%2C600 3x"},"classes":[]},{"id":200348,"url":"https:\/\/support.questetra.com\/ja\/addons\/converter-tsv-string-to-butterfly-mdchart-2026\/","url_meta":{"origin":200364,"position":1},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf: #TSV \u6587\u5b57\u5217 to #Butterfly-MdChart \u6587\u5b57\u5217","author":"IMAMURA, Genichi","date":"2026-11-19","format":false,"excerpt":"\u6570\u5024TSV\u6587\u5b57\u5217\u3092\u300cMarkdown\u306b\u57cb\u3081\u8fbc\u307f\u53ef\u80fd\u306a\u7a4d\u307f\u4e0a\u3052\u30d0\u30bf\u30d5\u30e9\u30a4\u30c1\u30e3\u30fc\u30c8\uff08\u5de6\u53f3\u5bfe\u79f0\u68d2\u30b0\u30e9\u30d5\uff09\u300d\uff08ButterflyMdChart\u6587\u5b57\u5217\uff09\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u884c\u5185\u3067\u975e\u6570\u5024\u6587\u5b57\u5217\u3068\u306a\u308b\u4e2d\u592e\u306e\u5217\u304c\u81ea\u52d5\u7684\u306b\u300c\u5e74\u6708\u300d\u3084\u300c\u56db\u534a\u671f\u300d\u306a\u3069\u306e\u96c6\u8a08\u5358\u4f4d\u30e9\u30d9\u30eb\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u3001\u305d\u306e\u5de6\u5074\u306e\u5217\u306f\u5de6\u65b9\u5411\u3078\u3001\u53f3\u5074\u306e\u5217\u306f\u53f3\u65b9\u5411\u3078\u3068\u7a4d\u307f\u4e0a\u3052\u63cf\u753b\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u30b3\u30f3\u30d0\u30fc\u30bf: #TSV \u6587\u5b57\u5217 to #Butterfly-MdChart \u6587\u5b57\u5217","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-2026-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-2026-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-2026-ja.png?fit=1200%2C628&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-2026-ja.png?fit=1200%2C628&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-mdchart-2026-ja.png?fit=1200%2C628&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":200296,"url":"https:\/\/support.questetra.com\/ja\/addons\/converter-tsv-string-to-butterfly-svg-2026\/","url_meta":{"origin":200364,"position":2},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf: #TSV \u6587\u5b57\u5217 to #Butterfly-SVG \u30d5\u30a1\u30a4\u30eb","author":"IMAMURA, Genichi","date":"2026-11-19","format":false,"excerpt":"\u6570\u5024TSV\u6587\u5b57\u5217\u3092\u300c\u7a4d\u307f\u4e0a\u3052\u30d0\u30bf\u30d5\u30e9\u30a4\u30c1\u30e3\u30fc\u30c8\uff08\u5de6\u53f3\u5bfe\u79f0\u68d2\u30b0\u30e9\u30d5\uff09\u306eSVG\u30d5\u30a1\u30a4\u30eb\u300d\u306b\u5909\u63db\u3057\u307e\u3059\u3002\u30c7\u30fc\u30bf\u884c\u5185\u3067\u975e\u6570\u5024\u6587\u5b57\u5217\u3068\u306a\u308b\u4e2d\u592e\u306e\u5217\u304c\u81ea\u52d5\u7684\u306b\u300c\u5e74\u6708\u300d\u3084\u300c\u56db\u534a\u671f\u300d\u306a\u3069\u306e\u96c6\u8a08\u5358\u4f4d\u30e9\u30d9\u30eb\u3068\u3057\u3066\u8a8d\u8b58\u3055\u308c\u3001\u305d\u306e\u5de6\u5074\u306e\u5217\u306f\u5de6\u65b9\u5411\u3078\u3001\u53f3\u5074\u306e\u5217\u306f\u53f3\u65b9\u5411\u3078\u3068\u7a4d\u307f\u4e0a\u3052\u63cf\u753b\u3055\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u30b3\u30f3\u30d0\u30fc\u30bf: #TSV \u6587\u5b57\u5217 to #Butterfly-SVG \u30d5\u30a1\u30a4\u30eb","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-ja.png?fit=1200%2C628&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-ja.png?fit=1200%2C628&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/11\/converter-tsv-string-to-butterfly-svg-2026-ja.png?fit=1200%2C628&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":187352,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-markdown-chart-string-2026\/","url_meta":{"origin":200364,"position":3},"title":"Converter: #TSV String to #MdChart String","author":"IMAMURA, Genichi","date":"2026-06-17","format":false,"excerpt":"Converts a numeric TSV string into a Markdown-embeddable stacked bar chart (MdChart). The first TSV column is used as the aggregation unit, such as \"YYYYMM\", and the first row as data series, such as \"Sales Representative\" or \"Client\".","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: #TSV String to #MdChart String","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-en.png?fit=1200%2C628&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-en.png?fit=1200%2C628&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-en.png?fit=1200%2C628&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-en.png?fit=1200%2C628&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-en.png?fit=1200%2C628&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":84857,"url":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-table\/","url_meta":{"origin":200364,"position":4},"title":"Converter: TSV-String to Table","author":"IMAMURA, Genichi","date":"2020-02-28","format":false,"excerpt":"Converts TSV String to Table-type data. The string value of all cells in the TSV string is copied over Table-type data B. If there is an inconsistency in the Table column design, an error may occur.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Converter: TSV-String to Table","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-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\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/02\/Converter-TSV-String-to-Table-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":187360,"url":"https:\/\/support.questetra.com\/ja\/addons\/converter-tsv-string-to-markdown-chart-string-2026\/","url_meta":{"origin":200364,"position":5},"title":"\u30b3\u30f3\u30d0\u30fc\u30bf: #TSV\u6587\u5b57\u5217 to #MdChart\u6587\u5b57\u5217","author":"IMAMURA, Genichi","date":"2026-06-17","format":false,"excerpt":"\u6570\u5024TSV\u6587\u5b57\u5217\u3092\u300cMarkdown\u306b\u57cb\u3081\u8fbc\u307f\u53ef\u80fd\u306a\u7a4d\u307f\u4e0a\u3052\u68d2\u30b0\u30e9\u30d5\u300d\uff08MdChart\u6587\u5b57\u5217\uff09\u306b\u5909\u63db\u3057\u307e\u3059\u3002TSV\u306e1\u5217\u76ee\u306f\u300c\u5e74\u6708\u300d\u3084\u300c\u56db\u534a\u671f\u300d\u306a\u3069\u306e\u96c6\u8a08\u5358\u4f4d\u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002\u307e\u305f\u3001TSV\u306e1\u884c\u76ee\u306f\u300c\u55b6\u696d\u62c5\u5f53\u300d\u3084\u300c\u53d6\u5f15\u5148\u300d\u3068\u3044\u3063\u305f\u30c7\u30fc\u30bf\u7cfb\u5217\u540d\u3068\u3057\u3066\u6271\u308f\u308c\u307e\u3059\u3002","rel":"","context":"In &quot;\u30a2\u30c9\u30aa\u30f3&quot;","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-ja.png?fit=1200%2C628&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-ja.png?fit=1200%2C628&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-ja.png?fit=1200%2C628&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2026\/06\/converter-tsv-string-to-markdown-chart-string-2026-ja.png?fit=1200%2C628&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-mdchart-2026-en.png?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/200364","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=200364"}],"version-history":[{"count":12,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/200364\/revisions"}],"predecessor-version":[{"id":200378,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/200364\/revisions\/200378"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/200365"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=200364"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=200364"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=200364"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=200364"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}