-
Re: Convert . (dot) to _ (underscores) in File name
Hi Jeremiah
The Replace Function should work
Option Explicit Sub main() Dim s As String s = "123.456.789" Debug.Print s Debug.Print Replace(s, ".", "_") End Sub
-
Re: Convert . (dot) to _ (underscores) in File name
No clue why I didn't think about doing that... too close to the problem sometimes lol!
Thanks!
Jeremiah
-
Re: Convert . (dot) to _ (underscores) in File name
So, next question. LOL.
So our file part name is say:
962.3672.001.01 GATE, SS, 36X72 (other random text).sldprt
Is there anyway to isolate just the 962.3672.001.01 from that? Keeping in mind that the part number there could be any number of digits... The only constant I can determine is that it will always be without spaces. So i'm guessing I should be able to look at it from the left and isolate everything to the right of the first space (From the left side of the file name)
Make sense?
Thanks,
Jeremiah-
Re: Convert . (dot) to _ (underscores) in File name
Nevermind, I thought about it a bit more, and used the split function to split the file name at the first space.
Thanks, sometimes you just have to bounce things off someone else to pull yourself back to center and find the answer lol.
-
-
