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 metadata, separated by a “_”(xxx_aaaaa_fffff_dd_kkkkk.pdf). Does anyone know how this can be achieved
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 Read More