1. Home
  2. Conecta HUB
  3. Transformations
  4. Validation
  5. URL

URL

DESCRIPTION:

Formats the SourceValue string to be accepted in a URL

EXAMPLE:

SourceValue: "Item 20% Discount 10€".

ProcessValue: "item-20-discount-10".

 

CONFIGURATION:

Value Value2 Relation Relationship2 Operation Factor
URL

CODE:

If Factor = "WithSpaces" Then

Else

ValorOrigen = ValorOrigen.ToString.Replace(" ", "-")

End If

SourceValue = SourceValue.ToLower

SourceValue = SourceValue.ToString.Replace(".", "")

SourceValue = SourceValue.ToString.Replace(",", "")

ValorOrigen = ValorOrigen.ToString.Replace(":", "")

SourceValue = SourceValue.ToString.Replace("*", "")

SourceValue = SourceValue.ToString.Replace("/", "")

SourceValue = SourceValue.ToString.Replace("'", "")

SourceValue = SourceValue.ToString.Replace("(", "")

SourceValue = SourceValue.ToString.Replace(")", "")

ValorOrigen = ValorOrigen.ToString.Replace("ª", "")

ValorOrigen = ValorOrigen.ToString.Replace("º", "")

SourceValue = SourceValue.ToString.Replace("^", "")

SourceValue = SourceValue.ToString.Replace("@", "")

SourceValue = SourceValue.ToString.ToString.Replace("$", "")

SourceValue = SourceValue.ToString.Replace("{", "")

SourceValue = SourceValue.ToString.Replace("}", "")

SourceValue = SourceValue.ToString.Replace("[", "")

SourceValue = SourceValue.ToString.Replace("]", "")

SourceValue = SourceValue.ToString.Replace("+", "")

SourceValue = SourceValue.ToString.Replace("¡", "")

SourceValue = SourceValue.ToString.Replace("!", "")

SourceValue = SourceValue.ToString.ToString.Replace("%", "")

SourceValue = SourceValue.ToString.Replace("&", "")

ValorOrigen = ValorOrigen.ToString.Replace("\", "")

ToString.ToString.Replace("=", "")

ValorOrigen = ValorOrigen.ToString.Replace("ñ", "n")

ValorOrigen = ValorOrigen.ToString.Replace("€", "")

ValorOrigen = ValorOrigen.ToString.Replace("á", "a")

ValorOrigen = ValorOrigen.ToString.Replace("é", "e")

ValorOrigen = ValorOrigen.ToString.Replace("í", "i")

ValorOrigen = ValorOrigen.ToString.Replace("ó", "o")

ToString.ToString.Replace("ú", "u")

ValorOrigen = ValorOrigen.ToString.Replace("ü", "u")

SourceValue = SourceValue.ToString.Replace(Chr(34), "")

SourceValue = SourceValue.ToString.Replace(Chr(39), "")

ProcessValue = SourceValue

Was this article helpful to you? Yes No

How can we help?