具有多个替换的 javascript .replace() 方法

Question

我想迭代逗号分隔字符串中的值列表，并修改和附加每个值的字符串。示例:

    // get input text, convert 
    mySQLtext =  "Select * from filename@@"

    // get substitution value (what to replace)
    mySubstitutonToken =  "@@"

    // get substitution values (comma separated)
    mySubstituton =  "1,2,3,4,5,6,7,8,9"

    // break string into array
    mySubstitutonArray = mySubstituton.split(",");  

    // iterate and replace
    $.each(mySubstitutonArray, function(index, val) {                           
         myVal = mySQLtext.replace(mySubstitutonToken, val);                                    

        // put on screen
        $("#output_text").append(myVal + '<br>');                   

    });

输出:

Select * from filename1
Select * from filename2
Select * from filename3
Select * from filename4
Select * from filename5
Select * from filename6
Select * from filename7
Select * from filename8
Select * from filename9

问题

如果输入文本多次出现替换值，我将如何处理？将正则表达式语法与变量名称组合时遇到问题...

示例: mySQLtext = "从文件名@@中选择字段@@"

谢谢!

Answer 1

通过替换所有出现的地方而不是仅替换一个:

myVal = mySQLtext.replace(new RegExp(mySubstitutionToken,"g"), val);