{"id":10026,"date":"2024-03-28T14:29:38","date_gmt":"2024-03-28T14:29:38","guid":{"rendered":"https:\/\/conectasoftware.com\/docs\/docs\/conecta-hub\/transformaciones\/cadenas-de-texto\/sustituir\/"},"modified":"2025-03-30T19:35:37","modified_gmt":"2025-03-30T19:35:37","slug":"sustituir","status":"publish","type":"docs","link":"https:\/\/www.conectasoftware.com\/docs\/docs\/conecta-hub\/transformaciones\/cadenas-de-texto\/sustituir\/","title":{"rendered":"Sustituir"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"10026\" class=\"elementor elementor-10026\" data-elementor-post-type=\"docs\">\n\t\t\t\t<div class=\"elementor-element elementor-element-03ec6ed e-flex e-con-boxed e-con e-parent\" data-id=\"03ec6ed\" 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-06fb394 elementor-widget elementor-widget-text-editor\" data-id=\"06fb394\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><u>DESCRIPCI\u00d3N<\/u>:<\/p><p>Comprueba si la cadena del Valor Origen contiene la Condicion1Valor y reemplaza parte de esa cadena por el Factor indicado<\/p><p><u>EJEMPLO:<\/u><\/p><p>Cambiar cualquier valor a \u201c3\u201d<\/p><p>Valor origen: \u201c045003157\u201d<\/p><p>Valor Procesado: \u201c3\u201d<\/p><p>Si la cadena Valor Origen es \u201c*\u201d<\/p><p>el Valor Procesado es igual al Factor<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d52c20a elementor-widget elementor-widget-docly-data-table\" data-id=\"d52c20a\" 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=\"d52c20a\">\r\n            <table class=\"table doc-data-table table_shortcode\" id=\"table_shortcode-d52c20a\">\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\">Sustituir<\/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\">1<\/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-faf3d35 elementor-widget elementor-widget-code-highlight\" data-id=\"faf3d35\" 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\nValorProcesado = ValorOrigen.ToString.Replace(ValorOrigen, Factor)\n\nElse\n\nIf ValorOrigen.Contains(Condicion1Valor) Then\n\nValorProcesado = ValorOrigen.ToString.Replace(Condicion1Valor, Factor)\n\nEnd If\n\nEnd If\n\nElse\n\nIf Condicion1Valor = \u201c*\u201d Then\n\nValorProcesado = Factor\n\nElse\n\nValorProcesado = ValorOrigen\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>DESCRIPCI\u00d3N: Comprueba si la cadena del Valor Origen contiene la Condicion1Valor y reemplaza parte de esa cadena por el Factor indicado EJEMPLO: Cambiar cualquier valor a \u201c3\u201d Valor origen: \u201c045003157\u201d Valor Procesado: \u201c3\u201d Si la cadena Valor Origen es \u201c*\u201d el Valor Procesado es igual al Factor Tipo Valor Valor Valor2 Relacion Relacion2 operacion Sustituir [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":9674,"menu_order":16,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-10026","docs","type-docs","status-publish","hentry","no-post-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs\/10026","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=10026"}],"version-history":[{"count":4,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs\/10026\/revisions"}],"predecessor-version":[{"id":10056,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/docs\/10026\/revisions\/10056"}],"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=10026"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/www.conectasoftware.com\/docs\/wp-json\/wp\/v2\/doc_tag?post=10026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}