{"id":126559,"date":"2022-08-26T09:15:49","date_gmt":"2022-08-26T00:15:49","guid":{"rendered":"https:\/\/support.questetra.com\/?p=126559"},"modified":"2022-09-08T08:24:10","modified_gmt":"2022-09-07T23:24:10","slug":"string-extract-values-using-line-begin-matching-2022","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/ja\/addons\/string-extract-values-using-line-begin-matching-2022\/","title":{"rendered":"\u6587\u5b57\u5217\u62bd\u51fa,\u884c\u59cb\u307e\u308a\u6587\u5b57\u5217\u30de\u30c3\u30c1\u30f3\u30b0"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><div class=\"su-box su-box-style-soft\" id=\"\" style=\"border-color:#cc66cc;border-radius:0px;max-width:none\"><div class=\"su-box-title\" style=\"background-color:#ff99ff;color:#000000;border-top-left-radius:0px;border-top-right-radius:0px\">\u6587\u5b57\u5217\u62bd\u51fa,\u884c\u59cb\u307e\u308a\u6587\u5b57\u5217\u30de\u30c3\u30c1\u30f3\u30b0 (String, Extract Values using Line-Begin Matching)<\/div><div class=\"su-box-content su-u-clearfix su-u-trim\" style=\"border-bottom-left-radius:0px;border-bottom-right-radius:0px\"> \u30c6\u30ad\u30b9\u30c8\u3092\uff11\u884c\u6bce\u306b\u89e3\u6790\u3057\u3001\u6307\u5b9a\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u3078\u683c\u7d0d\u3057\u307e\u3059\u3002\u30e1\u30fc\u30eb\u3084\u5b9a\u578b\u6587\u66f8\u306e&#8221;\u884c\u59cb\u307e\u308a\u306e\u6587\u5b57\u5217&#8221;\u3068\u30de\u30c3\u30c1\u30f3\u30b0\u3057\u307e\u3059\u3002\u30de\u30c3\u30c1\u30f3\u30b0\u5f8c\u7d9a\u306e\u6587\u5b57\u5217\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1\" data-anchor=\"configs\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Configs<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n<ul class=\"fa-ul\">\n<li><span class=\"fa-li\"><i class=\"fal fa-caret-square-down fa-lg\"><\/i><\/span> A: \u89e3\u6790\u5bfe\u8c61\u306e\u6587\u5b57\u578b\uff08\u8907\u6570\u884c\uff09\u30c7\u30fc\u30bf\u9805\u76ee\u3092\u9078\u629e\u3057\u3066\u304f\u3060\u3055\u3044<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B: \u884c\u982d\u306e\u30bf\u30a4\u30c8\u30eb\u3068\u683c\u7d0d\u7528\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u8a18\u8f09\u3057\u3066\u304f\u3060\u3055\u3044 eg. Corporate Name:q_corp_name;<span style=\"color:#990000;\"> *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Script (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-js\" data-lang=\"JavaScript\"><code>\/\/ Configuration Format\n\/\/ Format: {index}:{Questetra Data Items Field Name};\n\/\/         eg. {index$1}:{Questetra Data Items Field Name$1};{index$2}:{Questetra Data Items Field Name$2};...\n\/\/         eg. Corporate Name:q_corp_name;Person Name:q_person_name;\n\/\/ index: String (the beginning of a sentence is {index}.\n\/\/ Questetra Data Items Field Name: String eg. q_corp_name\n\/\/ config delimiter: &quot;:&quot; for {index} and {Questetra Data Items Field Name}\n\/\/ configs delimiter: &quot;;&quot; for configs\n\/\/ Target Row Example : Corporate Name:Example Inc\n\/\/\/\/\/\/\/\/ START &quot;main()&quot; \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){\n  \/\/\/\/ == \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 \/ Config Retrieving ==\n  const confObjA   = configs.getObject( &quot;conf_DataIdA&quot; );  \/\/required\n  const strConfigs = configs.get( &quot;conf_DataIdB&quot; );        \/\/required\n  \/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 \/ Data Retrieving ==\n  const mailbody = engine.findData(confObjA);\n\n  engine.log(&quot;mailbody:&quot; + mailbody);\n  engine.log(&quot;strConfigs:&quot; + strConfigs);\n\n  \/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\n  const configsSep = &quot;;&quot;;\n  const configSep = &quot;:&quot;;\n  const sep = &quot;:&quot;;\n  const textEndSepForMultipleRow = &quot;---------------&quot;;\n\n  const arrConfigs = strConfigs.split(configsSep);\n  let line = new Array();\n  let pos = &quot;&quot;;\n  let dat = &quot;&quot;;\n  let isParsingMultipeRow = false;\n  let multipleRowText = &quot;&quot;;\n  let fieldNameForMultipleRowText = &quot;&quot;;\n  line = mailbody.split(&quot;\\n&quot;);\n  for(var i=0; i &lt; line.length; i=i+1){\n    pos = line[i].indexOf(sep);\n    dat = line[i].slice(pos+sep.length);\n    for (var j=0; j &lt; arrConfigs.length; j++){\n      let arrConfig = arrConfigs[j].split(configSep);\n      if (line[i].slice(0,pos) === arrConfig[0]){\n        let results = checkObjectDataType(arrConfig[1]);\n        if (results[0]){ \/\/ Valid DataType\n          if (results[1] === &quot;STRING_TEXTAREA&quot;){\n            engine.log(&quot;this row is STRING_TEXTAREA: &quot; + dat);\n            isParsingMultipeRow = true;\n            fieldNameForMultipleRowText = arrConfig[1];\n          }else{\n            setDataToItem(dat.replace(\/^ \/,&quot;&quot;) , arrConfig[1] , results[1]);\n          }\n        }else{ \/\/ Invalid DataType\n          engine.log(&quot;FileName: &quot; + arrConfig[1] + &quot;is not target DataType.&quot;);\n        }\n      }\n    }\n    if (isParsingMultipeRow){ \/\/ Multiple Text parsing\n      if (line[i] === textEndSepForMultipleRow){\n        engine.setDataByVarName(fieldNameForMultipleRowText , multipleRowText);\n        isParsingMultipeRow = false;\n        multipleRowText = &quot;&quot;;\n        fieldNameForMultipleRowText = &quot;&quot;;\n      }else{\n        multipleRowText += dat.replace(\/^ \/,&quot;&quot;) + &quot;\\n&quot;;\n      }\n    }\n  }\n} \/\/----- End Of main()\n\/* checkObjectDataType(fieldName)\n   Check item&#39;s field name for valid data types. Get check result and data type name.\n   param: &quot;fieldName&quot;\n   return: Array [0]: check result(boolean) [1]: item&#39;s DataType(String)\n*\/\nfunction checkObjectDataType(fieldName){\n  const defTypes = [&quot;STRING_TEXTFIELD&quot;,&quot;STRING_TEXTAREA&quot;,&quot;DECIMAL&quot;,&quot;DATE_Y&quot;,&quot;DATE_YM&quot;,&quot;DATE_MD&quot;,&quot;DATE_YMD&quot;,&quot;DATETIME&quot;,&quot;SELECT_SINGLE&quot;,&quot;SELECT_CHECKBOX&quot;,&quot;QUSER&quot;];\n  let def = engine.findDataDefinitionByVarName( fieldName );\n  let results = [false , &quot;&quot;];\n  for (let i=0; i &lt; defTypes.length; i++){\n    if (def.matchDataType(defTypes[i])){\n      results[0] = true;\n      results[1] = defTypes[i];\n    }\n  }\n  return results;\n} \/\/----- End Of convertObjectForTargetDataType()\n\/*\n  setDataToItem(value,fieldName,dataType)\n  Set value to data item of &quot;fieldName&quot;.\n  param1: value\n  param2: fieldName: data item&#39;s field name\n  param3: dataType : data item&#39;s data type name\n*\/\nfunction setDataToItem(value,fieldName,dataType){\n  if (value === null){ return; }\n  const DATE_TYPES = [&quot;DATE_Y&quot;,&quot;DATE_YM&quot;,&quot;DATE_MD&quot;,&quot;DATE_YMD&quot;];\n  engine.log(&quot;datatye: &quot; + dataType);\n  if (dataType === &quot;SELECT_SINGLE&quot;){\n    engine.setDataByVarName( fieldName,[value]);\n    return;\n  }\n  if (dataType === &quot;SELECT_CHECKBOX&quot;){\n    const arry = value.split(&quot;,&quot;);\n    engine.setDataByVarName( fieldName,arry);\n    return;\n  }\n  if (dataType === &quot;QUSER&quot;){\n    const quser = quserDao.findByEmail( value );\n    if (quser === null){\n      engine.log( fieldName + &quot; Not Set. email&quot; + value + &quot; is not exist.&quot;);\n    }else{\n      engine.setDataByVarName( fieldName,quser);\n    }\n    return;\n  }\n  if (DATE_TYPES.indexOf(dataType) !== -1){\n    const date = new Date(value);\n    engine.setDataByVarName( fieldName , new java.sql.Date(date.getTime()));\n    return;\n  }\n  if (dataType === &quot;DATETIME&quot;){\n    const date = new Date(value);\n    engine.setDataByVarName( fieldName , new java.sql.Timestamp(date.getTime()));\n    return;\n  }\n  if (dataType === &quot;DECIMAL&quot;){\n    if (value === null){ return; }\n    engine.setDataByVarName( fieldName , new java.math.BigDecimal(value));\n    return;\n  }\n  engine.setDataByVarName( fieldName,value);\n} \/\/----- End Of setDataToItem()<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<figure class=\"wp-block-image alignright\"><a href=\"#\"><img decoding=\"async\" src=\"data:image;base64,\n  iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAyZJREFUWEfF\n  l01IFGEYx3+TZmmEuUWIFQSJBGaiFAgVlh8HO+7JshTzsGuIlGQhpIgQokSFH7mCWVDZRQqtDga6\n  gnSJNS27RB0M1MJKD7GtWNvEu+vozrizO2PJ7nHnef7\/\/\/u8z9crEeGfZJi\/kzhkrEicQCYDib1A\n  wpL\/PDKTSIwh40TiMTZ+GsEOL+AuiSxyBbADm42AAguAgxiaKOVLKJ\/QAhzYkbgObDFIrDVzI3MJ\n  Ow49f30BndwGytdIrHXrwMb5YFjBBTjoQeLUfyL3w8g8ws5pLeZqASZPvnXjVlqOtDDyeYTu993h\n  NK+KhFqA\/847wqEo3wV5b34v+bvzmXZPU\/Gygr7JvtDuMuWBObEiwJ\/tH40mXCC5hB9m1jOLx+vB\n  OeOkdLhUT4ibGJKV6lgR0MlN4ILR0wu7tiNtlO0vY3OUujq9speHHx5SMlyiB3cLGxfFR78A0WTg\n  u4k6Xwa+d\/weRclFRG+IVpF5fnu46rrKjbc3gokQfWK7aFZ+AQ7OIHHfzOkV24I9BXRld5EUl7Ts\n  LiMzOD2I9YWVH79+BIeVOYudB0oE7gDn1iLgcvplajJq2BazTeXu+uoi51mOvgDoxkaZEoHXSGSY\n  FXDt8DVyd+XS\/6mf6vRqlYjFP4s0jTdR56rTi8AYdjKVCMwFDBZDOgR51cEqXwJOzE3wZPIJqQmp\n  pMSnkGZJ82GMfRsj+2m2XhTmsWFRBMiGWJeMAsmV8qt5VeNrRIX7Cmk\/2o5lk4UF7wINow00jjcG\n  h7chmRYQilxhCbQRyZj3PC+sAENXYIRcYRo4OeDrkDPuGYqdxQzNDGlFBFyBg7BJaIZcMGXtzKIn\n  t4fE2ETqR+tpftOsFiCjSsKQZWiWXGFqONRA5YFKWt+1Uuuq1UZAVYa6jWit5IJNzIv4mHim3FOr\n  c0DTiIK24n8hD1NVmlbsnweqYbSO5IJNM4zEX5pxPGodJXNHpu8gYswqdW6mX+jY6oxjYR2wkIgh\n  03Gsg9io2P9JLlYznYVEkWtyJTMZkTArmYIW0aV0fSJhci1fiUQEHyaKiIg+zQIzLGKPU5Npbtb8\n  L0xUWjBfNCvrAAAAAElFTkSuQmCC\n\" alt=\"\"\/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-cloud-download-alt\"><\/i> Download<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li><a href=\"https:\/\/drive.google.com\/file\/d\/1_Q3LoiYaXwPmSCH_9nCMAKmCOBPbGqnN\/view?usp=drivesdk\" target=\"_blank\" rel=\"noreferrer noopener\">string-extract-values-using-line-begin-matching-2022.xml<\/a><\/li><\/ul>\n\n\n\n<p class=\"has-text-align-right has-small-font-size wp-block-paragraph\">2022-08-11 (C) Questetra, Inc. (MIT License)<br><a href=\"https:\/\/support.questetra.com\/ja\/addons\/string-extract-values-using-line-begin-matching-2022\/\">https:\/\/support.questetra.com\/ja\/addons\/string-extract-values-using-line-begin-matching-2022\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> Addon\u30d5\u30a1\u30a4\u30eb\u306e\u30a4\u30f3\u30dd\u30fc\u30c8\u306f <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> \u3067\u306e\u307f\u3054\u5229\u7528\u3044\u305f\u3060\u3051\u307e\u3059<br>\u81ea\u7531\u6539\u5909\u53ef\u80fd\u306a JavaScript (ECMAScript) \u30b3\u30fc\u30c9\u3067\u3059\u3002\u3044\u304b\u306a\u308b\u4fdd\u8a3c\u3082\u3042\u308a\u307e\u305b\u3093\u3002<\/p>\n\n\n<div class=\"su-divider su-divider-style-dashed\" style=\"margin:30px 0;border-width:8px;border-color:#009900\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-lightbulb-exclamation\"><\/i> Notes<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u8a2d\u5b9a\u9805\u76ee \u201dB: \u884c\u982d\u306e\u30bf\u30a4\u30c8\u30eb\u3068\u683c\u7d0d\u7528\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3092\u8a18\u8f09\u3057\u3066\u304f\u3060\u3055\u3044\u201d<ul><li>\u30d5\u30a9\u30fc\u30de\u30c3\u30c8:\u3000<em>{\u6587\u982d\u691c\u7d22\u6587\u5b57\u5217}:{\u30d5\u30a3\u30fc\u30eb\u30c9\u540d};{\u6587\u982d\u691c\u7d22\u6587\u5b57\u5217}:{\u30d5\u30a3\u30fc\u30eb\u30c9\u540d};\u2026<\/em><ul><li>\u201d\u6587\u982d\u691c\u7d22\u6587\u5b57\u5217\u201d\u3068\u201d\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u201d\u306e\u533a\u5207\u308a\u3000\u201d:\u201d(\u534a\u89d2\u30b3\u30ed\u30f3\uff09<\/li><li>\u300c\u201d\u6587\u982d\u691c\u7d22\u6587\u5b57\u5217\u201d\/\u201d\u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u201d\u300d\u8a2d\u5b9a\u533a\u5207\u308a \u201c;\u201d\uff08\u534a\u89d2\u30bb\u30df\u30b3\u30ed\u30f3\uff09<\/li><\/ul><\/li><\/ul><ul><li>\u683c\u7d0d\u3055\u308c\u308b\u30c7\u30fc\u30bf\u9805\u76ee\u306e\u6ce8\u610f\u70b9<ul><li>\u30e6\u30fc\u30b6\u578b\u30c7\u30fc\u30bf\u9805\u76ee<ul><li>\u30c7\u30fc\u30bf\u306e\u5f62\u5f0f\uff1a\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9<\/li><\/ul><\/li><li>\u65e5\u4ed8\u578b\/\u65e5\u6642\u578b\u30c7\u30fc\u30bf\u9805\u76ee<ul><li>\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\uff1a<em>YYYY\/MM\/DD HH:mm GMT[+-][0-99]<\/em><\/li><\/ul><\/li><li>\u9078\u629e\u80a2\u578b\u30c7\u30fc\u30bf\u9805\u76ee<ul><li>\u30c7\u30fc\u30bf\u306e\u5185\u5bb9\uff1a\u9078\u629e\u80a2 ID<\/li><\/ul><\/li><li>\u6587\u5b57\u5217\u578b\uff08\u8907\u6570\u884c\uff09\u30c7\u30fc\u30bf\u9805\u76ee<ul><li>\u30c7\u30fc\u30bf\u306e\u5185\u5bb9\uff1a\u30c7\u30fc\u30bf\u306e\u6700\u7d42\u884c\u306b\u201d<code>---------------<\/code>\u201d\u306e\u6587\u5b57\u5217\u3092\u8a18\u8f09<\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><li>\u89e3\u6790\u5bfe\u8c61\u306e\u30c6\u30ad\u30b9\u30c8\u306e\u6ce8\u610f\u70b9<ul><li>\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\uff1a\u3000<em>{\u6587\u982d\u691c\u7d22\u6587\u5b57\u5217:{\u683c\u7d0d\u3055\u308c\u308b\u30c7\u30fc\u30bf}<\/em><ul><li>&#8220;\u6587\u982d\u691c\u7d22\u6587\u5b57\u5217&#8221;\u3068\u201d{\u683c\u7d0d\u3055\u308c\u308b\u30c7\u30fc\u30bf}\u201d\u306e\u533a\u5207\u308a \u201d:\u201d(\u534a\u89d2\u30b3\u30ed\u30f3\uff09<\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-images\"><\/i> Capture<\/h3>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-attachment-id=\"126702\" data-permalink=\"https:\/\/support.questetra.com\/ja\/addons\/string-extract-values-using-line-begin-matching-2022\/attachment\/lead-management-process-for-hubspot-mail-20220817-img1-1\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?fit=1198%2C674&amp;ssl=1\" data-orig-size=\"1198,674\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"lead-management-process-for-hubspot-mail-20220817-img1-1\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?fit=560%2C315&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?resize=1024%2C576&#038;ssl=1\" alt=\"\" class=\"wp-image-126702\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?resize=768%2C432&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/lead-management-process-for-hubspot-mail-20220817-img1-1.png?w=1198&amp;ssl=1 1198w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" data-attachment-id=\"126563\" data-permalink=\"https:\/\/support.questetra.com\/ja\/addons\/string-extract-values-using-line-begin-matching-2022\/attachment\/parse-text-and-set-data-items-2022-img1\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?fit=1198%2C674&amp;ssl=1\" data-orig-size=\"1198,674\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"parse-text-and-set-data-items-2022-img1\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?fit=560%2C315&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?fit=1024%2C576&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?resize=1024%2C576&#038;ssl=1\" alt=\"\" class=\"wp-image-126563\" srcset=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?resize=1024%2C576&amp;ssl=1 1024w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?resize=560%2C315&amp;ssl=1 560w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?resize=768%2C432&amp;ssl=1 768w, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1.png?w=1198&amp;ssl=1 1198w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-book\"><\/i> Appendix<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>\u53d6\u8fbc\u30c6\u30ad\u30b9\u30c8\u4f8b<\/li><\/ul>\n\n\n<div class=\"su-spoiler su-spoiler-style-modern-light su-spoiler-icon-plus-square-1 su-spoiler-closed\" data-anchor=\"script\" data-scroll-offset=\"0\" data-anchor-in-url=\"no\"><div class=\"su-spoiler-title\" tabindex=\"0\" role=\"button\"><span class=\"su-spoiler-icon\"><\/span>Example Text (click to open)<\/div><div class=\"su-spoiler-content su-u-clearfix su-u-trim\">\n\n\n\n<div class=\"hcb_wrap\"><pre class=\"prism line-numbers lang-plain\"><code>Hubspot \u3088\u308a\u30a4\u30f3\u30b5\u30a4\u30c9\u30bb\u30fc\u30eb\u30b9 \u5bfe\u5fdc\u30d5\u30e9\u30b0\u306b\u9069\u5408\u3057\u305f\u30e6\u30fc\u30b6\u30fc\u306e\u60c5\u5831\u304c\u9001\u4fe1\u3055\u308c\u307e\u3057\u305f\u3002\n\n\u30e1\u30fc\u30eb\u30a2\u30c9\u30ec\u30b9: taro.yamada@example.com\n\n\u4f01\u696d\u540d:\u682a\u5f0f\u4f1a\u793e\u30a8\u30b0\u30b6\u30f3\u30d7\u30eb\n\n\u62c5\u5f53\u8005\u540d: \u5c71\u7530 \u592a\u90ce\n\u96fb\u8a71\u756a\u53f7: 075-1234-5689\n\u5951\u7d04\u7a2e\u5225:paid\n\n\u5951\u7d04\u30b5\u30fc\u30d3\u30b9:service1,service2\n\n\u55b6\u696d\u62c5\u5f53\u8005:satoh@example2.com\n\u5951\u7d04\u958b\u59cb\u65e5:2021\/04\/16 13:44 GMT+9\n\nWeb\u30b5\u30a4\u30c8\u8a2a\u554f\u65e5\u6642:2022\/08\/16 15:59 GMT+9\n\n\u9867\u5ba2\u30e1\u30c3\u30bb\u30fc\u30b8:\u696d\u52d9\u5229\u7528\u7bc4\u56f2\u306e\u62e1\u5927\u3092\u691c\u8a0e\u3057\u3066\u3044\u307e\u3059\u3002\n\u30c8\u30e9\u30a4\u30a2\u30eb\u57fa\u76e4\u3092\u5229\u7528\u3057\u3066\u3001\u30a2\u30d7\u30ea\u306e\u8a2d\u8a08\u3092\u884c\u3044\u307e\u3059\u3002\nHubSpot \u3068\u306e\u9023\u643a\u306b\u3064\u3044\u3066\u63d0\u6848\u3092\u304a\u9858\u3044\u81f4\u3057\u307e\u3059\u3002\n---------------\n\n\u30b3\u30f3\u30bf\u30af\u30c8ID: 12345678\n\u30e6\u30fc\u30b6\u30b9\u30b3\u30a2: 23<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<h3 class=\"wp-block-heading\"><i class=\"fal fa-balance-scale\"><\/i> See also<\/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=\"cgbnJhz3ow\"><a href=\"https:\/\/support.questetra.com\/ja\/templates\/lead-management-process-for-hubspot-mail-20220817\/\">\u30ea\u30fc\u30c9\u7ba1\u7406\u30d7\u30ed\u30bb\u30b9,HubSpot\u901a\u77e5\u30e1\u30fc\u30eb\u81ea\u52d5\u53d6\u8fbc<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;\u30ea\u30fc\u30c9\u7ba1\u7406\u30d7\u30ed\u30bb\u30b9,HubSpot\u901a\u77e5\u30e1\u30fc\u30eb\u81ea\u52d5\u53d6\u8fbc&#8221; &#8212; Questetra Support\" src=\"https:\/\/support.questetra.com\/ja\/templates\/lead-management-process-for-hubspot-mail-20220817\/embed\/#?secret=BeVruSvkyp#?secret=cgbnJhz3ow\" data-secret=\"cgbnJhz3ow\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>\u30c6\u30ad\u30b9\u30c8\u3092\uff11\u884c\u6bce\u306b\u89e3\u6790\u3057\u3001\u6307\u5b9a\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u3078\u683c\u7d0d\u3057\u307e\u3059\u3002\u30e1\u30fc\u30eb\u3084\u5b9a\u578b\u6587\u66f8\u306e\u201d\u884c\u59cb\u307e\u308a\u306e\u6587\u5b57\u5217\u201d\u3068\u30de\u30c3\u30c1\u30f3\u30b0\u3057\u307e\u3059\u3002\u30de\u30c3\u30c1\u30f3\u30b0\u5f8c\u7d9a\u306e\u6587\u5b57\u5217\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002<\/p>\n","protected":false},"author":8,"featured_media":126743,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_crdt_document":"","_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","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},"categories":[169],"tags":[447],"class_list":["post-126559","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-addons","tag-regexp"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=1200%2C630&ssl=1","uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=1200%2C630&ssl=1",1200,630,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=600%2C315&ssl=1",600,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=768%2C403&ssl=1",768,403,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=1024%2C538&ssl=1",1024,538,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=1200%2C630&ssl=1",1200,630,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=1200%2C630&ssl=1",1200,630,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=1200%2C630&ssl=1",1200,630,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=900%2C630&ssl=1",900,630,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=1200%2C630&ssl=1",1200,630,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=600%2C630&ssl=1",600,630,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=800%2C630&ssl=1",800,630,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1.png?fit=1200%2C630&ssl=1",1200,630,true]},"uagb_author_info":{"display_name":"furuzo","author_link":"https:\/\/support.questetra.com\/ja\/author\/furuzo\/"},"uagb_comment_info":1,"uagb_excerpt":"\u30c6\u30ad\u30b9\u30c8\u3092\uff11\u884c\u6bce\u306b\u89e3\u6790\u3057\u3001\u6307\u5b9a\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u3078\u683c\u7d0d\u3057\u307e\u3059\u3002\u30e1\u30fc\u30eb\u3084\u5b9a\u578b\u6587\u66f8\u306e\u201d\u884c\u59cb\u307e\u308a\u306e\u6587\u5b57\u5217\u201d\u3068\u30de\u30c3\u30c1\u30f3\u30b0\u3057\u307e&hellip;","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-wVh","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":74361,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-model-xml-extract-definition\/","url_meta":{"origin":126559,"position":0},"title":"Questetra-Model-XML \u30c7\u30fc\u30bf\u5b9a\u7fa9\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-01-18","format":false,"excerpt":"\u696d\u52d9\u30d7\u30ed\u30bb\u30b9\u306e\u5b9a\u7fa9\u6982\u8981\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002QAR \u30a2\u30fc\u30ab\u30a4\u30d6\u5185 Model-XML \u30d5\u30a1\u30a4\u30eb\u306b\u3042\u308b pro\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","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\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/01\/questetra-model-xml-extract-header-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":69586,"url":"https:\/\/support.questetra.com\/ja\/addons\/line-specificreader\/","url_meta":{"origin":126559,"position":1},"title":"\u6307\u5b9a\u884c\u62bd\u51fa","author":"Hirotaka NISHI","date":"2017-07-14","format":false,"excerpt":"\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u9805\u76ee\uff08\u8907\u6570\u884c\u30c6\u30ad\u30b9\u30c8\uff09\u304b\u3089\u3001\u6307\u5b9a\u3057\u305f1\u884c\u3092\u62bd\u51fa\u3057\u3001\u5225\u306e\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u30bb\u30c3\u30c8\u3057\u307e\u3059\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","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\/2017\/07\/line-specific-reader-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/07\/line-specific-reader-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/07\/line-specific-reader-header-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/07\/line-specific-reader-header-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2017\/07\/line-specific-reader-header-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96514,"url":"https:\/\/support.questetra.com\/ja\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":126559,"position":2},"title":"\u5358\u4e00\u884cTSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"\u6307\u5b9aID\u306e\u30bb\u30eb\u5024\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002ID\u306f\u30bc\u30ed\u304b\u3089\u59cb\u307e\u308a\u307e\u3059\u3002\u62bd\u51fa\u3057\u305f\u30bb\u30eb\u6587\u5b57\u5217\u306f\u3001\u6587\u5b57\u5217\u578b\u306e\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","block_context":{"text":"\u30a2\u30c9\u30aa\u30f3","link":"https:\/\/support.questetra.com\/ja\/category\/addons\/"},"img":{"alt_text":"\u5358\u4e00\u884cTSV\u6587\u5b57\u5217, \u30bb\u30eb\u30c7\u30fc\u30bf\u306e\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.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\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":67326,"url":"https:\/\/support.questetra.com\/ja\/addons\/googlesheets-sumnumberscom\/","url_meta":{"origin":126559,"position":3},"title":"Google Sheets \u306e\u30bb\u30eb\u5408\u8a08\uff08\u30ab\u30f3\u30de\u9664\u53bb\u7248\uff09","author":"Hirotaka NISHI","date":"2016-09-13","format":false,"excerpt":"\u6307\u5b9a\u3057\u305f Google Sheets \u306e\u9818\u57df\u306b\u3042\u308b\u6570\u5024\u5408\u8a08\u3092\u6570\u5024\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u683c\u7d0d\u3057\u3001\u901a\u4fe1\u30ed\u30b0\u3092\u6587\u5b57\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","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\/2016\/09\/google-sheets-sum-numbers-comma-removal-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-removal-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-removal-header-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-removal-header-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2016\/09\/google-sheets-sum-numbers-comma-removal-header-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":70970,"url":"https:\/\/support.questetra.com\/ja\/addons\/tsv-filteringbydate\/","url_meta":{"origin":126559,"position":4},"title":"\u65e5\u4ed8\u306b\u3088\u308bTSV\u30d5\u30a3\u30eb\u30bf","author":"Hirotaka NISHI","date":"2018-11-14","format":false,"excerpt":"\u6587\u5b57\u578b\u30c7\u30fc\u30bf\u9805\u76ee\u306b\u683c\u7d0d\u3055\u308c\u305f\u30bf\u30d6\u533a\u5207\u308a\u30c6\u30ad\u30b9\u30c8\uff08TSV\uff09\u306e\u884c\u3092\u3001\u65e5\u4ed8\u306e\u7bc4\u56f2\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u3057\u3066\u4fdd\u5b58\u3057\u307e\u3059\u2026","rel":"","context":"\u30a2\u30c9\u30aa\u30f3","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\/2018\/11\/filter-tsv-by-date-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/filter-tsv-by-date-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/filter-tsv-by-date-header-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/filter-tsv-by-date-header-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/filter-tsv-by-date-header-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":71287,"url":"https:\/\/support.questetra.com\/ja\/developer-blog\/box-webhook\/","url_meta":{"origin":126559,"position":5},"title":"Box Webhook\u3092\u4f7f\u3063\u3066\u30d5\u30a9\u30eb\u30c0\u3078\u306e\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3092\u76e3\u8996\u3059\u308b","author":"Hirotaka NISHI","date":"2018-11-20","format":false,"excerpt":"Box Webhook \u95a2\u9023\u306e\uff13\u3064\u306e\u30a2\u30a4\u30c6\u30e0\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002\uff13\u3064\u306e\u30a2\u30a4\u30c6\u30e0\u3092\u7528\u3044\u3066\u3001\u6307\u5b9a\u30d5\u30a9\u30eb\u30c0\u3078\u306e\u30d5\u2026","rel":"","context":"Questetra Developers Blog","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/ja\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/box-wehbook-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/126559","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/comments?post=126559"}],"version-history":[{"count":22,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/126559\/revisions"}],"predecessor-version":[{"id":126961,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/posts\/126559\/revisions\/126961"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media\/126743"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/media?parent=126559"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/categories?post=126559"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/ja\/wp-json\/wp\/v2\/tags?post=126559"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}