ReturnSelections ( )

returns values of selection, text before and text after

Average rating: 4.2 (31 votes) Log in to vote

Hisc - Show more from this author
noplace
http://nourl

Sample input:

Selection in field

Sample output:

List(number of pieces;text before selection; selected text; text after selection)

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

Let([
start=Get(ActiveSelectionStart);
field=Get(ActiveFieldContents);
l_field=Length(field);
size=Get(ActiveSelectionSize);
end=Get(ActiveSelectionStart)+Get(ActiveSelectionSize)-1];

Case(
end=l_field and size=0;List("1";field);
size=0 and start=1;List("1";field);
size≠0 and start=1;List("2";Left(field;end);Right(field;l_field-end));
size=0 and start≠1;List("2";Left(field;end);Right(field;l_field-end));
size≠0 and start≠1;List("3";Left(field;start-1);Middle(field;start;size);Right(field;l_field-end));
))

Returns the parts of the text as separated by the selecion in the current field. If the selection just divides in two field, returns a list with the number 2, and the two "chopped" parts. If the selection divides the field in three partes, returns 3 and the three chopped parts.

Comments

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

ReturnSelections ( )

Comments

Support this website.

Support this website.