Okay, I had a bit of a think about it, and realised I could open the .xml file in Excel and create a vba script to do the conversion automatically (a whole library of 35,000+ songs took about 20 minutes). However, I am now trying to export the file back into the original .xml layout. Any idea how to export back into the correct xml format?
The code is as below:
Sub SlashSwap()
Dim LastRow As Long
Dim FilePath As String
Dim FilePathEdit As String
LastRow = 0
FilePath = ""
FilePathEdit = ""
'First, find ensure your library is filtered to display only the filepaths.
'Second, find the length of this list.
Range("A1").Select
Selection.End(xlDown).Select
LastRow = ActiveCell.Offset(1, 0).Row
'Next, begin the loop.
Range("D2").Select
Do While ActiveCell.Row < LastRow
'Ensure that the row is not filtered.
If Not ActiveCell.Rows.Hidden Then
FilePath = ActiveCell.Value
'Check to see if the string has any "/" slashes.
Do While InStr(1, ActiveCell.Value, "/") <> 0
'Replace all the "/" with "\".
FilePathEdit = Replace(FilePath, "/", "\", 1)
ActiveCell.Value = FilePathEdit
Loop
End If
FilePath = ""
FilePathEdit = ""
ActiveCell.Offset(1, 0).Select
Loop
End Sub