{"id":10018,"date":"2024-03-28T14:28:43","date_gmt":"2024-03-28T14:28:43","guid":{"rendered":"https:\/\/conectasoftware.com\/docs\/docs\/conecta-hub\/transformaciones\/cadenas-de-texto\/extraer-desde-hasta\/"},"modified":"2025-03-30T19:35:37","modified_gmt":"2025-03-30T19:35:37","slug":"extraer-desde-hasta","status":"publish","type":"docs","link":"https:\/\/www.conectasoftware.com\/docs\/docs\/conecta-hub\/transformaciones\/cadenas-de-texto\/extraer-desde-hasta\/","title":{"rendered":"Extraer Desde Hasta"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"10018\" class=\"elementor elementor-10018\" data-elementor-post-type=\"docs\">\n\t\t\t\t<div class=\"elementor-element elementor-element-46f8b83 e-flex e-con-boxed e-con e-parent\" data-id=\"46f8b83\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-bc4e300 elementor-widget elementor-widget-code-highlight\" data-id=\"bc4e300\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-visual-basic, line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-visual-basic,\">\n\t\t\t\t\t<xmp>DESCRIPCION:\n\nExtrae el texto de ValorOrigen desde el caracter de Condicion1Valor hasta el caracter de Condicion2Valor\n\nEJEMPLO:\n\nExtraer de este c\u00f3digo gen\u00e9rico (88-1234Z) desde el caracter \u201c-\u201d hasta \u201c4\u201d\n\nValorOrigen: \u201c88-1234Z\u201d\n\nCondicion1Valor: \u201c-\u201d\n\nCondicion2Valor: \u201c4\u201d\n\nValorProcesado: \u201c1234\u201d<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-756664d elementor-widget elementor-widget-docly-data-table\" data-id=\"756664d\" data-element_type=\"widget\" data-widget_type=\"docly-data-table.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t        <div class=\"table_shortcode-wrap\" data-table_id=\"756664d\">\r\n            <table class=\"table doc-data-table table_shortcode\" id=\"table_shortcode-756664d\">\r\n                <thead>\r\n                <tr class=\"table-header\">\r\n\t\t\t\t\t                        <th class=\"\" id=\"\" colspan=\"\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"data-table-header-text\">Tipo<\/span><\/th>\r\n\t\t\t\t\t\t                        <th class=\"\" id=\"\" colspan=\"\">\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"data-table-header-text\">Valor<\/span><\/th>\r\n\t\t\t\t\t\t                <\/tr>\r\n                <\/thead>\r\n                <tbody>\r\n\t\t\t\t                    <tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\">Valor<\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\"> <\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                    <\/tr>\r\n\t\t\t\t                    <tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\">Valor2<\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\"> <\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                    <\/tr>\r\n\t\t\t\t                    <tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\">Relacion<\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\"> <\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                    <\/tr>\r\n\t\t\t\t                    <tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\">Relacion2<\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\"> <\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                    <\/tr>\r\n\t\t\t\t                    <tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\">Operacion<\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\">Extraer desde hasta<\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                    <\/tr>\r\n\t\t\t\t                    <tr>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\">Factor<\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                                    <td colspan=\"\" rowspan=\"\" class=\"\" id=\"\">\r\n                                        <div class=\"td-content-wrapper\"><div class=\"td-content\"> <\/div><\/div>\r\n                                    <\/td>\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t                    <\/tr>\r\n\t\t\t\t                <\/tbody>\r\n            <\/table>\r\n        <\/div>\r\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-297d3a9 elementor-widget elementor-widget-code-highlight\" data-id=\"297d3a9\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-visual-basic, line-numbers\">\n\t\t\t\t<code readonly=\"true\" class=\"language-visual-basic,\">\n\t\t\t\t\t<xmp>If ValorOrigen <> \u201c\u201d Then\n\nIf Condicion1Valor <> \u201c\u201d Then\n\nIf Condicion2Valor <> \u201c\u201d Then\n\nIf IsNumeric(Condicion1Relacion) Then\n\nElse\n\nCondicion1Relacion = 0\n\nEnd If\n\nIf IsNumeric(Condicion2Relacion) Then\n\nElse\n\nCondicion2Relacion = 0\n\nEnd If\n\nDim Posicion1 As Integer = 0\n\nDim Posicion2 As Integer = 0\n\nIf Condicion1Valor = \u201cInicio\u201d Then\n\nPosicion1 = 0\n\nElse\n\nPosicion1 = ValorOrigen.IndexOf(Condicion1Valor)\n\nEnd If\n\nIf Condicion2Valor = \u201cFin\u201d Then\n\nPosicion2 = ValorOrigen.Length\n\nElse\n\nPosicion2 = ValorOrigen.IndexOf(Condicion2Valor)\n\nEnd If\n\nDim Total As Integer = ValorOrigen.Length\n\nValorProcesado = ValorOrigen.Substring(Posicion1 + Condicion1Relacion, Posicion2 \u2013 Posicion1 + Condicion2Relacion)\n\nEnd If\n\nEnd If<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\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":"<p>DESCRIPCION: Extrae el texto de ValorOrigen desde el caracter de Condicion1Valor hasta el caracter de Condicion2Valor EJEMPLO: Extraer de este c\u00f3digo gen\u00e9rico (88-1234Z) desde el caracter \u201c-\u201d hasta \u201c4\u201d ValorOrigen: \u201c88-1234Z\u201d Condicion1Valor: \u201c-\u201d Condicion2Valor: \u201c4\u201d ValorProcesado: \u201c1234\u201d Tipo Valor Valor Valor2 Relacion Relacion2 Operacion Extraer desde hasta Factor If ValorOrigen \u201c\u201d Then If Condicion1Valor \u201c\u201d [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":9674,"menu_order":12,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-10018","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs\/10018","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/comments?post=10018"}],"version-history":[{"count":4,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs\/10018\/revisions"}],"predecessor-version":[{"id":10044,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs\/10018\/revisions\/10044"}],"up":[{"embeddable":true,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs\/9674"}],"wp:attachment":[{"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/media?parent=10018"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=10018"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}