Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best Way To Parse Memo
Message
 
 
À
09/07/2009 21:35:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01411324
Message ID:
01411364
Vues:
58
Hi Jeff,

You don't need to parse memo to check for that condition
lcOpenTag = "<GLNOTES>"
lcCloseTag = "</GLNOTES>"
IF ATLINE(lcOpenTag, mymemo) <> ATLINE(lcCloseTag, mymemo)
  * The opne an closing tags not on the same line
ENDIF
>I'm working with an accounting application that stores it GL notes as XML. I'm not sure why but it's causing a lot of problems if there is a carriage return in the wrong place. The first example below is the correct format. The second example reflects what it looks like with the extra carriage return. I think if I can find all of the records that don't have the GLNOTES tags on the same line they will be easy to correct. What's the best way for me to find the records that meet this condition?
>
>
><?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
><VFPDATA>
><GLTDES>
><GLNOTES> PaidOuts - 01/06/2008              </GLNOTES>  
></GLTDES>
></VFPDATA>
>
>
>
><?xml version = "1.0" encoding="Windows-1252" standalone="yes"?>
><VFPDATA>
><GLTDES>
><GLNOTES> PaidOuts - 01/06/2008              
></GLNOTES>  
></GLTDES>
></VFPDATA>
>
>
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform