Yeah, it was rather hurried
This might be a bit fasterCode:newString = theString tStart = InStr(1, newString, Chr(39)) qStart = InStr(1, newString, Chr(34)) Do While tStart > 0 newString = Left(newString, tStart - 1) & " " & Mid(newString, tStart + 1) tStart = InStr(1, newString, Chr(39)) Loop Do While qStart > 0 newString = Left(newString, qStart - 1) & " " & Mid(newString, qStart + 1) qStart = InStr(1, newString, Chr(34)) Loop theString = newStringheh and a bit more safe. You could just put theString all the way through, I just have a thing about temp variables to hold data being worked on.





heh and a bit more safe. You could just put theString all the way through, I just have a thing about temp variables to hold data being worked on.
Reply With Quote