repeat_insert ( a_string ; to_insert ; the_interval )

insert a string every so many positions within another string

Average rating: 4.5 (32 votes) Log in to vote

Steve Harley - Show more from this author

Sample input:

series_insert ("17E39122ADF4"; ":"; 2)

Sample output:

17:E3:91:22:AD:F4

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

Let ([
    the_size = Length (a_string);
    the_head = Left (a_string; 2)
    ];
  If (the_size > 2;
    the_head & to_insert & repeat_insert (Right (a_string; the_size -2); to_insert; the_interval);
    the_head
  )
)

recursive custom function to insert some text at repeated intervals throughout some other text; useful for example to convert a pure hexadecimal MAC address to the conventional notation with colons every two digits, or to break up credit card numbers with spaces every four digits

Comments

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

repeat_insert ( a_string ; to_insert ; the_interval )

Comments

Support this website.

Support this website.