Remove a specific word from a text string

[macfan55]

Hi out there; my first question is this: How can I make a rule that removes a specific word from a text string and make a new variable out of the remaining text.

Help is appreciated here!

[jwhittaker]

return ReplaceSubstring(Field("string"),'texttoreplace', 'replacementtext');

[macfan55]

Thanks! Works great.

1 question about the search and replace field;

Can I use a "wildcard" in the texttoreplace field as a part of it?

[Dan Korn]

Thanks! Works great.

1 question about the search and replace field;

Can I use a "wildcard" in the texttoreplace field as a part of it?

You can do that with JavaScript's String.replace function and a Regular Expression.

 

You can find lots of examples online by searching for "JavaScript replace wildcard", such as:

http://www.brighthub.com/internet/web-development/articles/85831.aspx

 

If you have a more specific question about how to replace something, then I, or someone else here, could provide a more specific answer.

[macfan55]

Thanks for your answer; The problem I now have is that the word I want to replace is mostly "Location" and sometimes "location" so I was looking for a way to use a wildcard for the first letter like "*ocation" but that does not work. Maybe You can show me the right way to do that as a part of the replace substring code. Thanks in advance!

[ScottHillock]

var Var1 = Field("name");

return Var1.replace(/([lL]ocation)+/g,"test");

[Dan Korn]

var Var1 = Field("name");

return Var1.replace(/([lL]ocation)+/g,"test");

 

Or just add the "i" flag to the Regular Expression to do a case-insensitive match/replacement:

return Field("YourFieldName").replace(/location/gi, "new text");

[macfan55]

Thanks four your great help! It works perfect!!