{"id":9186,"date":"2020-11-30T17:00:53","date_gmt":"2020-11-30T16:00:53","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=9186"},"modified":"2020-11-30T17:00:53","modified_gmt":"2020-11-30T16:00:53","slug":"split-formula-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-formulas\/split-formula-in-google-sheets\/","title":{"rendered":"C\u00f3mo utilizar la funci\u00f3n SPLIT en Google Sheets"},"content":{"rendered":"\n[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;54px|0px|0|0px|false|false&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_row _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>The<span>\u00a0<\/span><a href=\"https:\/\/support.google.com\/docs\/answer\/3094147?hl=en\" target=\"_blank\" rel=\"noopener noreferrer\">DCOUNTA<\/a><span>\u00a0<\/span>formula in Google Sheets\u00a0counts the number of values in a table-like array or range that meet specific criteria. It is similar to an SQL database count query. The \u2018D\u2019 in DCOUNTA stands for \u2018Database\u2019, therefore this is a <strong>Database COUNTA<\/strong> formula. Whereas the <a href=\"https:\/\/support.google.com\/docs\/answer\/3094222\" target=\"_blank\" rel=\"noopener noreferrer\">DCOUNT<\/a> function only counts numeric values, DCOUNTA counts both numeric and text values.<\/p>\n<h3><\/h3>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text admin_label=&#8221;Connections T &#8211; Automate beyond importrange &#8211; Horizontal&#8221; module_class=&#8221;sheetgo-post-no-shadow-img md2-contained-button-light vertical-banner-container&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f7ff&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; max_height=&#8221;300px&#8221; custom_margin=&#8221;20px|0px|20px|0px|true|true&#8221; custom_padding=&#8221;25px|25px|25px|25px|true|true&#8221; sticky_limit_bottom=&#8221;section&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#d9e7ff&#8221; global_module=&#8221;50462&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Add-on-sm_sheets-connected-new-connection.webp\" width=\"250\" height=\"168\" alt=\"\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\" width=\"150\" height=\"180\" alt=\"39\" \/><\/p>\n<p><span style=\"font-size: 22px; font-weight: 600;\">Automate data transfers beyond Importrange<\/span><\/p>\n<p><a href=\"https:\/\/www.sheetgo.com\/connections\/\" target=\"_blank\" rel=\"noopener\">Find out how<\/a><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.27.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>Here&#8217;s how it works:<\/p>\n<h4>Syntax<\/h4>[\/et_pb_text][et_pb_text module_class=&#8221;spreadsheet-function&#8221; _builder_version=&#8221;4.16&#8243; border_width_left=&#8221;4px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>=SPLIT( text, delimiter, [split_by_each], [remove_empty_text] )<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; min_height=&#8221;361px&#8221; custom_margin=&#8221;||2px|||&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<ul>\n<li><strong>text<\/strong> \u2013 the text or string that you want to split.<\/li>\n<li><strong>delimiter<\/strong> \u2013 a single character or a group of characters that the function should consider for splitting the <strong>text<\/strong>. By default, each character within the <strong>delimiter<\/strong> is considered individually. For instance, if the delimiter is \u201cone\u201d, then the text is divided around the characters \u201co\u201d, \u201cn\u201d, and \u201ce\u201d. If you do not want this behavior, you can set the <strong>split_by_each<\/strong> to FALSE. Note that the delimiter will not be included in the output of the function.<\/li>\n<li><strong>split_by_each<\/strong> \u2013 [ OPTIONAL \u2013 TRUE by default ] \u2013 if you go with the default option, then the function considers each character within the delimiter string to split the text. If you set this to FALSE, then the function considers the delimiter as a whole. You can select this parameter by writing TRUE or FALSE, or by indicating 1 or 0, respectively.<\/li>\n<li><strong>remove_empty_text<\/strong> \u2013 [ OPTIONAL \u2013 TRUE by default ] \u2013 this parameter indicates whether or not the function should remove empty text fragments from the split results. The default behavior is to treat consecutive delimiters as one (if TRUE). If FALSE, empty cell values are added between consecutive delimiters. You can select this parameter by writing TRUE or FALSE, or by indicating 1 or 0, respectively.<\/li>\n<\/ul>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h3>How to use the SPLIT function in Google Sheets<\/h3>\n<p>The syntax looks a lot more complex than it actually is.<\/p>\n<p>So, to get you comfortable with the function, I\u2019ll show you some examples. Take a look at the screenshot below.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/SPLIT-FORMULA-GOOGLE-SHEETS-1-GOOD.png&#8221; alt=&#8221;SPLIT FORMULA GOOGLE SHEETS 1&#8243; title_text=&#8221;SPLIT FORMULA GOOGLE SHEETS 1 &#8221; align=&#8221;center&#8221; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.16&#8243; width=&#8221;640px&#8221; max_width=&#8221;640px&#8221; height=&#8221;440px&#8221; max_height=&#8221;440px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>You can see that the results that I get are the input text, broken into pieces at the points where the delimiters are in the text. For the first example, the delimiter is \u201ce\u201d, so the result is one cell with all the text before the e\u2019s in \u201cSheetgo\u201d, and one cell with all the text after the e\u2019s. I achieve that here by typing <strong>=Split(A2,B2)<\/strong>.<\/p>\n<p>The same is true with the other examples shown. In each, I specify a delimiter, and the function breaks the text into chunks that come before, in between, and after the delimiters. This can be extremely convenient for separating text data such as first and last names separated by a comma, as seen in the third example above.<\/p>\n<h4>Tip: Leave empty columns to the right<\/h4>\n<p>I have entered all the functions in column D. That&#8217;s because the SPLIT function in Google Sheets spreads its output across multiple cells towards the right, as is the case with all the examples. So, it is very important that you keep the cells, where you expect the data to flow, clear of any values. Otherwise, the function returns a #REF! error.<\/p>\n<p>These first few examples show the SPLIT function in its most basic form. I didn\u2019t specify the optional parameters, so they remained at their default value. Now I\u2019ll demonstrate what happens when you add in the optional parameters <strong>split_by_each<\/strong> and <strong>remove_empty_text<\/strong>.<\/p>\n<h4>SPLIT function with split_by_each parameter<\/h4>\n<p>The <strong>split_by_each<\/strong> parameter is used when the delimiter is more than one character long. As you can see in the image below, changing this parameter can have a significant impact on the output of the function.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/SPLIT-FORMULA-GOOGLE-SHEETS-2.png&#8221; alt=&#8221;SPLIT FORMULA GOOGLE SHEETS 2&#8243; title_text=&#8221;SPLIT FORMULA GOOGLE SHEETS 2&#8243; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; width=&#8221;640px&#8221; max_width=&#8221;640px&#8221; height=&#8221;440px&#8221; max_height=&#8221;440px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>In this example, I am splitting the word \u201cCountries\u201d using the delimiter \u201cone\u201d.<\/p>\n<p>The default value of the<strong> split_by_each<\/strong> parameter is 1 (TRUE), which tells the function to consider each character in the delimiter. So when you use this option, the function uses the \u201co\u201d, \u201cn\u201d, and \u201ce\u201d as individual delimiters. You can see the result above: the text \u201cCountries\u201d is split into four parts.<\/p>\n<p>The next example uses a <strong>split_by_each<\/strong> parameter value of 0 (FALSE), which tells the function to consider the delimiter text as one single delimiter of multiple characters. So in this case, the function will only split the text based on the delimiter of the entire word \u201cone\u201d. Of course, \u201cone\u201d does not appear in \u201cCountries\u201d, so it does not split the text at all. This goes to show the large difference in results that occurs when you change the <strong>split_by_each<\/strong> parameter when using a multi-character delimiter.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h4>SPLIT function with remove_empty_text parameter<\/h4>\n<p>Now I\u2019ll show an example using the <strong>remove_empty_text<\/strong> parameter. This parameter is used when you have consecutive delimiters in your text.<\/p>\n<p>If the parameter is TRUE (default value) it will treat consecutive delimiters as a single delimiter; if FALSE, it will treat them as individual delimiters and add blank cells to the results.<\/p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/SPLIT-FORMULA-GOOGLE-SHEETS-3.png&#8221; alt=&#8221;SPLIT FORMULA GOOGLE SHEETS 3&#8243; title_text=&#8221;SPLIT FORMULA GOOGLE SHEETS 3&#8243; module_class=&#8221;sheetgo-post-no-shadow-img&#8221; _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; width=&#8221;640px&#8221; max_width=&#8221;640px&#8221; height=&#8221;440px&#8221; max_height=&#8221;440px&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p>You can see the difference here. I have a text string that contains consecutive delimiters \u2014 in this case, two commas beside each other.<\/p>\n<p>In the default case, where the <strong>remove_empty_text<\/strong> parameter is 1 (TRUE), the function treats the consecutive commas as one and outputs the text split up as expected.<\/p>\n<p>In the second case, however, I\u2019ve set the <strong>remove_empty_text<\/strong> parameter to 0 (FALSE). Now, the function treats each comma as a separate delimiter, so it adds a blank cell to the output to reflect the \u201cspace\u201d (even though there is no space character) in between the two commas.<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<h3>SPLIT function: Things to remember<\/h3>\n<p>There are a few things to keep in mind when using the SPLIT function. First, always make sure you have enough blank cells to the right since the SPLIT function can output across multiple cells.<\/p>\n<p>Second, remember that the delimiter will always be removed from the text. For example, if you want to separate text strings by commas, the comma will not appear in any of the output cells.<\/p>\n<p>Lastly, you can also split text by selecting <strong>Data<\/strong> &gt; <strong>Split text to columns<\/strong>. This method is less versatile, however, so you may be better off using the SPLIT function \u2013 play around with both options to see for yourself!<\/p>[\/et_pb_text][et_pb_text _builder_version=&#8221;4.22.2&#8243; background_color=&#8221;#f9f9ff&#8221; custom_margin=&#8221;40px||40px||false|false&#8221; custom_padding=&#8221;15px|25px|15px|25px|true|true&#8221; border_width_left=&#8221;3px&#8221; border_color_left=&#8221;#808e95&#8243; global_module=&#8221;26540&#8243; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<p><em><strong>Editor\u2019s note<\/strong>: This is a revised version of a previous post that has been updated for accuracy and comprehensiveness.<\/em><\/p>\n[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text admin_label=&#8221;Connections T &#8211; One tool &#8211; Horizontal&#8221; module_class=&#8221;sheetgo-post-no-shadow-img md2-contained-button vertical-banner-container&#8221; _builder_version=&#8221;4.27.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#f2f7ff&#8221; max_width=&#8221;700px&#8221; module_alignment=&#8221;center&#8221; max_height=&#8221;300px&#8221; custom_margin=&#8221;20px|0px|20px|0px|true|true&#8221; custom_padding=&#8221;25px|25px|25px|25px|true|true&#8221; sticky_limit_bottom=&#8221;section&#8221; border_radii=&#8221;on|20px|20px|20px|20px&#8221; border_width_all=&#8221;1px&#8221; border_color_all=&#8221;#d9e7ff&#8221; global_colors_info=&#8221;{}&#8221; global_module=&#8221;50458&#8243; theme_builder_area=&#8221;post_content&#8221;]<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/connections-top-processors-main.webp\" width=\"250\" height=\"168\" alt=\"\" \/>\n\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/09\/Recommended-for-Google-Workspace-badge.webp\" width=\"150\" height=\"180\" alt=\"39\" \/>\n\n<span style=\"font-size: 22px; font-weight: 600;\">One tool to merge, split, and filter all your spreadsheet data<\/span>\n\n<a href=\"https:\/\/www.sheetgo.com\/connections\/\" target=\"_blank\" rel=\"noopener\">Find out how<\/a>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"<p>The\u00a0DCOUNTA\u00a0formula in Google Sheets\u00a0counts the number of values in a table-like array or range that meet specific criteria. It is similar to an SQL database count query. The \u2018D\u2019 in DCOUNTA stands for \u2018Database\u2019, therefore this is a Database COUNTA formula. Whereas the DCOUNT function only counts numeric values, DCOUNTA counts both numeric and text [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":29222,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"Spreadsheets have become the first stop for most of us to handle data. And the nature of the data supported by these applications is not limited to numbers. They seem to provide us with all the requisite tools to tackle even the text-based\u00a0data. In this article, we'll learn the functioning of <a href=\"https:\/\/support.google.com\/docs\/answer\/3094136\" target=\"_blank\" rel=\"noopener\">SPLIT<\/a> formula in Google Sheets. It helps us to separate a string based on a delimiter.\n<h3>Syntax<\/h3>\n<strong>SPLIT(text, delimiter, [split_by_each], [remove_empty_text])<\/strong>\n<ul>\n \t<li><strong>text<\/strong> - is the text or string that we want to split.<\/li>\n \t<li><strong>delimiter<\/strong> - is a single character or a group of characters that the formula should consider for splitting the <strong>text<\/strong>. By default, each character within the <strong>delimiter<\/strong> is considered individually. For instance, if the <strong>delimiter<\/strong> is \"one\", then the text is divided around the characters \"o\", \"n\", and \"e\". If we do not this behavior, we\u00a0can do so by setting the <strong>split_by_each<\/strong> to FALSE.<\/li>\n \t<li><strong>split_by_each<\/strong> - [ OPTIONAL - TRUE by default ] - if we went with the default option, then the formula considers each character within the delimiter string to split the text. If we set this to FALSE, then the formula considers the delimiter as a whole.<\/li>\n \t<li><strong>remove_empty_text<\/strong> - [ OPTIONAL - TRUE by default ] - this parameter indicates whether or not the formula should\u00a0remove empty text messages from the split results. The default behavior is to treat consecutive delimiters as one (if TRUE). If FALSE, empty cells values are added between consecutive delimiters.<\/li>\n<\/ul>\n<h3>Usage: SPLIT formula in Google Sheets<\/h3>\nThe syntax looks more complex than it actually is. So, to get comfortable with the formula, let us try our\u00a0hands practically without further ado. See the screenshot below.\n\n<img class=\"aligncenter size-full wp-image-9317\" src=\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/07\/SPLIT-formula-Illustration-Frame-1.png\" alt=\"SPLIT formula in Google Sheets\" width=\"728\" height=\"509\" \/>\n\nWe have entered all the formulas in column D.\u00a0That is because the SPLIT formula in Google Sheets spreads its output across multiple cells towards the right, as is the case with all the examples. So, it is very important that we keep the cells, where we expect the data to flow, clear of any values. Otherwise, the formula returns #REF! error.\n<h4>Explanation<\/h4>\nThe first four examples are probably a little straightforward. We passed the text and the delimiter, and the outputs are as expected. It gets interesting hereafter.\n\nCompare the inputs and outputs on the fifth and sixth examples. We provided the same <strong>text<\/strong> and <strong>delimiter<\/strong> values. Yet the outputs are a lot different from each other. In the fifth example, the formula considers each individual characters - \"o\", \"n\", and \"e\" as separate delimiters. That is because the <strong>split_by_each\u00a0<\/strong>parameter is TRUE by default. However, in the sixth example, we set it to FALSE. Therefore the delimiter is a composite \"one\" instead of separate characters. So, the formula did not split the <strong>text<\/strong>, because there is no occurrence of \"one\" within the <strong>text<\/strong> \"Countries\". Had there been an occurrence, like in the seventh example, the formula would have split the text accordingly.\n\nIn the final example, we passed FALSE for the <strong>remove_empty_text<\/strong> parameter. Therefore after the making a split, the formula didn't remove the\u00a0empty text from cell E9.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[55,39,28],"class_list":["post-9186","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-ben-collins","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9186","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=9186"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/9186\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/29222"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=9186"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=9186"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=9186"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}