(correction from comments: JUSTSTEM is the function I wanted, not JUSTFNAME which gives the full file name, doh! – thanks Sietse)
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.
? JUSTEXT(“CUSTOMERS.COMPANYNAME”) && returns COMPANYNAME
? JUSTSTEM(“CUSTOMERS.COMPANYNAME”) && returns CUSTOMERS
This can be a handy way of parsing through data dictionaries.