Sharepoint 2010 Calculated Column based on Name field
===

I need to get around the restriction that prevents the use of the Name column in a calculated column.

I basically need to create a new library column (BeginsWith) which is the first four letters of the value of (Name) - eg turning "analysis_type_dim" into "anal"

This can be done from the Title column but not the Name column (via the UI).  I tried creating a looping workflow but Microsoft have disabled this in 2010 :(

