{"id":171827,"date":"2025-04-03T09:39:47","date_gmt":"2025-04-03T00:39:47","guid":{"rendered":"https:\/\/support.questetra.com\/?p=171827"},"modified":"2025-04-07T09:14:14","modified_gmt":"2025-04-07T00:14:14","slug":"converter-tsv-string-to-markdown-string-2025","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/converter-tsv-string-to-markdown-string-2025\/","title":{"rendered":"\u30b3\u30f3\u30d0\u30fc\u30bf: #TSV\u6587\u5b57\u5217 to #Markdown\u6587\u5b57\u5217"},"content":{"rendered":"\n

\u30b3\u30f3\u30d0\u30fc\u30bf: #TSV\u6587\u5b57\u5217 to #Markdown\u6587\u5b57\u5217<\/strong><\/h4>\n\n\n\n

translate<\/span> Converter: #TSV String to #Markdown String<\/a><\/p>\n\n\n\n

TSV\u6587\u5b57\u5217\u3092Markdown\u6587\u5b57\u5217\u306b\u5909\u63db\u3057\u307e\u3059\u3002TSV\u306e1\u884c\u76ee\u306f\u30d8\u30c3\u30c0\u884c\uff08TH: Table Header\uff09\u3068\u307f\u306a\u3055\u308c\u30012\u884c\u76ee\u4ee5\u964d\u304c\u30c7\u30fc\u30bf\u884c\uff08TD: Table Data\uff09\u3068\u307f\u306a\u3055\u308c\u307e\u3059\u3002\u53f3\u5bc4\u305b\u3084\u30bb\u30f3\u30bf\u30ea\u30f3\u30b0\u3068\u3044\u3063\u305f\u5217\u306e\u8868\u793a\u8a2d\u5b9a\u3082\u53ef\u80fd\u3067\u3059\u3002<\/p>\n\n\n\n

\"Auto<\/figure>\n\n\n\n
\n
Configs for this Auto Step<\/summary>
\n
\r\n
StrConfA<\/dt>
A: TSV\u6587\u5b57\u5217\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044 *<\/span>#{EL}<\/sup><\/span><\/dd>\r\n
StrConfB<\/dt>
B: \u5217\u306e\u53f3\u5bc4\u305b\u5de6\u5bc4\u305b\u8a2d\u5b9a\u3092\u30bb\u30c3\u30c8\u3057\u3066\u304f\u3060\u3055\u3044\uff08\u4f8b: “R,L,R,C,C”\uff09 *<\/span>#{EL}<\/sup><\/span><\/dd>\r\n
SelectConfC<\/dt>
C: \u5909\u63db\u3055\u308c\u305fMarkdown\u6587\u5b57\u5217\u3092\u683c\u7d0d\u3059\u308b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\r\n<\/div>\r\n
SelectConfD1<\/dt>
D1: TSV\u884c\u6570\u3092\u683c\u7d0d\u3059\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\r\n
SelectConfD2<\/dt>
D2: \u672b\u5c3e\u6539\u884c\u30b3\u30fc\u30c9\u3092\u7121\u8996\u3057\u305f\u884c\u6570\u304c\u683c\u7d0d\u3055\u308c\u308b\u6570\u5024\u578b\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044 (\u66f4\u65b0)<\/dd>\r\n<\/div>\r\n\r\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\/ja\/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- The 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- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u304c\u7a7a\u6587\u5b57\u5217\u306e\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002\n- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u304c1\u884c\u306e\u5834\u5408\u3001\u30a8\u30e9\u30fc\u3068\u306a\u308a\u307e\u3059\u3002\n- \u5165\u529bTSV\u30c6\u30ad\u30b9\u30c8\u306b\u7a7a\u884c\u304c\u3042\u308b\u5834\u5408\u3001\u30b9\u30ad\u30c3\u30d7\u3055\u308c\u307e\u3059\u3002\n*\/\n\n<\/code><\/pre><\/div>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n
Download<\/span><\/h3>\n\n\n\n