INeed to read an xml that contains some strange char

[MarcoBoschi]

Hi,
I found some strange characters in a xml file that I have to read to populate a dbf table.
I'm sure that the person who typed in his program insert this

OSS - BULK REPAIR
and not this
OSS – BULK REPAIR

but unfortunately his export program create this xml

Code: Select all  Expand view

<?xml version="1.0" encoding="utf-8"?>
<SERVICE_TYPES>
   <item>
      <SERVICE_TYPE>2002</SERVICE_TYPE>
      <DESCRIPTION>OSS – BULK REPAIR</DESCRIPTION>
   </item>
</SERVICE_TYPES>
 

And I have to read it for populate my dbf table

How can I transform xml file in order to obtain (for instance)

OSS - BULK REPAIR
and not
OSS – BULK REPAIR


This is another piece of the same xml you can note that there are not strange characters

Code: Select all  Expand view

   <item>
      <SERVICE_TYPE>1102</SERVICE_TYPE>
      <DESCRIPTION>SWAP-OPTICAL ENGINE(EEE)</DESCRIPTION>
   </item>
 

Many thanks

[cnavarro]

Try with hb_StrToUtf8

[MarcoBoschi]

I've tried but ...nothing!
I've just asked to my partner why there are these characters.
The presence of these characters in a field in a table dbf can cause problems
Many thanks

[Rick Lipkin]

Marco

Just a quick thought .. if you know what you are looking for, could you not use the StrTran() function to locate and replace them out of your text ?

Code: Select all  Expand view

cDesc := "OSS – BULK REPAIR"

cText := StrTran( cDesc, "–", "-")   // cText should resolve down to "OSS - BULK REPAIR"
 

The above code is not that elegant, but should give you the result you are looking for ..

Rick Lipkin

[MarcoBoschi]

Yes Rick,
I my opinion a field that contains "OSS - BULK REPAIR" and another that contains "OSS ÔÇô BULK REPAIR"
field->codice = "OSS - BULK REPAIR"
field->descri = "OSS ÔÇô BULK REPAIR"
? field->codice <> field->descri
I hoped was a problem related to unicode or something like that

I wait the response of their programmer

[MarcoBoschi]

Solved!
I'm waiting a for a file without those characters
Bye

[reinaldocrespo]

For what's worth, for that type of situation I usually recur to the CharOnly() function.

CharOnly()
Removes all characters but the specified ones from a string

Syntax
CharOnly( <cRemaining>, <cString> ) --> cResult

Arguments
<cRemaining>
This character string defines the characters that are to remain in the result string.
<cString>
This is the character string to process. Return
The function removes all characters from <cString> except those contained in <cRemaining> and returns the result.

So in this case you could simply say:

cText := CharOnly( [ABCDEFGHJKLMNOPQRSTVWXYZ0123456789-abcdefghijklmnopqrstvwxyz], cText )

Hope that helps.

Reinaldo.

[MarcoBoschi]