Use calculated column to perform calculation on the "Name" column in a SharePoint library

Copper Contributor

I am trying to copy the name column in a SharePoint library (1000s files) to another column so that I can then separate the name (by "_") to produce metadata. The file naming convention includes the metadata, separated by a "_"(xxx_aaaaa_fffff_dd_kkkkk.pdf). Does anyone know how this can be achieved

2 Replies
There are some string functions that can extract parts of a string. If the different sets of characters are the same length, then you could use LEFT and RIGHT functions. Here is a reference guide:
https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b...

The alternative approach is to use a Power Automate Workflow to split the name into the parts and update the metadata fields.

@ColinFrick The name column can't be used in a calculated column. To achieve what you want to do would require a flow in Power Automate.