TrimWithin ( OriginalValue )

Trims leading and trailing carriage returns as well as unnecessary carriage returns present between values in carriage return separated text.

Average rating: 5.0 (1 vote) Log in to vote

Bradley Gallavin - Show more from this author
Decent Group
https://www.decentgroup.co.uk

Sample input:

TrimWithin ( "¶¶Value1¶¶¶¶¶¶Value2¶Value3¶¶¶Value4¶¶¶¶¶" )

Sample output:

"Value1¶Value2¶Value3¶Value4"

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

// Removes empty values in the middle of carriage returned separated lists of data. 
// Also removes carriage returns from the start and end of the OriginalValue
// Created by: Bradley Gallavin

While ( 
	[ 
		numberOfValues = ValueCount ( OriginalValue ); 	// The number of values present in the original value passed to this function.
		i = 1 ; 									// A counter to track the progress of the while loop. This ensures we do not loop for more times than we need to.
		newValues = ""								// Instantiate a new variable so we can store the list that we will return, free of blanks.
	]; 

	i ≤ numberOfValues ; 							// Exit the loop after we have handled all of the values.

	[ 
		currentValue = GetValue ( OriginalValue ; i ); 		// Get the current value at position i.
		newValues = newValues & If(currentValue ≠ "" ; If(newValues ≠ "" ; ¶ ) & currentValue); // If this value is not blank, then add it to our 'newValues' list to be returned at the end of the loop.
		i = i + 1 									// Increment i for the next iteration.
	];
	newValues									// Return the values free of blanks.
)

This function takes in carriage return separated values and returns the same list after removing any unnecessary carriage returns from the beginning, middle or end of the original value supplied.

For example:

Supplying the function with the following value:
"
John

Jack

Joe
Josh

"

Will be returned as:
"John
Jack
Joe
Josh"

Comments

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

TrimWithin ( OriginalValue )

Comments

Support this website.

Support this website.