{"id":126888,"date":"2022-08-30T16:39:30","date_gmt":"2022-08-30T07:39:30","guid":{"rendered":"https:\/\/support.questetra.com\/?p=126888"},"modified":"2022-09-08T08:28:25","modified_gmt":"2022-09-07T23:28:25","slug":"string-extract-values-using-line-begin-matching","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/addons\/string-extract-values-using-line-begin-matching\/","title":{"rendered":"String, Extract Values using Line-Begin Matching"},"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\">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\">Matches the string at the beginning of the line and extracts the following string.<\/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: Select TextArea DATA to Parse<span style=\"color:#990000;\"> *<\/span><\/li>\n<li><span class=\"fa-li\"><i class=\"far fa-pen-square fa-lg\"><\/i><\/span> B:EDIT String for index and fieldName eg.Corporation:q_cname;<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>\/\/ GraalJS Script (engine type: 2)\n\/\/ 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 ==\nconst confObjA = configs.getObject( &quot;conf_DataIdA&quot; ); \/\/required\nconst strConfigs = configs.get( &quot;conf_DataIdB&quot; ); \/\/required\n\/\/\/\/ == \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 \/ Data Retrieving ==\nconst mailbody = engine.findData(confObjA);\n\nengine.log(&quot;mailbody:&quot; + mailbody);\nengine.log(&quot;strConfigs:&quot; + strConfigs);\n\n\/\/\/\/ == \u6f14\u7b97 \/ Calculating ==\nconst configsSep = &quot;;&quot;;\nconst configSep = &quot;:&quot;;\nconst sep = &quot;:&quot;;\nconst textEndSepForMultipleRow = &quot;---------------&quot;;\n\nconst arrConfigs = strConfigs.split(configsSep);\nlet line = new Array();\nlet pos = &quot;&quot;;\nlet dat = &quot;&quot;;\nlet isParsingMultipeRow = false;\nlet multipleRowText = &quot;&quot;;\nlet fieldNameForMultipleRowText = &quot;&quot;;\nline = mailbody.split(&quot;\\n&quot;);\nfor(var i=0; i &lt; line.length; i=i+1){\npos = line[i].indexOf(sep);\ndat = line[i].slice(pos+sep.length);\nfor (var j=0; j &lt; arrConfigs.length; j++){\nlet arrConfig = arrConfigs[j].split(configSep);\nif (line[i].slice(0,pos) === arrConfig[0]){\nlet results = checkObjectDataType(arrConfig[1]);\nif (results[0]){ \/\/ Valid DataType\nif (results[1] === &quot;STRING_TEXTAREA&quot;){\nengine.log(&quot;this row is STRING_TEXTAREA: &quot; + dat);\nisParsingMultipeRow = true;\nfieldNameForMultipleRowText = arrConfig[1];\n}else{\nsetDataToItem(dat.replace(\/^ \/,&quot;&quot;) , arrConfig[1] , results[1]);\n}\n}else{ \/\/ Invalid DataType\nengine.log(&quot;FileName: &quot; + arrConfig[1] + &quot;is not target DataType.&quot;);\n}\n}\n}\nif (isParsingMultipeRow){ \/\/ Multiple Text parsing\nif (line[i] === textEndSepForMultipleRow){\nengine.setDataByVarName(fieldNameForMultipleRowText , multipleRowText);\nisParsingMultipeRow = false;\nmultipleRowText = &quot;&quot;;\nfieldNameForMultipleRowText = &quot;&quot;;\n}else{\nmultipleRowText += dat.replace(\/^ \/,&quot;&quot;) + &quot;\\n&quot;;\n}\n}\n}\n} \/\/----- End Of main()\n\/* checkObjectDataType(fieldName)\nCheck item&#39;s field name for valid data types. Get check result and data type name.\nparam: &quot;fieldName&quot;\nreturn: Array [0]: check result(boolean) [1]: item&#39;s DataType(String)\n*\/\nfunction checkObjectDataType(fieldName){\nconst 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;];\nlet def = engine.findDataDefinitionByVarName( fieldName );\nlet results = [false , &quot;&quot;];\nfor (let i=0; i &lt; defTypes.length; i++){\nif (def.matchDataType(defTypes[i])){\nresults[0] = true;\nresults[1] = defTypes[i];\n}\n}\nreturn results;\n} \/\/----- End Of convertObjectForTargetDataType()\n\/*\nsetDataToItem(value,fieldName,dataType)\nSet value to data item of &quot;fieldName&quot;.\nparam1: value\nparam2: fieldName: data item&#39;s field name\nparam3: dataType : data item&#39;s data type name\n*\/\nfunction setDataToItem(value,fieldName,dataType){\nif (value === null){ return; }\nconst DATE_TYPES = [&quot;DATE_Y&quot;,&quot;DATE_YM&quot;,&quot;DATE_MD&quot;,&quot;DATE_YMD&quot;];\nengine.log(&quot;datatye: &quot; + dataType);\nif (dataType === &quot;SELECT_SINGLE&quot;){\nengine.setDataByVarName( fieldName,[value]);\nreturn;\n}\nif (dataType === &quot;SELECT_CHECKBOX&quot;){\nconst arry = value.split(&quot;,&quot;);\nengine.setDataByVarName( fieldName,arry);\nreturn;\n}\nif (dataType === &quot;QUSER&quot;){\nconst quser = quserDao.findByEmail( value );\nif (quser === null){\nengine.log( fieldName + &quot; Not Set. email&quot; + value + &quot; is not exist.&quot;);\n}else{\nengine.setDataByVarName( fieldName,quser);\n}\nreturn;\n}\nif (DATE_TYPES.indexOf(dataType) !== -1){\nconst date = new Date(value);\nengine.setDataByVarName( fieldName , new java.sql.Date(date.getTime()));\nreturn;\n}\nif (dataType === &quot;DATETIME&quot;){\nconst date = new Date(value);\nengine.setDataByVarName( fieldName , new java.sql.Timestamp(date.getTime()));\nreturn;\n}\nif (dataType === &quot;DECIMAL&quot;){\nif (value === null){ return; }\nengine.setDataByVarName( fieldName , new java.math.BigDecimal(value));\nreturn;\n}\nengine.setDataByVarName( fieldName,value);\n} \/\/----- End Of setDataToItem()\n\n<\/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,\niVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAAAXNSR0IArs4c6QAAAyZJREFUWEfF\nl01IFGEYx3+TZmmEuUWIFQSJBGaiFAgVlh8HO+7JshTzsGuIlGQhpIgQokSFH7mCWVDZRQqtDga6\ngnSJNS27RB0M1MJKD7GtWNvEu+vozrizO2PJ7nHnef7\/\/\/u8z9crEeGfZJi\/kzhkrEicQCYDib1A\nwpL\/PDKTSIwh40TiMTZ+GsEOL+AuiSxyBbADm42AAguAgxiaKOVLKJ\/QAhzYkbgObDFIrDVzI3MJ\nOw49f30BndwGytdIrHXrwMb5YFjBBTjoQeLUfyL3w8g8ws5pLeZqASZPvnXjVlqOtDDyeYTu993h\nNK+KhFqA\/847wqEo3wV5b34v+bvzmXZPU\/Gygr7JvtDuMuWBObEiwJ\/tH40mXCC5hB9m1jOLx+vB\nOeOkdLhUT4ibGJKV6lgR0MlN4ILR0wu7tiNtlO0vY3OUujq9speHHx5SMlyiB3cLGxfFR78A0WTg\nu4k6Xwa+d\/weRclFRG+IVpF5fnu46rrKjbc3gokQfWK7aFZ+AQ7OIHHfzOkV24I9BXRld5EUl7Ts\nLiMzOD2I9YWVH79+BIeVOYudB0oE7gDn1iLgcvplajJq2BazTeXu+uoi51mOvgDoxkaZEoHXSGSY\nFXDt8DVyd+XS\/6mf6vRqlYjFP4s0jTdR56rTi8AYdjKVCMwFDBZDOgR51cEqXwJOzE3wZPIJqQmp\npMSnkGZJ82GMfRsj+2m2XhTmsWFRBMiGWJeMAsmV8qt5VeNrRIX7Cmk\/2o5lk4UF7wINow00jjcG\nh7chmRYQilxhCbQRyZj3PC+sAENXYIRcYRo4OeDrkDPuGYqdxQzNDGlFBFyBg7BJaIZcMGXtzKIn\nt4fE2ETqR+tpftOsFiCjSsKQZWiWXGFqONRA5YFKWt+1Uuuq1UZAVYa6jWit5IJNzIv4mHim3FOr\nc0DTiIK24n8hD1NVmlbsnweqYbSO5IJNM4zEX5pxPGodJXNHpu8gYswqdW6mX+jY6oxjYR2wkIgh\n03Gsg9io2P9JLlYznYVEkWtyJTMZkTArmYIW0aV0fSJhci1fiUQEHyaKiIg+zQIzLGKPU5Npbtb8\nL0xUWjBfNCvrAAAAAElFTkSuQmCC\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\/en\/addons\/string-extract-values-using-line-begin-matching-2022\/\">https:\/\/support.questetra.com\/addons\/string-extract-values-using-line-begin-matching-2022\/<\/a><br><i class=\"fal fa-info-circle\"><\/i> The Addon-import feature is available with <span style=\"color:#4a86e8\" class=\"has-inline-color\"><strong>Professional<\/strong><\/span> edition.<br>Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/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>Setup Item &#8220;B: Provide the title at the beginning of the line and the name of the field for storage&#8221;<ul><li>Format: <em>{text search string}:{field name};{text search string}:{field name};&#8230;<\/em><ul><li>Separator between &#8220;prefix search string&#8221; and &#8220;field name&#8221; &#8220;:&#8221; (half-width colon)<\/li><li>Delimiter of &#8220;&#8221;prefix search string&#8221;\/&#8221;field name&#8221;&#8221; setting &#8220;;&#8221; (half-width semicolon)<\/li><\/ul><\/li><\/ul><ul><li>Notes on Data Items to be Stored<ul><li>User-type Data Item<ul><li>Data Format: Email Address<\/li><\/ul><\/li><li>Datetime-type Data Item<ul><li>Format: <em>YYYY\/MM\/DD HH:mm GMT[+-][0-99]<\/em><\/li><\/ul><\/li><li>Select-type Data Item<ul><li>Data content: Choice ID<\/li><\/ul><\/li><li>String-type (multi-line) Data Item<ul><li>Data contents: &#8220;<code>---------------<\/code>&#8221; string in the last line of data<\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li><li>Notes on text to be parsed<ul><li>Format: <em>{text search string:{data to be stored}<\/em><ul><li>Separator &#8220;:&#8221; (half-width colon) between &#8220;search string at beginning of sentence&#8221; and &#8220;{data to be stored}&#8221;.<\/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\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" 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=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img2-en.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:2px solid #aaaaaa; padding:5px; margin:5px;\"><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" decoding=\"async\" data-attachment-id=\"84005\" data-permalink=\"https:\/\/support.questetra.com\/en\/bpmn-icons\/onedrive-file-upload\/attachment\/setting-service-task-pdf-generation-en\/\" data-orig-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=959%2C833&amp;ssl=1\" data-orig-size=\"959,833\" 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=\"setting-service-task-pdf-generation-en\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/01\/setting-service-task-pdf-generation-en.png?fit=725%2C630&amp;ssl=1\" src=\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/parse-text-and-set-data-items-2022-img1-en.png?ssl=1\" alt=\"\" class=\"wp-image-84005\" style=\"border:2px solid #aaaaaa; padding:5px; margin:5px;\"><\/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>Example of captured text<\/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 has sent you information about a user who has met the Inside Sales Response Flag.\n\nEmail address: taro.yamada@example.com\n\nCompany Name: Example Inc.\n\nContact Person: Taro Yamada\nPhone Number: 075-1234-5689\nContract Type: Paid\n\nContracted services: service1, service2\n\nSales Representative: satoh@example2.com\nContract start date: 2021\/04\/16 13:44 GMT+9\n\nWeb Site Visit Date: 2022\/08\/16 15:59 GMT+9\n\nCustomer Message: We are looking to expand the scope of our business use.\nWe will use the trial infrastructure to design the application.\nPlease provide suggestions for integration with HubSpot.\n---------------\n\nContact ID: 12345678\nUser Score: 23<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Matches the string at the beginning of the line and extracts the following string.<\/p>\n","protected":false},"author":8,"featured_media":126943,"comment_status":"open","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_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":[381],"class_list":["post-126888","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-en.png?fit=1200%2C675&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-en.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-en.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-en.png?fit=560%2C315&ssl=1",560,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-en.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-en.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-en.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-en.png?fit=1200%2C675&ssl=1",1200,675,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-en.png?resize=1200%2C675&ssl=1",1200,675,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-en.png?resize=900%2C675&ssl=1",900,675,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-en.png?resize=1200%2C675&ssl=1",1200,675,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-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-en.png?resize=600%2C675&ssl=1",600,675,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-en.png?resize=800%2C675&ssl=1",800,675,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-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-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\/2022\/08\/eyecatch-parse-text-and-set-data-items-2022-1-en.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-en.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"furuzo","author_link":"https:\/\/support.questetra.com\/en\/author\/furuzo\/"},"uagb_comment_info":0,"uagb_excerpt":"Matches the string at the beginning of the line and extracts the following string.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-x0A","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":74361,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-model-xml-extract-definition\/","url_meta":{"origin":126888,"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 process-data-definition\uff08number, data-type, name\uff09\u3084 Node\uff08\"number\", \"name\", \"nodeType\"\uff09\u306e\u4e00\u90e8\u60c5\u5831\u304c TSV \u3082\u3057\u304f\u306f WordPress-HTML \u3068\u3057\u3066\u62bd\u51fa\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":"","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":96508,"url":"https:\/\/support.questetra.com\/en\/addons\/singleline-tsv-string-extract-cell\/","url_meta":{"origin":126888,"position":1},"title":"Singleline TSV String, Extract Cell","author":"IMAMURA, Genichi","date":"2020-10-16","format":false,"excerpt":"Extracts the cell value of the specified ID. The ID starts from zero. The extracted cell string can be stored not only in the STRING type data but also in the NUMERIC type, DATE type, DATETIME type, SELECT type, USER type, and ORG type data.","rel":"","context":"In &quot;Add-ons&quot;","block_context":{"text":"Add-ons","link":"https:\/\/support.questetra.com\/en\/category\/addons\/"},"img":{"alt_text":"Singleline TSV String, Extract Cell","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Singleline-TSV-String-Extract-Cell-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\/10\/Singleline-TSV-String-Extract-Cell-en.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-en.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-en.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-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":77782,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-addon-xml-extract-configs\/","url_meta":{"origin":126888,"position":2},"title":"Questetra-Addon-XML \u30b3\u30f3\u30d5\u30a3\u30b0\u60c5\u5831\u306e\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-07-18","format":false,"excerpt":"\u81ea\u52d5\u5de5\u7a0b\u306e\u30b3\u30f3\u30d5\u30a3\u30b0\u60c5\u5831\u3092\u62bd\u51fa\u3057\u307e\u3059\u3002Addon-XML \u30d5\u30a1\u30a4\u30eb\uff08Questetra BPMS \u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u7528\uff09\u304c\u30d1\u30fc\u30b9\u3055\u308c\u3001summary\u3001last-modified\u3001config \u306a\u3069\u306e\u60c5\u5831\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08XML\u30a8\u30b9\u30b1\u30fc\u30d7\u306e\u30c7\u30b3\u30fc\u30c9\u306f\u3055\u308c\u307e\u305b\u3093\uff09\u3002\u305d\u306e\u5f8c\u3001Wordpress\u7528\u306e\u30b7\u30f3\u30d7\u30eb\u306aHTML\u30b3\u30fc\u30c9\u304c\u751f\u6210\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":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/questetra-addon-xml-extract-configs-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\/07\/questetra-addon-xml-extract-configs-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/questetra-addon-xml-extract-configs-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/questetra-addon-xml-extract-configs-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/questetra-addon-xml-extract-configs-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":72363,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-addon-xml-generate-digest-html\/","url_meta":{"origin":126888,"position":3},"title":"Questetra-Addon-XML \u30c0\u30a4\u30b8\u30a7\u30b9\u30c8HTML\u306e\u751f\u6210","author":"IMAMURA, Genichi","date":"2018-11-29","format":false,"excerpt":"HTML Code \u3092\u751f\u6210\u3057\u307e\u3059\u3002Addon-XML \u30d5\u30a1\u30a4\u30eb\uff08Questetra BPMS\u7528\uff09\u304c\u30d1\u30fc\u30b9\u3055\u308c\u3001summary\u3001last-modified\u3001config \u306a\u3069\u304c\u30ed\u30b1\u30fc\u30eb\u60c5\u5831\u306b\u5f93\u3063\u3066\u62bd\u51fa\u3055\u308c\u307e\u3059\uff08XML\u30a8\u30b9\u30b1\u30fc\u30d7\u306e\u30c7\u30b3\u30fc\u30c9\u306f\u3055\u308c\u307e\u305b\u3093\uff09\u3002\u305d\u306e\u5f8c\u3001Wordpress\u7528\u306e\u30b7\u30f3\u30d7\u30eb\u306aHTML\u30b3\u30fc\u30c9\u304c\u751f\u6210\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":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/questetra-addon-xml-generate-digest-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\/questetra-addon-xml-generate-digest-header-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/questetra-addon-xml-generate-digest-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\/questetra-addon-xml-generate-digest-header-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2018\/11\/questetra-addon-xml-generate-digest-header-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":96361,"url":"https:\/\/support.questetra.com\/ja\/addons\/google-sheets-sheet-append-tsv\/","url_meta":{"origin":126888,"position":4},"title":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","author":"IMAMURA, Genichi","date":"2020-10-14","format":false,"excerpt":"\u6700\u7d42\u884c\u306bTSV\u30c7\u30fc\u30bf\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002\u5fc5\u8981\u3067\u3042\u308c\u3070\u3001\u65b0\u3057\u3044\u884c\u304c\u633f\u5165\u3055\u308c\u307e\u3059\u3002TSV\u306e\u6307\u5b9a\u5217\u3060\u3051\u304c\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u306a\u304a\u3001\u5217ID\u3092\u6307\u5b9a\u3059\u308b\u969b\u306b\"d\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u65e5\u6642\u30c7\u30fc\u30bf\u3068\u3057\u3066\u3001\"n\"\u3092\u4ed8\u8a18\u3059\u308c\u3070\u6570\u5024\u30c7\u30fc\u30bf\u3068\u3057\u3066\u8ffd\u8a18\u3055\u308c\u307e\u3059\u3002\u5217\u6307\u5b9a\u306e\u4f8b: \"0,2d,5n\"\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":"Google \u30b9\u30d7\u30ec\u30c3\u30c9\u30b7\u30fc\u30c8: Sheet, TSV\u30c7\u30fc\u30bf\u3092\u8ffd\u8a18","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-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\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/10\/Google-Sheets-Sheet-Append-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":82141,"url":"https:\/\/support.questetra.com\/ja\/addons\/questetra-bpms-process-extract-as-tsv\/","url_meta":{"origin":126888,"position":5},"title":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","author":"IMAMURA, Genichi","date":"2019-11-21","format":false,"excerpt":"\u6848\u4ef6\u30c7\u30fc\u30bf\u3092\u4e00\u884c\u306eTSV\u6587\u5b57\u5217\u3068\u3057\u3066\u62bd\u51fa\u3057\u307e\u3059\u3002\u62bd\u51fa\u9805\u76ee\u306f \"0,2,3\" \u306e\u3088\u3046\u306aCSV\u66f8\u5f0f\u3067\u6307\u5b9a\u3057\u307e\u3059\u3002Tab\u30b3\u30fc\u30c9\u3068\u6539\u884c\u30b3\u30fc\u30c9\u306f\u3001\u81ea\u52d5\u7684\u306b\u524a\u9664\u3055\u308c\u307e\u3059\u3002\"\u30d5\u30a1\u30a4\u30eb\u578b\" \u306f\u30d5\u30a1\u30a4\u30eb\u540d\u304c\u3001\"\u9078\u629e\u578b\" \u306f\u9078\u629e\u3055\u308c\u305f\u9078\u629e\u80a2\u306e\u8868\u793a\u30c6\u30ad\u30b9\u30c8\u304c\u62bd\u51fa\u3055\u308c\u307e\u3059\u3002\u63b2\u793a\u677f\u578b\u30fb\u30c6\u30fc\u30d6\u30eb\u578b\u30fb\u30ac\u30a4\u30c9\u30d1\u30cd\u30eb\u578b\u306f\u62bd\u51fa\u3067\u304d\u307e\u305b\u3093\uff08Warning\u304c\u30ed\u30b0\u51fa\u529b\u3055\u308c\u307e\u3059\uff09","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":"Questetra BPMS: \u6848\u4ef6, \u6307\u5b9a\u30c7\u30fc\u30bfTSV\u62bd\u51fa","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-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\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/11\/Questetra-BPMS-Process-Extract-as-TSV-ja.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"amp_enabled":false,"_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/126888","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\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=126888"}],"version-history":[{"count":7,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/126888\/revisions"}],"predecessor-version":[{"id":126940,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/126888\/revisions\/126940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/126943"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=126888"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=126888"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=126888"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}