FHUG : Family Historian User Group

Wish List

Main Site  View Wishlist

Reference 455
Title New Function FormatText()
Category Queries
Description New Function FormatText()
Hiya Simon,
please could we have a FormatText() function?
And maybe a FormatDate() one too?
The idea is that we can format text into commonly-used formats, such as
uppercase, lowercase, sentence case etc. In other words, what most word
processing software will do.
I would like to see it added so that it could be used in Queries and in the
Text Schemes which you can use in diagrams. Reports would be be very useful too.
One particular gripe of mine (unless anyone can put me right), is that if I
include "relationship to" in a diagram box, it always come out lowercase,
which conlicts with the look of everything else in the box.
Another useful function, on exactly the same lines, could be a
Format Date() function.
Function prototypes:
FormatText(Format, TextToFormat)
FormatDate(Format, DateToFormat)
e.g. =FormatText("InitCaps",Relationship([""],%INDI%,TEXT,1))
or =FormateDate("YYYY-DD-MMM",%INDI.BIRT.DATE)
or some such, you get the idea.
Web Link http://www.fhug.org.uk/cgi-bin/index.cgi?action=forum&board=WishList&op=display&num=4316
Votes 6
Rating 2.3
Added Wednesday 26th May 2010 05:03 PM
Last Vote Wednesday 15th August 2012 08:42 PM

 

Only Signed in FHUG users can vote, please return to the main site and sign in.

 Return to List