Information générale
Titre:
Xmltocursor losing spaces in text field
Versions des environnements
Network:
Windows 2003 Server
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement