Using replace string in ASP

Question

I have a working function in JS

function countWords(s){
    s = s.replace(/(^\s*)|(\s*$)/gi,""); //modified trim function
    s = s.replace(/[ ]{2,}/gi," ");
    s = s.replace(/\n /,"\n");
    return s.split(' ').length;
}

The problem is when i change to ASP, it seems not working:

   Sub formatText(a)
        a = Replace("/(^\s*)|(\s*$)/gi",a,"")
        a = Replace("/[ ]{2,}/gi",a,"")
        a = Replace("/\n /",a,"\n")
        return a
    End Sub

It return nothing from the function, how to fix the problem? thanks

Changed to

'regEx initialization
Dim regEx
set regEx = New RegExp  'Creates a regexp object
regEx.IgnoreCase = True 'Set case sensitivity
regEx.Global = True     'Global applicability

'trim input text
Sub formatText(a)
    a = Replace("(^\s*)|(\s*$)",a,"")
    a = Replace("[ ]{2,}",a,"")
    regEx.IgnoreCase = False 'Set case sensitivity
    regEx.Global = False     'Global applicability
    a = Replace("\n ",a,"\n")
    return a
End Sub

still no luck please help..

The `/` at the beginning and end of your regexes is _JavaScript_ regex literal syntax, not part of the actual regex expressions. You don't want it in your ASP version, though I don't know how to set the `g` and `i` flags or their equivalent in VB. — nnnnnn, Jun 03 '13 at 11:13
May be your problem will resolve from this link http://stackoverflow.com/questions/8219317/replace-spaces-with-nbsp-from-a-recordset — Amit, Jun 03 '13 at 11:14

DAC84 · Accepted Answer · 2013-06-03T11:40:00.927

2

You'll need to use a regex object, like so:

'regEx initialization
Dim regEx
set regEx = New RegExp  'Creates a regexp object
regEx.IgnoreCase = True 'Set case sensitivity
regEx.Global = True     'Global applicability

regEx.Pattern = "<[^>]*>" 'Remove all HTML
strTextToStrip = regEx.Replace(strTextToStrip, " ")

Also remove the / from around the pattern.

UPDATED

'trim input text
Function formatText(a)
    Dim regEx
    set regEx = New RegExp  'Creates a regexp object
    regEx.IgnoreCase = True 'Set case sensitivity
    regEx.Global = True     'Global applicability

    regEx.Pattern = "(^\s*)|(\s*$)"
    a = regEx.Replace(a, "")

    regEx.Pattern = "[ ]{2,}"
    a = regEx.Replace(a, "")

    formatText = a
End Function

edited Jun 03 '13 at 11:40

answered Jun 03 '13 at 11:19

DAC84

1,254
1
20
30

is using count as -1 can do the same thing? Replace(expression, find, replacewith[, start[, count[, compare]]]) – user1871516 Jun 03 '13 at 11:22
I don't believe so no, see http://msdn.microsoft.com/en-us/library/k9z80300(v=vs.84).aspx – DAC84 Jun 03 '13 at 11:24
sorry but would you mind have a look at my changed version, why it still return nothing? – user1871516 Jun 03 '13 at 11:27

Using replace string in ASP

1 Answers1