I have a field that is pulling blank spaces as 1 space, but I need it to be 2 spaces. I’m trying to use @Contains and @Replace to do this, but am not having much success. What am I missing?
@If(@Contains(Account; " ") ; @Replace(Account; " "; " "))
Subject: @Contains / @Replace
Three things. First, you should be using @ReplaceSubstring, since @Replace only replaces whole elements from an array. Second, the @Contains isn’t necessary in this case. Third, you need to pass the Account value in to the @ReplaceSubstring. Try replacing your whole formula with:
@ReplaceSubstring(Account; " "; " ")
Subject: RE: @Contains / @Replace
Ben, thank you. I placed this code on a computed field on the form so I could then pull the first 7 characters and get exactly what I need to display. Thanks again!