Turning a space into an underscore

[Musicarl]

Hello.

If field1 contains: "make my day"

and field2 contains: "Clint Eastwood"

I need a calculation field that will read:

"make_my_day/clint_eastwood"

I have no idea how to turn the spaces into underscores.

Thanks,

Ndugu

[Lee Smith]

Substitute (yourfield; " "; "_")

HTH

lee

[Musicarl]

Thank you Lee. That works, but I now realize I have to remove the commas from my fields as well. Is there a way to make this Substitution also remove commas?

[David Jondreau]

Substitute (yourfield; [" "; "_"];[","; ""])

[Musicarl]

Thanks DJ, that got it done. Appreciate the help guys.