SpacedCharsAndDigits ( text )

Puts a space between chars and digits of text

Average rating: 4.7 (23 votes) Log in to vote

Daniele Raybaudi - Show more from this author
ACI
http://www.aci.it

Sample input:

SpacedCharsAndDigits ( "12 123,12" )
SpacedCharsAndDigits ( "a123b1 1" )

Sample output:

12 123 , 12
a 123 b 1 1

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

/*
SpacedCharsAndDigits ( text ) Custom Function
Puts a space between chars and digits of text using the feature of TrimAll of add a space between roman and not roman chars

Revision 1: preserves eventual spaces between the digits
*/

Let(
adj = Substitute ( text ; " " ; "§§§" ) ;
TrimAll ( Substitute ( TrimAll ( KanjiNumeral ( adj ) ; 1 ; 1 )
; [ "一" ; 1 ]
; [ "二" ; 2 ]
; [ "三" ; 3 ]
; [ "四" ; 4 ]
; [ "五" ; 5 ]
; [ "六" ; 6 ]
; [ "七" ; 7 ]
; [ "八" ; 8 ]
; [ "九" ; 9 ]
; [ "〇" ; 0 ]
; [ "§§§" ; " " ]
) ; 1 ; 1 )
)

Puts a space between chars and digits of text using the feature of TrimAll of add a space between roman and not roman chars

Comments

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

SpacedCharsAndDigits ( text )

Comments

Support this website.

Support this website.