Removing Spaces

[-Lisa-]

Can anyone assist me in creating a rule which will allow me to remove spaces and/or special characters?

 

I've got a rule which auto-populates an email address by combining the first initial of the first name (FName Field) with the last name (LName Field). This works well except in instances where a last name is something like O'Reilly or De Angela.

[David Miller]

You can try:

 

return Field("YourFieldName").replace(/\s|\'/g,"");

 

This will remove spaces (s) and apostrophes (') from your field globally (g).

[-Lisa-]

Thanks David! I knew it had to be a replace script...I think I just forgot the "g". Appreciate the help!

[Natea11]

This is exactly what I have been looking for. Well, almost.

 

What would the complete rule on this look like? Create an email address by combining the first initial of the first name (FName Field) with the last name (LName Field) and then place "@company.com".

 

Thanks

[step]

Here's an example of how the entire rule could look:

 

var first = Left(Field("FName"),1);
var last = Field("LName");
return [first,last].filter(String).join("").replace(/\s|\'/g,"") + "@company.com";