...
Download the .zip file for your campus. Contact David if you don’t have that URL.
There is a separate CSV file within the .zip file for each data model/work form, of which we currently have four: dataset, educational resource, publication, and thesis. If your campus will be cleaning up Title metadata for more than just ETDs, you will need to complete the following clean up steps for each CSV separately.
For each CSV file, download it and save it locally. Then delete all fields (columns) except for id (column A) and title (column I).
To partially There are a couple of ways to automate the clean up process, insert a new column to the right of the title field (now column b) and insert one of the following formulas, depending on your needs.
(In progress).
Using the Title Case Converter: This tool allows you to convert text based on the capitalization guidelines of various formatting styles. To facilitate batch editing, your campus may want to decide to use one style in all cases, regardless of disciplinary variations. Please consult the Which Title Case Style Should You Use? page for additional information.
Copy all the metadata in the title column and paste it into Notepad or a similar program of your choice to strip out unwanted formatting.
Then paste that text into the Title Case Converter. Note: The converter does not have an explicit character limit, but it seems to work best with approximately 500 or fewer words, so you may need to do this in batches.
Select the title case style your campus