The data fields are “item #”,“sales manager”, “date” and “sales”. For example
I need to create a straight table with the sales manager’s initials instead of their full name. For example:
item # (dimension)
sales manager (expression)
I want to do it on the expression level, without changing the script, by using string functions. The data file contains numerous items, names and dates, but every item is associated with only one sales manager.
how a Sales Name could be one, two or tree or more words you can first make a Capitalize Stament
Nice but be aware of initialising Mac, Mc and O' surnames: