2016-01-15 21:37 GMT+01:00 Maurice Howe <mauriceh...@gmail.com>: > Oh, that's easy. The facility already exists -- No need to "add" a > feature. I often have lists of names that need sorting is various ways. > TABLES are the answer.
Aren't spreadsheets tables already? > It may be cumbersome to make a table from a list, > but it really pays off for applications like yours. Table elements are > usually separated with tabs but spaces work, as well. And it's easy to > convert a table to text when that's appropriate. Play around -- you'll > find a way that fits your need. > > Maurice Howe > > > On Fri, Jan 15, 2016 at 11:49 AM, Ross Murray <rossmurray.a...@gmail.com> > wrote: > > > I hope my suggestion reaches its intended target, and meets your > > community's standards for submission of additional functions. > > > > I would like to see a REVERSE function, which returns a new string with > > characters in reverse order to the target string. > > > > I am attempting to remove duplicates after merging many files to create a > > very large list of names. Names may or may not have middle names; and/or > > initials which may or may not be follows by full stops. I would like to > > extract the last names and use those the primary sort key. While feasible > > with existing functions, it would seem easiest to - REVERSE the full > names; > > FIND the first space; RIGHT to extract the last names; and REVERSE those > to > > their original form. > > > > It seems like a simple new tool that the imaginations of users could > create > > more effective ways to complete many different objectives. > > > > ... From a devoted and appreciative user, > > > > Ross Murray. > > >
