Forum Discussion
ColinFrick
Jun 19, 2024Copper Contributor
Use calculated column to perform calculation on the "Name" column in a SharePoint library
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 ...
SteveKnutson
Jun 19, 2024MVP
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-b170-bf7ebf6988b3
The alternative approach is to use a Power Automate Workflow to split the name into the parts and update the metadata fields.
https://support.microsoft.com/en-us/office/examples-of-common-formulas-in-lists-d81f5f21-2b4e-45ce-b170-bf7ebf6988b3
The alternative approach is to use a Power Automate Workflow to split the name into the parts and update the metadata fields.