The final issue!

Ok, my program is done. I just need to resolve one last thing. I have a lot of my files named like this:

"Vaughn, Stevie Ray - Life By The Drop"

I have code that splits up the Artist and song already. So I wrote code to check for a comma in the Artist string. If the comma exists, It changes the Artist string from:

"Vaughn, Stevie Ray" TO "Stevie Ray Vaughn"

Problem is it looks like this: "Stevie Ray___________Vaughn"

How can I fix this? It should read: "Stevie Ray Vaughn"

Here's my code:

VB Code:

If InStr(artist, ",") > 0 Then
    temp2 = Split(artist, ",")
    artist = temp2(1) & temp2(0)
    End If

umm is it just me..or dont they both look the same??

VB Code:

artist = Replace(artist,",","")

I don't understand that replace statement there. I have use the array values from the split

Are the underscores supposed to be spaces?

If so then just change this:

VB Code:

artist = temp2(1) & temp2(0)

to:

VB Code:

artist = Trim(temp2(1)) & " " & Trim(temp2(0))

If they are actually underscores then use this:

VB Code:

artist=Replace(artist,"_"," ")
artist = Trim(temp2(1)) & " " & Trim(temp2(0))

The replace function replaces one charactor in a string, with another. I used to to replace the comma (,) in your string, with Null (thus removing it). You don't need to do a split.

But then the name is out of order SLH. He split it because he is switching the order.

But when you post, the forum takes out spaces so I used underscores to represent them

Thanks for the help. Now I can tag all of my 1685 mp3s in 5 min.