Substitute any character...

[Michael Reade]

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

[fabriceN]

Have a look at the Replace function.

[Fitch]

Are you saying that you want to add a space after every character in the text field?

Search custom functions for "insert."

[Raybaudi]

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 :

[Raybaudi]

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 )

)

)

[comment]

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

)

)