Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Xmltocursor losing spaces in text field
Message
De
15/12/2011 12:52:43
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
XML, XSD
Titre:
Xmltocursor losing spaces in text field
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2003 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01531126
Message ID:
01531126
Vues:
72
Hi
I am using XMLTOCURSOR and am having a problem with text entries being mangled. I suspect this is something to do with user-entry input forms allowing the user to use the |enter| key to move down lines in memo-style fields. But I have no control over this - I just have to work with what I am being sent in the XML file.

Please bear with me whilst I try to explain it as simply as I can! (I will use the pipe symbol rather than the greater-than and less-than signs for the tag delimiters)

One of the tags is called |message|. Below is a single example. In order to display it here, I have copied if from the xml file as displayed in a web-brower and then pasted it:

|message|Dear Brian, Thank you so much for generously agreeing to swap shifts. This means a lot to me and you've really done me the biggest favour. I appreciate it :) Simon|/message|

If I paste it to a text file and then re-paste it here, it has the following format:

"|message|Dear Brian, Thank you so much

for generously agreeing to swap

shifts. This means a lot to me and

you've really done me the biggest

favour. I appreciate it :)



Simon |/message|"


When I run XMLTOCURSOR against the XML file, the message field contains:

"Dear Brian, Thank you so muchfor generously agreeing to swapshifts. This means a lot to me andyou've really done me the biggestfavour. I appreciate it :)Simon


Which has resulted in 3 extra spaces after the salutation, and the running together of the words which occur at the end and beginning of adjacent lines. Looking at the vesion from the text file the 3 extra spaces can be seen. This may not be apparent on-screen but they ARE there!

The running together of the lines is not so easily explained as there is an intervening line between the text lines - XMLTOCURSOR seems to strip out all blank lines and CRLF characters.

I have looked through the nFlags parameter for XMLTOCURSOR and tried various cominations but none seem to fix it. Can anyone give me any pointers as to what I am overlooking?

Tks
Barry Sutton.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform