{"id":1451,"date":"2018-07-02T11:19:38","date_gmt":"2018-07-02T10:19:38","guid":{"rendered":"http:\/\/www.xarcom.net\/blog\/?p=1451"},"modified":"2024-06-06T00:55:40","modified_gmt":"2024-06-05T23:55:40","slug":"extraer-datos-excel-a-partir-de-simbolo","status":"publish","type":"post","link":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/","title":{"rendered":"Extraer datos Excel a partir de s\u00edmbolo"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\n

Objetivo:<\/strong>\u00a0Muchas veces nos hemos encontrado que un cliente nos ha pasado una lista de correos electr\u00f3nicos extra\u00eddos de Outlook o de gmail, todo junto (nombre, cargo, correo electr\u00f3nico) estilo .csv y unicamente quiere el email (por ejemplo). Vamos a aprender a\u00a0separar los datos y a extraer<\/strong>\u00a0unicamente la informaci\u00f3n que queremos<\/strong>, en este caso unicamente el correo.\u00a0Ejemplo:<\/em><\/strong>\"\"De este p\u00e1rrafo extra\u00eddo de un .csv vamos a extraer (en este caso) correos electr\u00f3nicos, pero las f\u00f3rmulas con aplicables a lo que cada uno desee. \u00a0<\/p>\n

Separamos los correos.<\/h2>\n
    \n
  1. Necesitamos poner cada uno de los contactos en una fila, para ello vamos a\u00a0buscar coincidencias<\/strong>\u00a0en el texto que nos sirvan para hacer un salto de linea. Como vemos despu\u00e9s\u00a0\"\"<\/li>\n
  2. En mi caso lo com\u00fan que separa cada correo es \u00ab;<\/strong>\u00a0\u00ab. Ahora nos vamos a Notepad++, vamos a sustituir los \u00ab;<\/strong>\u00a0\u00bb por saltos de l\u00ednea \u00ab\\r\\n<\/strong>\u00ab.\"\"<\/li>\n
  3. Ya los tenemos separados, ahora ya podemos llevarlos a un excel. Los copiamos y los pegamos en un libro de excel.\"\"\"\"<\/li>\n<\/ol>\n

    Utilizaci\u00f3n de f\u00f3rmulas para obtener el resultado final con excel.<\/h2>\n
      \n
    1. Eliminamos todas las celdas intermedias vac\u00edas, porque cuando hagamos f\u00f3rmulas, esas nos dar\u00e1n error. Lo primero que vamos a hacer es buscar el s\u00edmbolo \u00ab<\u00ab, que, si nos fijamos en mi caso, es lo que separa el nombre_apellido del correo. Para buscar el s\u00edmbolo, necesitamos utilizar la f\u00f3rmula =ENCONTRAR, que el funcionamiento es el siguiente:\u00a0=ENCONTRAR(\u00abS\u00cdMBOLO\/TEXTO A BUSCAR\u00ab; \u00abdentro del texto de la celda\u00ab) +1<\/strong>\u00a0 (para que coja el valor de despu\u00e9s del s\u00edmbolo). Esta f\u00f3rmula nos dar\u00e1 un n\u00famero, vamos a verla.\"\"A continuaci\u00f3n necesitamos saber el tama\u00f1o de la cadena resultante, para ello vamos a utilizar la funci\u00f3n\u00a0=LARGO(texto),\u00a0<\/strong>vamos a verlo.\u00a0\"\"Como pod\u00e9is ver en la f\u00f3rmula, lo que hacemos es que miramos la longitud de la cadena completa (A2) y luego le restamos el n\u00famero de los valores donde hemos encontrado el s\u00edmbolo \u00ab<\u00ab. Ahora ver\u00e9is para qu\u00e9.<\/li>\n
    2. Por \u00faltimo, toca extraer el correo, que para eso todo el tinglado. Vamos a utilizar la f\u00f3rmula\u00a0=EXTRAE(\u00abcelda del texto real\u00ab,\u00bbPosici\u00f3n inicial que empieza a buscar\u00ab,\u00bbN\u00famero de caracteres que tiene que buscar\u00ab).<\/strong>\"\"<\/li>\n
    3. Ahora puede que necesit\u00e9is copiar estos resultados para utilizarlos en Mailchimp, por ejemplo. Para ello los copiamos, vamos a otra celda y los pegamos como \u00abValor<\/strong>\u00bb desde \u00abPegado especial<\/strong>\u00bb y a partir de ah\u00ed ya pod\u00e9is trabajar con los datos.\"\"<\/li>\n
    4. Y ahora ya podemos trabajar con los datos extra\u00eddos sin ning\u00fan tipo de problema.\"\"<\/li>\n<\/ol>\n

      \u00a1Pues con esto ya estar\u00edamos! Es un proceso que hay que tom\u00e1rselo con filosof\u00eda (como m\u00ednimo) si es la primera vez que lo hacemos, es algo lioso pero una vez le coges el truquillo es\u00a0MUY \u00daTIL.<\/strong>\u00a0A continuaci\u00f3n os dejo un bot\u00f3n donde pod\u00e9is descargar el archivo excel con el que he estado trabajando, para que pod\u00e1is echarle un vistazo si ten\u00e9is dudas.<\/p>\n

      Descargar Ejemplo<\/a><\/p>\n

      \u00a0 \u00a1Si ten\u00e9is dudas pod\u00e9is dejarlas en los comentarios! \u00a0 \u00a1Un saludo! \u00a0\u00a0\u00bfNecesitas hardware de calidad?<\/strong>\u00a0No dudes en echar un vistazo a\u00a0www.xarcom.net<\/a><\/em><\/p>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

      Objetivo: Muchas veces nos hemos encontrado que un cliente nos ha pasado una lista de correos electr\u00f3nicos extra\u00eddos de Outlook o de gmail, todo junto (nombre, cargo, correo electr\u00f3nico) estilo .csv y unicamente quiere el email (por ejemplo). Vamos a aprender a separar los datos y a extraer unicamente la informaci\u00f3n que queremos, en este caso unicamente el correo.<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[374,375,376,377,378,11,12,305,306,307,1,81],"tags":[379,380,381,383,382,385,386,384,350],"class_list":["post-1451","post","type-post","status-publish","format-standard","hentry","category-excel-2003","category-excel-2007","category-excel-2010","category-excel-2013","category-excel-2016","category-office-2003","category-office-2007","category-office-2010","category-office-2013","category-office-2016","category-uncategorized","category-utilidades-utilities","tag-excel-2003","tag-excel-2007","tag-excel-2010","tag-excel-2013","tag-excel-2016","tag-extraccion-de-datos","tag-extraer-correos-excel","tag-formulas-excel","tag-microsoft-office"],"yoast_head":"\nExtraer datos Excel a partir de s\u00edmbolo - XARCOM BLOG<\/title>\n<meta name=\"description\" content=\"Extraer de datos en excel a partir de s\u00edmbolos utilizando f\u00f3rmulas. Ponemos el caso de necesitar extraer correos electr\u00f3nicos.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Extraer datos Excel a partir de s\u00edmbolo - XARCOM BLOG\" \/>\n<meta property=\"og:description\" content=\"Extraer de datos en excel a partir de s\u00edmbolos utilizando f\u00f3rmulas. Ponemos el caso de necesitar extraer correos electr\u00f3nicos.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/\" \/>\n<meta property=\"og:site_name\" content=\"XARCOM BLOG\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-02T10:19:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-05T23:55:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png\" \/>\n<meta name=\"author\" content=\"XarCom\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"XarCom\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/\"},\"author\":{\"name\":\"XarCom\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136\"},\"headline\":\"Extraer datos Excel a partir de s\u00edmbolo\",\"datePublished\":\"2018-07-02T10:19:38+00:00\",\"dateModified\":\"2024-06-05T23:55:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/\"},\"wordCount\":557,\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/blog.xarcom.net\/#organization\"},\"image\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png\",\"keywords\":[\"Excel 2003\",\"Excel 2007\",\"Excel 2010\",\"Excel 2013\",\"Excel 2016\",\"extracci\u00f3n de datos\",\"extraer correos excel\",\"F\u00f3rmulas excel\",\"Microsoft Office\"],\"articleSection\":[\"Excel 2003\",\"Excel 2007\",\"Excel 2010\",\"Excel 2013\",\"Excel 2016\",\"Office 2003\",\"Office 2007\",\"Office 2010\",\"Office 2013\",\"Office 2016\",\"Sin Categor\u00eda\",\"Utilidades - Utilities\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/\",\"url\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/\",\"name\":\"Extraer datos Excel a partir de s\u00edmbolo - XARCOM BLOG\",\"isPartOf\":{\"@id\":\"https:\/\/blog.xarcom.net\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png\",\"datePublished\":\"2018-07-02T10:19:38+00:00\",\"dateModified\":\"2024-06-05T23:55:40+00:00\",\"description\":\"Extraer de datos en excel a partir de s\u00edmbolos utilizando f\u00f3rmulas. Ponemos el caso de necesitar extraer correos electr\u00f3nicos.\",\"breadcrumb\":{\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage\",\"url\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png\",\"contentUrl\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png\",\"width\":654,\"height\":198},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\/\/blog.xarcom.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Extraer datos Excel a partir de s\u00edmbolo\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.xarcom.net\/#website\",\"url\":\"https:\/\/blog.xarcom.net\/\",\"name\":\"XARCOM BLOG\",\"description\":\"Aquello que quer\u00edas saber y nadie te explic\u00f3\",\"publisher\":{\"@id\":\"https:\/\/blog.xarcom.net\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.xarcom.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/blog.xarcom.net\/#organization\",\"name\":\"XARCOM BLOG\",\"url\":\"https:\/\/blog.xarcom.net\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png\",\"contentUrl\":\"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png\",\"width\":200,\"height\":65,\"caption\":\"XARCOM BLOG\"},\"image\":{\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136\",\"name\":\"XarCom\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/blog.xarcom.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g\",\"caption\":\"XarCom\"},\"url\":\"https:\/\/blog.xarcom.net\/index.php\/author\/xarcombl0g\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Extraer datos Excel a partir de s\u00edmbolo - XARCOM BLOG","description":"Extraer de datos en excel a partir de s\u00edmbolos utilizando f\u00f3rmulas. Ponemos el caso de necesitar extraer correos electr\u00f3nicos.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/","og_locale":"es_ES","og_type":"article","og_title":"Extraer datos Excel a partir de s\u00edmbolo - XARCOM BLOG","og_description":"Extraer de datos en excel a partir de s\u00edmbolos utilizando f\u00f3rmulas. Ponemos el caso de necesitar extraer correos electr\u00f3nicos.","og_url":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/","og_site_name":"XARCOM BLOG","article_published_time":"2018-07-02T10:19:38+00:00","article_modified_time":"2024-06-05T23:55:40+00:00","og_image":[{"url":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png"}],"author":"XarCom","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"XarCom","Tiempo de lectura":"5 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#article","isPartOf":{"@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/"},"author":{"name":"XarCom","@id":"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136"},"headline":"Extraer datos Excel a partir de s\u00edmbolo","datePublished":"2018-07-02T10:19:38+00:00","dateModified":"2024-06-05T23:55:40+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/"},"wordCount":557,"commentCount":2,"publisher":{"@id":"https:\/\/blog.xarcom.net\/#organization"},"image":{"@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png","keywords":["Excel 2003","Excel 2007","Excel 2010","Excel 2013","Excel 2016","extracci\u00f3n de datos","extraer correos excel","F\u00f3rmulas excel","Microsoft Office"],"articleSection":["Excel 2003","Excel 2007","Excel 2010","Excel 2013","Excel 2016","Office 2003","Office 2007","Office 2010","Office 2013","Office 2016","Sin Categor\u00eda","Utilidades - Utilities"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/","url":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/","name":"Extraer datos Excel a partir de s\u00edmbolo - XARCOM BLOG","isPartOf":{"@id":"https:\/\/blog.xarcom.net\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage"},"image":{"@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png","datePublished":"2018-07-02T10:19:38+00:00","dateModified":"2024-06-05T23:55:40+00:00","description":"Extraer de datos en excel a partir de s\u00edmbolos utilizando f\u00f3rmulas. Ponemos el caso de necesitar extraer correos electr\u00f3nicos.","breadcrumb":{"@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#primaryimage","url":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png","contentUrl":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2018\/01\/Image-10-1.png","width":654,"height":198},{"@type":"BreadcrumbList","@id":"https:\/\/blog.xarcom.net\/index.php\/extraer-datos-excel-a-partir-de-simbolo\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/blog.xarcom.net\/"},{"@type":"ListItem","position":2,"name":"Extraer datos Excel a partir de s\u00edmbolo"}]},{"@type":"WebSite","@id":"https:\/\/blog.xarcom.net\/#website","url":"https:\/\/blog.xarcom.net\/","name":"XARCOM BLOG","description":"Aquello que quer\u00edas saber y nadie te explic\u00f3","publisher":{"@id":"https:\/\/blog.xarcom.net\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.xarcom.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/blog.xarcom.net\/#organization","name":"XARCOM BLOG","url":"https:\/\/blog.xarcom.net\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/","url":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png","contentUrl":"https:\/\/blog.xarcom.net\/wp-content\/uploads\/2024\/06\/Logo_Xarcom.png","width":200,"height":65,"caption":"XARCOM BLOG"},"image":{"@id":"https:\/\/blog.xarcom.net\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/blog.xarcom.net\/#\/schema\/person\/7d4f423ee0738574821bd898993d2136","name":"XarCom","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/blog.xarcom.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ed4b68cfa45d0ca9932a034f55490417801792278ea2a011a14097d2a82a7150?s=96&d=mm&r=g","caption":"XarCom"},"url":"https:\/\/blog.xarcom.net\/index.php\/author\/xarcombl0g\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts\/1451","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/comments?post=1451"}],"version-history":[{"count":30,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts\/1451\/revisions"}],"predecessor-version":[{"id":9235,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/posts\/1451\/revisions\/9235"}],"wp:attachment":[{"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/media?parent=1451"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/categories?post=1451"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.xarcom.net\/index.php\/wp-json\/wp\/v2\/tags?post=1451"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}