Note that unlike the original function presented, using CullNulls will remove leading/trailing returns originally in ValueList, so if retaining leading/trailing returns is important, additional logic is needed. Rather than reinventing the wheel for dealing with extraneous "¶", I used the excellent CullNulls CF to do the cleanup and ended up with the following:ĬullNulls( Substitute ( ¶ & ValueList & ¶ ¶ & Value & ¶ ¶ ) ) I like the non-recursive one line solution suggested in the comment above, but it may remove parts of a value, not the whole value.Įxample: Substitute ( "mouse¶rabbit¶lynx¶snake¶jackrabbit" ) results inĪdding the usual "¶" at the beginning and end of the ValueList and at the beginning and end of Value helps, but there may still be leftover returns depending on what the original list looked like. Substitute ( "mouse¶rabbit¶lynx¶snake" ) There's no need for recursion for this function. Recursion limits apply to the size of the list. Unlike other functions it does not require any padding nor adds nor removes any extra paragraph chars to the resulting list (save one at the end). This function removes all matching values from a list. ) & RemoveValue ( Value RightValues ( ValueList the_value_count - 1 ) ) The_existing_value = GetValue ( ValueList 1 ) The_value_count = ValueCount ( ValueList ) RemoveValue custom function by Caleb Ruth, Data Performance LLC Function definition: (Copy & paste into FileMaker's Edit Custom Function window) /*
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |