Hi Everyone,
As most of you are already aware SharePoint has an issue with long file names. Also the full file path is often the culprit, especially when buried in a folder structure. After manually fixing many instances of this I am attempting to query each library to determine the file path length or even just the file name length. If I can query this and export to Excel I could fix these files before they become an issue. Does anyone know how to accomplish this? I tried to build this query myself but have come up short. Any help would be awesome! Thanks in advance.
Rick,
I had a similar issue and also exported the SP list via Export to Excel in Library tab. It takes a couple of steps as outlined below:
- Concatenate path + filename
=$A$1&Table_query[@Path]&”/”&Table_query[@Name] - Replace spaces with encoded URL – may need additional tweak for special characters
=SUBSTITUTE([cell], ” “, “%20”) - Find out the string length
=LEN([cell])
I hope that helps you out.
