Private Sub Command1_Click() Dim s$, ss$ s = "asdakjh1j4h1haf" For i = 1 To Len(s) If IsNumeric(Mid(s, i, 1)) Then If Right(ss, 1) <> "_" Then ss = ss & "_" ss = ss & Mid(s, i, 1) & "_" Else ss = ss & Mid(s, i, 1) End If Next i MsgBox ss End Sub
Private Sub Form_Load() s = "asdakjh1j4h1haf" For i = 0 To 9 s = Replace(s, i, "_" & i & "_") Next MsgBox s End Sub
Private Sub Command1_Click() Dim s As String, i As Integer s = "asdakjh1j4h1haf1234" For i = 0 To 9 s = Replace(s, i, "_" & i & "_") Next s = Replace(s, "__", "_") MsgBox sEnd Sub
Private Sub Command1_Click()
Dim s$, ss$
s = "asdakjh1j4h1haf"
For i = 1 To Len(s)
If IsNumeric(Mid(s, i, 1)) Then
If Right(ss, 1) <> "_" Then ss = ss & "_"
ss = ss & Mid(s, i, 1) & "_"
Else
ss = ss & Mid(s, i, 1)
End If
Next i
MsgBox ss
End Sub
s = "asdakjh1j4h1haf"
For i = 0 To 9
s = Replace(s, i, "_" & i & "_")
Next
MsgBox s
End Sub
Private Sub Command1_Click()
Dim s As String, i As Integer
s = "asdakjh1j4h1haf1234"
For i = 0 To 9
s = Replace(s, i, "_" & i & "_")
Next
s = Replace(s, "__", "_")
MsgBox sEnd Sub