Regular Expressions 101

Save & Manage Regex

  • Current Version: 1
  • Save & Share
  • Community Library

Flavor

  • PCRE2 (PHP)
  • ECMAScript (JavaScript)
  • Python
  • Golang
  • Java
  • .NET 7.0 (C#)
  • Rust
  • PCRE (Legacy)
  • Regex Flavor Guide

Function

  • Match
  • Substitution
  • List
  • Unit Tests
Sponsors
There are currently no sponsors. Become a sponsor today!
An explanation of your regex will be automatically generated as you type.
Detailed match information will be displayed here automatically.
  • All Tokens
  • Common Tokens
  • General Tokens
  • Anchors
  • Meta Sequences
  • Quantifiers
  • Group Constructs
  • Character Classes
  • Flags/Modifiers
  • Substitution
  • A single character of: a, b or c
    [abc]
  • A character except: a, b or c
    [^abc]
  • A character in the range: a-z
    [a-z]
  • A character not in the range: a-z
    [^a-z]
  • A character in the range: a-z or A-Z
    [a-zA-Z]
  • Any single character
    .
  • Alternate - match either a or b
    a|b
  • Any whitespace character
    \s
  • Any non-whitespace character
    \S
  • Any digit
    \d
  • Any non-digit
    \D
  • Any word character
    \w
  • Any non-word character
    \W
  • Non-capturing group
    (?:...)
  • Capturing group
    (...)
  • Zero or one of a
    a?
  • Zero or more of a
    a*
  • One or more of a
    a+
  • Exactly 3 of a
    a{3}
  • 3 or more of a
    a{3,}
  • Between 3 and 6 of a
    a{3,6}
  • Start of string
    ^
  • End of string
    $
  • A word boundary
    \b
  • Non-word boundary
    \B

Regular Expression
Processing...

Test String

Substitution
Processing...

Code Generator

Language

Generated Code

#include <MsgBoxConstants.au3> ; to declare the Constants of MsgBox Local $sRegex = "DEFINER=`(.*?)`@`(.*?)`" Local $sString = "CREATE DEFINER=`xguadacard`@`19.21.54.4` FUNCTION `fn_actualizacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_alerta_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ambito_comision_ambito_liquidacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ambito_comision_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ambito_liquidacion_movimiento_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ambito_liquidacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ambito_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_bono_limite_fecha_inicio_s`(in_bonoLimiteTipoId INT) RETURNS date" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_bono_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_centro_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_bono_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_ciudadano_modalidad_s`(in_fechaNacimiento DATE) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_comunicacion_tipo_s`(`in_ciudadanoId` INT) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_estado_cambio_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tarjeta_estado_s`(`in_ciudadanoId` INT) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tarjeta_fecha_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tarjeta_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tarjeta_ultima_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tipologia_ciudadano_activa_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tipologia_ciudadano_activa_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tipologia_ciudadano_fecha_caducidad_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tipologia_ciudadano_tipologia_activa_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tipologia_ciudadano_ultima_v`(`in_ciudadanoTipologiaCiudadanoId` INT) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_ciudadano_tipologia_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_compra_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_dispositivo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_edad_s`(in_fechaNacimiento DATE) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_entidad_financiera_liquidacion_compra_numero_s`(in_entidadFinancieraId INT) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_entidad_financiera_liquidacion_fichero_numero_dia_s`(in_entidadFinancieraId INT) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_entidad_financiera_liquidacion_fichero_numero_s`(in_entidadFinancieraId INT) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_entidad_financiera_liquidacion_fichero_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_entidad_financiera_liquidacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_entidad_financiera_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_fraude_proceso_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_operacion_firma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_operacion_offline_aviso_u`(in_aviso VARCHAR(50), " & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_producto_beneficio_precio_s`(`in_productoBeneficioTipoId` INT, `in_productoBeneficioImporte` DECIMAL(8,4), `in_productoBeneficioIndiceCobro` DECIMAL(8,4), `in_productoBeneficioImporteMaximo` DECIMAL(8,4), `in_importeDescuento` DECIMAL(8,4)) RETURNS decimal(8,4)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_producto_beneficio_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_producto_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_recarga_anterior_id_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_recarga_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_recuperacion_saldo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_recuperacion_saldo_tarjeta_origen_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_rol_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarea_exportacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarjeta_centro_recogida_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarjeta_estado_cambio_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarjeta_identificador_tarjeta_s`(`in_id` INT, " & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarjeta_modalidad_recarga_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarjeta_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarjeta_saldo_consumido_s`(in_tarjetaId INT," & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarjeta_ultima_v`(`in_tarjetaId` INT) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_tarteja_uid_invertido_s`(in_uid varchar(50)) RETURNS varchar(50) CHARSET utf8" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_traspaso_saldo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_uso_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_usuario_actividad_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` FUNCTION `fn_usuario_s`(" & @CRLF & _ "CREATE DEFINER=`root`@`localhost` FUNCTION `fn_utilidad_numerico_s`(in_valor VARCHAR(255)) RETURNS int(11)" & @CRLF & _ "CREATE DEFINER=`root`@`localhost` FUNCTION `fn_utilidad_numerico_v`(val VARCHAR(255)) RETURNS tinyint(4)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_actualiza_tarjeta_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_actualiza_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_ciudadano_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_estado_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_estado_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_estado_pendiente_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_estado_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_pendiente_cancela_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_actualizacion_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_caducada_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_estado_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_estado_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_estado_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_fraude_proceso_ciudadano_cu`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_fraude_proceso_cu`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_fraude_proceso_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_fraude_proceso_tarjeta_cu`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_fraude_proceso_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_multiple_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_priodidad_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_alerta_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_c`(in_usuarioId INTEGER, " & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_comision_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_comision_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_comision_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_comision_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_cierre_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_compra_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_compra_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_compra_multiple_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_cuadro_seguimiento_ambito_liquidacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_cuadro_seguimiento_movimiento_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_cuadro_seguimiento_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_entidad_financiera_liquidacion_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_estado_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_estado_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_estado_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_c`(IN in_usuarioId INT, " & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_cuenta_alias_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_estado_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_estado_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_s`(IN in_usuarioId INT, " & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_movimiento_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_recarga_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_recarga_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_recarga_multiple_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_total_actualiza_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_total_crea_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_liquidacion_total_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ambito_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_aviso_multiple_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_aviso_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_asignacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_beneficio_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_limite_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_limite_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_limite_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_limite_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_bono_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_centro_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_centro_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_centro_u`(IN `in_usuarioId` INT, IN `in_id` INT, IN `in_nombre` VARCHAR(255), IN `in_descripcion` VARCHAR(255), IN `in_mail` VARCHAR(255), IN `in_ambitoId` INT, OUT `out_result` INT)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_bono_asignacion_automatica_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_bono_asignacion_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_bono_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_bono_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_bono_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_bono_valido_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_estado_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_estado_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_estado_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_estado_tarjeta_solicitud_v`(IN `in_ciudadanoId` INT, OUT `out_result` INT)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_estado_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_estado_valido_s`(IN `in_ciudadanoEstadoOrigenId` INT, OUT `out_result` INT)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_foto_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_frontoffice_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_modalidad_ciudadano_caducada_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_modalidad_ciudadano_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tarjeta_estado_solicitud_v`(IN `in_ciudadanoId` INT, OUT `out_result` INT)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tarjeta_solicitud_v`(IN `in_ciudadanoId` INT, OUT `out_result` INT)" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tarjeta_ultima_s`(IN `in_ciudadanoId` INT, " & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_caducada_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_activa_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_asignacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_caducada_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_cambio_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_documento_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_documento_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_documento_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_documento_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_fecha_caducidad_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_solicitud_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_ciudadano_u_m`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_documento_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_multiple_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_perfil_transporte_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_tipo_asignacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipologia_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tipo_tutor_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_tutor_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_ciudadano_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_ambito_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_centro_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_entidad_financiera_liquidacion_fichero_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_g`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_offline_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_offline_firma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_offline_identificador_compra_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_offline_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_anula_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_anula_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_anula_confirma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_anula_identificador_compra_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_anula_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_ciudadano_bono_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_ciudadano_bono_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_confirma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_identificador_compra_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_producto_beneficio_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_producto_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_producto_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_tarjeta_saldo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_uso_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_uso_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_online_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_saldo_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_compra_total_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_dispositivo_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_dispositivo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_dispositivo_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_documento_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_fichero_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_fichero_solicitud_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_fichero_solicitud_reprocesar_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_fichero_solicitud_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_fichero_solicitud_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_fichero_tipo_solicitud_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_fichero_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_liquidacion_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_liquidacion_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_liquidacion_fichero_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_liquidacion_fichero_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_liquidacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_entidad_financiera_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_error_bbdd_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fichero_impresion_tarjeta_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fichero_impresion_tarjeta_tipologia_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_compra_tarjeta_no_activa_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_compra_tarjeta_no_existe_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_recarga_saldo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_recarga_tarjeta_no_existe_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_fraude_proceso_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_documento_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_documento_d`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_documento_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_documento_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_estado_abierta_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_estado_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_estado_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_estado_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_estado_valido_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_prioridad_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_incidencia_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_offline_dispositivo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_offline_tarjeta_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_online_centro_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_online_dispositivo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_online_tarjeta_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_rechazo_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_rechazo_g`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_operacion_tarjeta_prueba_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_beneficio_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_beneficio_ciudadano_valido_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_beneficio_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_beneficio_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_beneficio_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_bono_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_ciudadano_tipologia_cd`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_ciudadano_tipologia_filtro_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_ciudadano_tipologia_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_ciudadano_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_ciudadano_valido_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_historico_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_producto_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_ambito_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_centro_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_g`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_offline_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_offline_firma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_offline_identificador_recarga_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_offline_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_anula_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_anula_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_anula_confirma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_anula_identificador_recarga_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_anula_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_confirma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_identificador_recarga_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_tarjeta_saldo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_online_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_saldo_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recarga_total_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_confirma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_identificador_recuperacion_saldo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_tarjeta_origen_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_tarjeta_origen_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_tarjeta_origen_saldo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_tarjeta_origen_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_recuperacion_saldo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_rol_usuario_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarea_exportacion_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarea_exportacion_descargada_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarea_exportacion_descargada_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarea_exportacion_finalizada_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_centro_recogida_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_direccion_pospago_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_entrega_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_estado_historico_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_estado_historico_s`(IN `in_usuarioId` INT," & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_estado_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_estado_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_estado_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_estado_valido_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_fichero_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_fichero_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_fichero_tarjeta_completo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_fichero_tarjeta_incremental_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_fichero_tarjeta_unificado_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_fichero_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_frontoffice_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_impresion_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_impresion_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_limite_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_modalidad_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_pospago_credito_usado_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_tarjeta_uid_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_traspaso_saldo_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_traspaso_saldo_confirma_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_traspaso_saldo_confirma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_traspaso_saldo_identificador_traspaso_saldo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_traspaso_saldo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_traspaso_saldo_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_ambito_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_centro_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_g`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_offline_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_offline_firma_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_offline_identificador_uso_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_offline_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_online_bono_limite_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_online_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_online_ciudadano_bono_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_online_identificador_uso_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_online_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_uso_total_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_actividad_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_actividad_tipo_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_administrador_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_administrador_rol_cu`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_administrador_rol_duplicado_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_administrador_rol_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_administrador_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_administrador_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_desconexion_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_password_token_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_password_token_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_password_token_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_password_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_permiso_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_permiso_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_rol_c`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_rol_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_rol_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_s`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_token_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_u`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_usuario_v`(" & @CRLF & _ "CREATE DEFINER=`xguadacard`@`localhost` PROCEDURE `sp_utilidad_procedimiento_s`(`in_cadenaBusqueda` VARCHAR(255))" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "/*!50013 DEFINER=`xguadacard`@`localhost` SQL SECURITY DEFINER */" & @CRLF & _ "" Local $sSubst = "DEFINER=`xguadacard`@`localhost`" Local $sResult = StringRegExpReplace($sString, $sRegex, $sSubst) MsgBox($MB_SYSTEMMODAL, "Result", $sResult)

Please keep in mind that these code samples are automatically generated and are not guaranteed to work. If you find any syntax errors, feel free to submit a bug report. For a full regex reference for AutoIt, please visit: https://www.autoitscript.com/autoit3/docs/functions/StringRegExp.htm