Funció Replace

Replaces some string by another.

Sintaxi:


       Replace (Expression As String, Find As String, Replace As String [, Start = 1 [, Count = -1 [, Compare = True]]]) As String

Quan necessiteu passar menys paràmetres, utilitzeu arguments de paraula clau. Passar valors per a menys paràmetres per posició requereix proporcionar valors per a tots els paràmetres anteriors, opcionals o no. Això garanteix que els valors estiguin en les posicions correctes. Si passeu els paràmetres pel nom, utilitzant arguments de paraula clau, podeu ometre tots els altres arguments intermedis.

Valor de retorn:

Cadena

Paràmetres:

Expression: Any string expression that you want to modify.

Find: Any string expression that shall be searched for.

Replace: Any string expression that shall replace the found search string.

Start: Optional numeric expression that indicates the character position where the search starts and also the start of the substring to be returned.

Count: Optional maximum number of times the replace shall be performed. When set to -1, all possible replacements are performed.

Compare: Optional boolean expression that defines the type of comparison. The value of this parameter can be True or False. The default value of True specifies a text comparison that is not case-sensitive. The value of False specifies a binary comparison that is case-sensitive. You can as well use 0 instead of False or 1 instead of True.

Codis d'error

5 La crida al procediment no és vàlida

Exemple:


        MsgBox Replace ("aBbcnnbnn", "b", "$", 1, 1, False)  'retorna «aB$cnnbnn»
        REM significa que «b» s'ha de reemplaçar, però
        REM * only when lowercase (compare=False), hence second occurrence of "b"
        REM * only first (respecting case) occurrence (count=1)
        MsgBox Replace ("ABCDEFGHI", "E", "*", 4)
        REM returns D*FGHI because the search starts at position 4, which is also the start of the returned string.
        MsgBox Replace("aBbcnnbnn", "b", "$£", compare:=False)  'returns "aB$£cnn$£nn"
        REM Replace all (count = -1) "b" with "$£" respecting casing (compare=False) starting from first letter (start=1)

de les funcions de cadena

ScriptForge.String service