Does Quickbase have a replace function?
In JavaScript I would do something like var test = "I Hate Spaces"; var example = test.replace(" ", "_"); Then I could get the display "I_Hate_Spaces". Is there something similar I can do in Q...
Forum Discussion
There is no replace function.
But you can do this.
var text String = [My Field];
var text Delimiters = " !@#$%^&*";
List("",
Part($String,1,$Delimiters),
Part($String,2,$Delimiters),
Part($String,3,$Delimiters),
Part($String,4,$Delimiters),
Part($String,5,$Delimiters),
Part($String,6,$Delimiters),
Part($String,7,$Delimiters),
Part($String,8,$Delimiters),
Part($String,9,$Delimiters))
But you can do this.
var text String = [My Field];
var text Delimiters = " !@#$%^&*";
List("",
Part($String,1,$Delimiters),
Part($String,2,$Delimiters),
Part($String,3,$Delimiters),
Part($String,4,$Delimiters),
Part($String,5,$Delimiters),
Part($String,6,$Delimiters),
Part($String,7,$Delimiters),
Part($String,8,$Delimiters),
Part($String,9,$Delimiters))