I have an SP Library that has a 'Name' column. The names of the documents are formatted as follows:
2021 CT0000 Driver Charlie Tuna 1_1_2021.jpg
2021 CT0000 Driver Capatain Charlie Tuna 1_1_2021.pdf
2021 CT0000 Driver Instructor Charlie Tuna 1_1_2021.bmp
I'd like to create a calculated column in the same Library that reads the content of the 'Name' column and automatically enters an abbreviation in the calculated column based on a 'portion' of the content in the 'Name' column.
Example: The content of the calculated column would be CT000D, CT0000DC, CT0000DI.
Is there a way to write an 'IF' statement for this purpose? Something like the below, that reads the string and if it finds the specific combination then...?
=IF("Driver Captain" in Title,"CT0000DC, IF("Driver Instructor" in Title,"CT0000DI))