1. Forum
  2. Usenet
  3. COMP.LANG.CLARION

  • C10 importing unicode csv file

    From Jovy@21:1/5 to All on Tue Feb 12 22:47:18 2019
    Hi all,
    I have a current issue where i need to import a CSV file into one of our systems. I understand the best support for unicode is in C11 but is there a way to import a unicode based csv file using the BASIC driver and some combination of driver strings?
    Thanks,
    Justin

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Sean H@21:1/5 to Jovy on Mon Feb 18 09:18:10 2019
    On 13/2/19 4:47 pm, Jovy wrote:
    Hi all,
    I have a current issue where i need to import a CSV file into one of our systems. I understand the best support for unicode is in C11 but is there a way to import a unicode based csv file using the BASIC driver and some combination of driver strings?
    Thanks,
    Justin


    Depending on How unicode it is. ie UTF8 is essentially ASCII so should
    just work.

    Other than that. Have a look at Capesofts String theory. It has methods
    for dealing with Unicode and for playing with CSV files


    Sean H

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jovy@21:1/5 to All on Tue Feb 19 15:46:10 2019
    Thanks Sean, Capesoft's string theory did the trick! I used the ToAnsi function to change the encoding from unicode to ansi and whala!
    Sad thing is I had purchased string theory for other templates as it was a prerequisite but not used any of its functions. Might do a full review to see what else I am missing out on :)
    Thanks again!
    Cheers,

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)