Parse utf8 cst Garbled code issue

[yjjbjh166]

Parse utf8 cst Garbled code bug

Sub test2()
    Dim CSVint As CSVinterface
    Dim conf As CSVparserConfig
    Dim Arr() As Variant
    Set CSVint = New CSVinterface
    Set conf = CSVint.parseConfig
    With conf
        .path = "C:\Users\Administrator\Desktop\VBA-CSV\test.csv"
        conf.dialect.fieldsDelimiter = ","
        conf.dialect.recordsDelimiter = vbCrLf
        .multiEndOfLineCSV = True
        .utf8EncodedFile = True
    End With
    CSVint.ImportFromCSV(conf).DumpToArray Arr
    Sheet1.[a1].Resize(UBound(Arr) + 1, UBound(Arr, 2) + 1) = Arr
End Sub

test.csv

[ws-garcia]

Please provide more details about the behavior. Also a screenshot of the CSV file opened in a tool like Notepad++ can help us with the issue.

[yjjbjh166]

Please provide more details about the behavior. Also a screenshot of the CSV file opened in a tool like Notepad++ can help us with the issue.

[ws-garcia]

Carefully reviewing your problem, I found an error in the copy of the parser settings that prevented the library from working properly. Here are the lines of code that helped me correctly read the information in your UTF-8 encoded file.

Sub test2()
    Dim CSVint As CSVinterface
    Dim conf As CSVparserConfig

    Set CSVint = New CSVinterface
    Set conf = CSVint.parseConfig
    With conf
        .path = "C:\Users\Administrator\Desktop\VBA-CSV\test.csv"
        conf.dialect.fieldsDelimiter = ","
        conf.dialect.recordsDelimiter = vbCrLf
        .utf8EncodedFile = True
    End With
    CSVint.ImportFromCSV(conf).DumpToSheet
End Sub

I'll close the issue now. Waiting for you to report any eventuality in the future.

[yjjbjh166]

Is it the problem of my environment? win10 Chinese

[ws-garcia]

I don't think is SO related.

Download the new release and try it again. Hoping this can solve your issue. Reach me without hesitation if you face some related problem.

[yjjbjh166]

Just copy your code generated a new sheet but it is still garbled but it is normal if you change to ansi. (CSV Interface v4.4.3)

[yjjbjh166]

QQ202542-7440.mp4