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> >>