formula help with truncating text
I am looking for help with yet another formula that can be used to truncate the text of a text field. I've tried the right/left and trim, but my results are never consistent. The original field ...
Forum Discussion
I tested this and it seem to work. It does rely on the assumption that the fiel only has one @ in it and users are not tup;ing messages like
Please order me 5 widgets @ $10 each.
Here is the formula
var text AfterAt = Right([gmail text],"@");
var text AfterAtUpToSpace = Left($AfterAt," ");
var text BeforeAt = Left([gmail text],"@");
var text BeforeAtUpToSpace = Right($BeforeAt," ");
List("@", $BeforeAtUpToSpace, $AfterAtUpToSpace)
Please order me 5 widgets @ $10 each.
Here is the formula
var text AfterAt = Right([gmail text],"@");
var text AfterAtUpToSpace = Left($AfterAt," ");
var text BeforeAt = Left([gmail text],"@");
var text BeforeAtUpToSpace = Right($BeforeAt," ");
List("@", $BeforeAtUpToSpace, $AfterAtUpToSpace)