Memoedit to HTML by API connection

[Marc Venken]

I'm having issues that when I read a memo field where some ascii codes like CRLF,.. are used and I save them by API online,
The API is not saving data when there are special chars insite the text.
I tried some changing with strreplace, but there are always new items comming up.

Is there a general ALL conversion of special chars for this in a function (FW) ?

[Antonio Linares]

Dear Marc,

What API do you refeer to ?

Could you please provide a small example ?

[Marc Venken]

Antonio,

I fill a string with keys needed by the API. Once I have filled the str the upload is done.
The problem I seem to have is that insite the memofield there a chars (codes) like CRLF, ENTER, and more format items. When I leave them out the upload is ok.
When I include the field and I think there are some codes inside like like CRLF ,... the upload is not correct.

I already change chars before include into the string, but I miss some of them. Is there a list of these items ? Is that the Unicode ??

Code: Select all  Expand view

     //  This is one of the items to be included.

     if lNew .or. at("MEMOTXT",cChanges) > 0
       cData = change_memotxt(alltrim(webshop->memotxt))
       cBuffer = cBuffer + '"introDescription":"'+cData+'",'  //  string building for later upload by API (jSon)
       cChanges = strtran(cChanges,"[MEMOTXT]","")
     endif

function change_memotxt(cData)
   cData = STRTRAN(cData, "m²", "m2")
   cData = STRTRAN(cData, '//', '<br>')
   cData = STRTRAN(cData, '|', '<br>')
   cData = STRTRAN(cData, '·', '')
   cData = STRTRAN(cData, 'Â', '')
   cData = STRTRAN(cData, 'ú', '')
   cData = STRTRAN(cData, 'ë', '&#235')
   cData = STRTRAN(cData, ';', ' ')
   cData = STRTRAN(cData, '"', '')
   cData = STRTRAN(cData, 'é', '&eacute;') //    &#233;
   cData = STRTRAN(cData, 'è', '&#232;')
   cData = STRTRAN(cData, '®', '')
   //cData = StrTran(cData, CRLF , "<br>")

return cData