AnsweredAssumed Answered

Convert . (dot) to _ (underscores) in File name

Question asked by Jeremiah Griffith on Apr 23, 2018
Latest reply on Apr 23, 2018 by Rob Edwards

Like • Show 0 Likes0
Comment • 5

I am using a macro to export .igs files to a specific location. We'd like to take the existing part #'s which are for example 900.3680.001.01 and export the file name as 900_3680_001_01 instead.

I'm sure this is easy, I'm just not coming across it in my head at the moment.

Thanks,

Jeremiah

Rob Edwards Apr 23, 2018 9:51 AM

Correct Answer

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

See the reply in context

No one else had this question

Outcomes

5 Replies

Rob Edwards Apr 23, 2018 9:51 AM
Unmark Correct
Correct Answer
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
```
Like • Show 2 Likes2
Actions
- Jeremiah Griffith @ Rob Edwards on Apr 23, 2018 10:10 AM
  Mark Correct
  Correct Answer
  No clue why I didn't think about doing that... too close to the problem sometimes lol!
  
  Thanks!
  Jeremiah
  Like • Show 1 Like1
  Actions
- Jeremiah Griffith @ Rob Edwards on Apr 23, 2018 10:22 AM
  Mark Correct
  Correct Answer
  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
  Like • Show 0 Likes0
  Actions
  - Jeremiah Griffith @ Jeremiah Griffith on Apr 23, 2018 10:40 AM
    Mark Correct
    Correct Answer
    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.
    Like • Show 1 Like1
    Actions
    - Rob Edwards @ Jeremiah Griffith on Apr 23, 2018 11:03 AM
      Mark Correct
      Correct Answer
      Most definitely, I used to think I needed a glove puppet till I got a Rubber duck
      
      Like • Show 0 Likes0
      Actions

Convert . (dot) to _ (underscores) in File name

Outcomes

Related Content

Recommended Content