September 24, 200817 yr with any character & " " Something like this: Substitute ( textField, "*"; "*" & " ") Except of course this doesn't work. Seems like my brain isn't working too well on that... Any suggestions for the easiest way to do it? Thanks, Michael
September 24, 200817 yr Are you saying that you want to add a space after every character in the text field? Search custom functions for "insert."
September 24, 200817 yr This insert a space between each char of a 6 chars field, w/o a custom function. Replace ( Replace ( Replace ( Replace ( Replace ( text ; 2 ; 0 ; " " ) ; 4 ; 0 ; " " ) ; 6 ; 0 ; " " ) ; 8 ; 0 ; " " ) ; 10 ; 0 ; " " ) P.S. More "Replace" for more chars :
September 24, 200817 yr Hi Fabrice ( this is only for us ;-) ) Space ( text ) Let( $count = $count + 2 ; Case( $count ≤ Length ( text ) ; Space ( Replace ( text ; $count ; 0 ; " " ) ) ; Let ( $count = "" ; text ) ) )
September 24, 200817 yr Since you have the developer version, you can easily use a custom function for this: InsertSpaces ( text ) Let ( len = Length ( text ) ; Case ( len > 1 ; InsertSpaces ( Left ( text ; len - 1 ) ) & " " & Right ( text ; 1 ) ; text ) )
Create an account or sign in to comment