I've got the following file name convention for images in an SP document library -
CQYr UnqID Qual Name
2020 RR0000 Bus Driver Roger Rabbit
I am using the following in a calculate column in that same library to extract the year out of the file name.
I have columns for the other three. How would I modify the calculation for each so that only the UnqID appears in that column, Qual in that column, and Name in that column?