I would like to create a column based on part of the text in a filename, but then replacing it with alternative text (see attached image).
For example, I have a bunch of files named as follows:
The GEN, HDG, HKF, HPV, SRW, VTO & VUT parts of the filename are abbreviations but I want to display the full text. i.e. "General" instead of GEN" etc.
Looking at a few sample scripts I reckon I can create the column and populate it but I don't know if the alternative text is possible. Does anyone else know any better?