Hello
I'm reading a string from Excel. I suspect that the string came in with Extra characters.
What could be the proper manner to strip any non printable characters?
Martin
Stripping extra characters on a string
Re: Stripping extra characters on a string
Maybe there is a way to modify this VBA code for EL. I have never tried it.
Code: Select all
strTempLongShort = GV_GetNamedString("Hld_" & strMySym & "_Side", "Not Sure")
call funcShowAscii( strTempLongShort)
Public Function funcShowAscii(strX As String)
Dim strASC As String
Dim i As Long
For i = 1 To Len(strX)
strASC = strASC & CStr(Asc(Mid(strX, i, 1))) & "-"
Next
MsgBox "ASC=" & strASC
End Function