I created an SP document library and moved 2700 .jpg files into it.
I am trying to create a Calculated column that looks at the 'Name' column in the library and extracts characters 1 - 4 the first new column and characters 6 -9 for second new column.
My issue is I CAN NOT see 'Name' as an option in the column list when creating the calculated column. I can see several autogenerated SP columns, including 'Title' (which was not auto-populated when the files were uploaded.
All files names in the Library are formatted as CQYear UniqueID CQTitle (2020 RR0000 Driver...)
I'd like to add columns for CQYr, UnqID, CQTitle
2020 RR0000 Driver