{"id":171818,"date":"2025-04-03T09:31:26","date_gmt":"2025-04-03T00:31:26","guid":{"rendered":"https:\/\/support.questetra.com\/?p=171818"},"modified":"2025-04-07T09:11:17","modified_gmt":"2025-04-07T00:11:17","slug":"converter-tsv-string-to-markdown-string-2025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/converter-tsv-string-to-markdown-string-2025\/","title":{"rendered":"Converter: #TSV String to #Markdown String"},"content":{"rendered":"\n

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

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

Converts a TSV string to a Markdown string. The first line of the TSV is recognized as a header line, and the second and subsequent lines are recognized as data lines. Also supports column settings such as right alignment and center alignment.<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\n
StrConfA<\/dt>
A: Set TSV String *<\/span>#{EL}<\/sup><\/span><\/dd>\n
StrConfB<\/dt>
B: Set Right\/Left alignment for each column (eg: “R,L,R,C,C”) *<\/span>#{EL}<\/sup><\/span><\/dd>\n
SelectConfC<\/dt>
C: Select DATA to store Converted Markdown String (update)<\/dd>\n<\/div>\n
SelectConfD1<\/dt>
D1: Select NUMERIC for Number of TSV Lines (update)<\/dd>\n
SelectConfD2<\/dt>
D2: Select NUMERIC for Number of TSV Lines Trimmed (update)<\/dd>\n<\/div>\n\n<\/dl>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
\n
Script (click to open)<\/summary>
\n
\/\/ Script Example of Business Process Automation\n\/\/ for 'engine type: 3' ("GraalJS standard mode")\n\/\/ cf. 'engine type: 2' ("GraalJS Nashorn compatible mode") (renamed from "GraalJS" at 20230526)\n\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strTsv        = configs.get       ( "StrConfA" );     \/\/ REQUIRED\n  if( strTsv === "" ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A: TSV} is empty \\n" );\n  }\n  const numTsvLines = strTsv.split("\\n").length;\n  if(   numTsvLines < 2 ){\n    throw new Error( "\\n AutomatedTask ConfigError:" +\n                     " Config {A: TSV} requires at least 2 lines (header and data) \\n" );\n  }\n  const numTsvNoLf  = strTsv.replace(\/[\\n]*$\/, "").split("\\n").length;\n                      \/\/ delete Line Feed codes at the end\n\n  \/\/ get TSV as Array-Array (2d Array)\n  const arr2dTsv    = parseAsRectangular( strTsv );\n\nconst strAlignment  = configs.get       ( "StrConfB" )  === "" ?     \/\/ not required\n                      "L" : \/\/ default\n                      configs.get       ( "StrConfB" ) ; \n  let arrAlignment  = strAlignment.split(",");\n\nconst strPocketC    = configs.getObject ( "SelectConfC" );  \/\/ REQUIRED\n\nconst numPocketD1   = configs.getObject ( "SelectConfD1" );  \/\/ not required\nconst numPocketD2   = configs.getObject ( "SelectConfD2" );  \/\/ not required\n\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (nothing)\n\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\nlet strMarkdown = "";\n\n\/\/\/ Get first line (Table Header)\nstrMarkdown += "| ";\nfor ( let i = 0; i < arr2dTsv[0].length; i++ ){\n  strMarkdown += arr2dTsv[0][i];\n  strMarkdown += " | ";\n}\nstrMarkdown += "\\n";\n\n\/\/\/ Get alignment line\nstrMarkdown += "| ";\nfor ( let i = 0; i < arr2dTsv[0].length; i++ ){\n  let strTmp = arrAlignment?.[i] ?? "L"; \/\/ see Optional Chaining and Nullish Coalescing\n  if( strTmp === "L" ){\n    strMarkdown += " :--- | ";\n  }else if( strTmp === "C" ){\n    strMarkdown += " :---:| ";\n  }else if( strTmp === "R" ){\n    strMarkdown += " ---: | ";\n  }\n}\nstrMarkdown += "\\n";\n\n\/\/\/ Get second line onwards\nfor ( let i = 1; i < arr2dTsv.length; i++ ){\n  strMarkdown += "| ";\n  for ( let j = 0; j < arr2dTsv[i].length; j++ ){\n    strMarkdown += arr2dTsv[i][j];\n    strMarkdown += " | ";\n  }\n  strMarkdown += "\\n";\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\n\/\/\/ ref) Retrieving \/ Updating from ScriptTasks\n\/\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n\/\/\/ https:\/\/questetra.zendesk.com\/hc\/en-us\/articles\/360024574771-R2301\n\n\nif ( strPocketC !== null ){ \n  engine.setData( strPocketC, strMarkdown );\n}\n\nif ( numPocketD1 !== null ){ \n  engine.setData( numPocketD1, new java.math.BigDecimal( numTsvLines ) );\n}\nif ( numPocketD2 !== null ){ \n  engine.setData( numPocketD2, new java.math.BigDecimal( numTsvNoLf ) );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/ Parses TSV string as two-dimensional rectangular data matrix and creates a 2D array.\nfunction parseAsRectangular( strTsv ){\n  const arrTsv = strTsv.split("\\n");\n\n  \/\/\/ Get numMinWidth and numMaxWidth (blank lines are excluded)\n  let numMinWidth   = Infinity; \/\/ cf. String-Type Max: 1 million\n  let numMaxWidth   = 0;\n  let numBlanklines = 0;\n  for( let i = 0; i < arrTsv.length; i++ ){\n    if( arrTsv[i] === "" ){ \/\/ Skip blank lines\n      numBlanklines += 1;\n      continue;\n    }\n    let arrCells = arrTsv[i].split("\\t");\n    if( numMinWidth > arrCells.length ){ numMinWidth = arrCells.length; }\n    if( numMaxWidth < arrCells.length ){ numMaxWidth = arrCells.length; }\n  }\n  engine.log( " AutomatedTask TsvDataCheck:" + \n              " MinWidth:" + numMinWidth +\n              " MaxWidth:" + numMaxWidth +\n              " Lines:" + arrTsv.length +\n              " (BlankLines:" + numBlanklines + ")" );\n\n  \/\/\/ Get numMinWidth and numMaxWidth (blank lines are excluded)\n  let arr2dTsv      = [];\n  for( let i = 0; i < arrTsv.length; i++ ){\n    if( arrTsv[i] === "" ){ \/\/ Skip blank lines\n      continue;\n    }\n    let arrTmp = [];\n    let arrCells = arrTsv[i].split("\\t");\n    for( let j = 0; j < numMaxWidth; j++ ){\n      if( j < arrCells.length ){\n        arrTmp[j] = arrCells[j];\n      }else{\n        arrTmp[j] = "";\n      }\n    }\n    arr2dTsv.push( arrTmp );\n  }\n\n  return arr2dTsv;\n}\n\n\n\/*\nNOTES\n- When a process reaches this [Automated Step], the conversion is automatically executed.\n    - TSV text will be converted to Markdown text.\n- The number of lines of the input TSV text can also be extracted at the same time.\n\nNOTES-ja\n- \u3053\u306e\uff3b\u81ea\u52d5\u5de5\u7a0b\uff3d\u306b\u6848\u4ef6\u304c\u5230\u9054\u3059\u308b\u3068\u3001\u300c\u5909\u63db\u51e6\u7406\u300d\u304c\u81ea\u52d5\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002\n    - TSV\u30c6\u30ad\u30b9\u30c8\u304c\u3001Markdown\u30c6\u30ad\u30b9\u30c8\u306b\u5909\u63db\u3055\u308c\u307e\u3059\u3002\n- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306e\u884c\u6570\u3082\u540c\u6642\u306b\u62bd\u51fa\u3067\u304d\u307e\u3059\u3002\n\n\n\u25bcinput TSV example\n-\tCustomer\tQuote Amount\tProposer\tReviewer\n#1\tQatar Airlines\t$12,345,678\tAkira TORIYAMA\tShohei OTANI\n#2\tSingapore Airlines\t$1,234,567\tIchiro SUZUKI\tShohei OTANI\n#4\tANA All Nippon Airways\t$123,456\tTaro ASO\tKakuei TANAKA\n#12\tJapan Airlines\t$123\tTaro ASO\tShinzo ABE\n*\/\n\n\/*\nAPPENDIX\n- If the input TSV text is an empty string, an error occurs.\n- If the input TSV text is a single line, an error occurs.\n- If the input TSV text contains blank lines, they will be skipped.\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n