Another use for JUSTEXT( )

Most developers see functions like JUSTFNAME ( ) and JUSTPATH) as file -based functions, useful for stripping down file names down to their lowest level. But they can also be used with tables and aliases.
 
Example:
 
CUSTOMERS.COMPANYNAME
 
? JUSTEXT(“CUSTOMERS.COMPANYNAME”)  && returns COMPANYNAME
? JUSTSTEM(“CUSTOMERS.COMPANYNAME”) && returns CUSTOMERS

(correction from comments: JUSTSTEM is the function I wanted, not JUSTFNAME which gives the full file name, doh! – thanks Sietse)

 
This can be a handy way of parsing through data dictionaries.

1 thought on “Another use for JUSTEXT( )”

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Contact

48 Stonemeadow Drive
Kanata, Ontario K2M2K2

+1 613-851-4496 Contact Us

Connect

Newsletter

Coming Soon