p2p.wrox.com Forums - View Single Post - Unicode UTf-8? System.Text.UTF8Encoding from VBA?

vsrawat · #10 (**permalink**) December 7th, 2015, 06:27 AM

Quote:

Originally Posted by march11

You try this snippet of code it worked for me....

Code:

Function UTF8_Decode(ByVal sStr As String)
    Dim l As Long, sUTF8 As String, iChar As Integer, iChar2 As Integer
    For l = 1 To Len(sStr)
        iChar = Asc(Mid(sStr, l, 1))
        If iChar > 127 Then
            If Not iChar And 32 Then ' 2 chars
            iChar2 = Asc(Mid(sStr, l + 1, 1))
            sUTF8 = sUTF8 & ChrW$(((31 And iChar) * 64 + (63 And iChar2)))
            l = l + 1
        Else
            Dim iChar3 As Integer
            iChar2 = Asc(Mid(sStr, l + 1, 1))
            iChar3 = Asc(Mid(sStr, l + 2, 1))
            sUTF8 = sUTF8 & ChrW$(((iChar And 15) * 16 * 256) + ((iChar2 And 63) * 64) + (iChar3 And 63))
            l = l + 2
        End If
            Else
            sUTF8 = sUTF8 & Chr$(iChar)
        End If
    Next l
    UTF8_Decode = sUTF8
End Function

Yes, This code worked perfectly.

I had been stuck for several days trying to read Hindi devanagari unicode characters from a tab delimited file into vba7 ms word 1020 on w8-32 bit.

Had spend several hours searching everywhere on net.

Then I found your code, and it did the trick.

My this problem is fully and perfectly solved.

May God bless you.

Thanks a million.
--
Rawat
India