FiveTech Software tech support forums

Dear Marc, thank you very much. This is exactly what I was looking for. From what I understand so far I now can break the string apart into tokens within an array and handle them according to my needs. For me this is very useful - since the csv is build from different sources like inis, dbfs etc all...

Here is a code the reads CVS. Maybe it will help. Do know that others can do this probably with just 10% of this code :lol: :lol: function readcsv()LOCAL cFileCSV := ""LOCAL aData, nTelif Empty( cFileCSV := cGetFile(   "DataFile (*.CSV)|*.csv|",          ;        ...

Dear Mr. Rao, thank you so much for providing the example. Seeing it in this compact and clear way is really beautiful. Dear Marc, I admit that for me as a newbie pre-made functions are simply great and convenient. But your approach, building from scratch is very educational for me and I understand ...

function jsonTest()   local c, h, j   HB_CDPSELECT( "DEWIN" ) // or any   c := "abc" + CRLF + "d ÄÖÜ"  // ANSI   h := { "key1"=> If( IsUtf8( c ), c, hb_strtoutf8( c ) ...

I see the function.... Maybe I should better look at it and start using it. hb_jsonEncode( { "key1" => "value1", "key2" => "value2", "key3" => "value3" } ) In my memofield there are chr(10) and sometimes other. Will that function c...

... + '"manufacturer":{"id":"'+alltrim(webshop->fabrikan)+'"},'   endif   IF AScan( aVelden, "MEMOTXT") > 0     cLayover = alltrim(webshop->memotxt)  //  At this point I try to remove chars that are not OK     cLayover ...

Dear Marc,

I am very interested in this topic, because those things happen to me a lot
how do you build the json string?
I use hb_JsonEncode() and usually special characters like " and \ are treated very well inside of it.

kind regards,
Ruth

Otto,

This code will change data to UTF8-coded data, but will not change a chr(10) to something else as far as I read.

Hello Marc, my daughter sent me these lines of code a few days ago, saying that they would solve the code page problem. Unfortunately, I haven’t tried it yet. Could you please test it? Best regards, Otto #include "hbextcdp.ch"  cVData := IIF( ! isUtf8( offert1->bezeichnun &...

I need to convert data inside memo fields to upload for a webshop. Therefore I put the data inside a Json string. This works but more than once it seems that there are special chars inside the memo field that will confuse the Json string ...

... Mr. Rao) https://forums.fivetechsupport.com/viewtopic.php?f=3&t=45155&sid=4d9e57d7689b479b76d45fd4c4cf140f The sample uses Memo files, but that is NOT needed. Just a lot of pdf's in a location on disk. Mr. Rao, if you are reading this, you once placed a preview of Xbrowse ...

Hi, Eu tenho um campo memo em um dbf que armazenar uma imagem com o memoread() oArqImg:IMAGEM := MemoRead(Alltrim(VetGars[x][10])) Qual a melhor maneira de mostrar essa imagem posteriormente em uma dialog? Or other way to save and recover ...

Hola Carlos, Excelente.

Funcionó, casi todo. Menos una tabla .adt que tiene campos memo.

Igualmente me sirvio, muy bueno.

Gracias, gracias.

Saludos

Ruben Dario Fernandez.

... para constancia, posterior tratamiento, pruebas, etc Para ello podemos guardar en carpetas o en campos de texto de SGBD tipo MariaDB, Sqlite o DBF memo (FPT) Pensar que si algun dia, estos XML deben de ir firmados, ya tenemos la infraestructura preparada para guardarlos Finalmente así lo haré yo ...

... para constancia, posterior tratamiento, pruebas, etc Para ello podemos guardar en carpetas o en campos de texto de SGBD tipo MariaDB, Sqlite o DBF memo (FPT) Pensar que si algun dia, estos XML deben de ir firmados, ya tenemos la infraestructura preparada para guardarlos ⋅ Diferenciar ...