Jeff,
Look into using RegExp like shown, for example, here
Re: RegEx interface Thread #
1323910 Message #
1323919You should try to figure the pattern yourself. (Carriage return followed by the
</GLNOTES>
Or just verify that both GLNOTES and /GLNOTES are on the same line using VFP functions.
>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>
>
>
>TIA
>
>Jeff
If it's not broken, fix it until it is.
My Blog