Selecting a specific character from a VBA string

Question

How do I select a specific character from a string in VBA? The strings first characters always differ but the last 6 does not.

Say the string is: A = 1/2’’ NPT

Here I would like to get the ‘ closest to 2.

If the string is: A = 1-1/2’’ NPT

I would still want the ‘ closest to 2.

Any help would be appreciated! - Remi

You say the last six characters don't differ. So you're always going to want to select ’? — jsheeran
– jsheeran, Commented Jan 10, 2018 at 8:34

K.Dᴀᴠɪs · Accepted Answer · 2018-01-10 08:34:48Z

1

Sub test()

    Dim myStr As String

    myStr = "A = 1/2"" NPT"

    myStr = Split(myStr, """")(0)
    myStr = Split(myStr, "= ")(1)

    MsgBox myStr

End Sub

edited Jan 10, 2018 at 8:34

answered Jan 10, 2018 at 8:26

K.Dᴀᴠɪs

10.1k13 gold badges36 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Selecting a specific character from a VBA string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related