Adding Spaces Between Characters

[LisetteG]

My database includes records for Korean "clients." I would like to find a calculation that will add a space between each character in their names.

For example, go from this 안중태

To this: 안 중 태

Anyone know a way to do this?

Thanks in advance for your input.

Lisette

[comment]

I am under the vague impression that the RomanZenkaku() function is supposed to do something like that.

If not, you'll need a custom recursive function (requires the Advanced version).

[LisetteG]

I just used the left, right and middle functions in a calculation. That worked for me.

In case anyone is curious.

Left(field name)&" "&Right(field name)&" "&Middle(field name; 2 ; 1)

[comment]

I presume you mean =

Left ( field name ; 1 ) & " " & Middle ( field name ; 2 ; 1 ) & " " & Right ( field name ; 1 )

That will work as long as your field contains EXACTLY 3 characters.

[LisetteG]

oh yes,

I typed that up in a hurry. Records have 2-3 characters in that field. So it works out.

[comment]

If it's 2 characters, then it won't work correctly.

But if it's at most 3 characters, you could use =

Trim ( Left ( text ; 1 ) & " " & Middle ( text ; 2 ; 1 ) & " " & Middle ( text ; 3 ; 1 ) )

Edited April 27, 2010 by Guest

[LisetteG]

Thank you very much. Exactly what I was looking for.