Hi all, I constructed a .map file to pull data from XML file, but I found it is impossible for me to include content in embedded tags. (i.e. if I have something like <P>(b) <E T="03">Purpose</E> Test test</P> , I can only get ''Test test'', the italicized 'Purpose' would not be included. this is the .Map file I created (partial), I am able to pull the italicized words (content in tag <E></E>) in a separate column but that is not what I need. I need everything within a <P></P> be pulled together and in order. Would that be possible ? <TABLE name = "Section1"> <TABLE-PATH syntax="XPATH"> /CFRDOC/TITLE/CHAPTER/PART/SECTION/P </TABLE-PATH> <COLUMN name="SECTNO" retain = "YES"> <PATH> /CFRDOC/TITLE/CHAPTER/PART/SECTION/SECTNO </PATH> <TYPE> character </TYPE> <DATATYPE> string </DATATYPE> <LENGTH> 1000 </LENGTH> </COLUMN> <COLUMN name="SUBJECT" retain = "YES"> <PATH> /CFRDOC/TITLE/CHAPTER/PART/SECTION/SUBJECT </PATH> <TYPE> character </TYPE> <DATATYPE> string </DATATYPE> <LENGTH> 1000 </LENGTH> </COLUMN> <COLUMN name="Topic"> <PATH> /CFRDOC/TITLE/CHAPTER/PART/SECTION/P/E </PATH> <TYPE> character </TYPE> <DATATYPE> string </DATATYPE> <LENGTH> 1000 </LENGTH> </COLUMN> <COLUMN name="Clause"> <PATH> /CFRDOC/TITLE/CHAPTER/PART/SECTION/P </PATH> <TYPE> character </TYPE> <DATATYPE> string </DATATYPE> <LENGTH> 5000 </LENGTH> </COLUMN> </TABLE> Following is the sample XML, I have also attached the sample XML if anyone is interested in writing a .map file to pull data.. Please please share your insight and I am really appreciate your help on this. <?xml version="1.0" encoding="UTF-8"?> <CFRDOC xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="CFRMergedXML.xsd"> <AMDDATE>Jan. 1, 2018</AMDDATE> <TITLE> <CHAPTER> <PART> <SECTION> <SECTNO>§ 1.1</SECTNO> <SUBJECT>Authority, purpose, scope, and reservation of authority.</SUBJECT> <P>(a) <E T="03">Authority.</E> This part is issued pursuant to 12 U.S.C. 1 <E T="03">et seq.,</E> 12 U.S.C. 24 (Seventh), and 12 U.S.C. 93a.</P> <P>(b) <E T="03">Purpose</E> This part prescribes standards under which national banks may purchase, sell, deal in, underwrite, and hold securities, consistent with the authority contained in 12 U.S.C. 24 (Seventh) and safe and sound banking practices.</P> <P>(c) <E T="03">Scope.</E> The standards set forth in this part apply to national banks and Federal branches of foreign banks.Further, pursuant to 12 U.S.C. 335, State banks that are members of the Federal Reserve System are subject to the same limitations and conditions that apply to national banks in connection with purchasing, selling, dealing in, and underwriting securities and stock. In addition to activities authorized under this part, foreign branches of national banks are authorized to conduct international activities and invest in securities pursuant to 12 CFR part 211.</P> <P>(d) <E T="03">Reservation of authority.</E> The OCC may determine, on a case-by-case basis, that a national bank may acquire an investment security other than an investment security of a type set forth in this part, provided the OCC determines that the bank's investment is consistent with 12 U.S.C. section 24 (Seventh) and with safe and sound banking practices. The OCC will consider all relevant factors, including the risk characteristics of the particular investment in comparison with the risk characteristics of investments that the OCC has previously authorized, and the bank's ability effectively to manage such risks. The OCC may impose limits or conditions in connection with approval of an investment security under this subsection. Investment securities that the OCC determines are permissible in accordance with this paragraph constitute eligible investments for purposes of 12 U.S.C. 24.</P> <CITA>[61 FR 63982, Dec. 2, 1996, as amended at 73 FR 22235, Apr. 24, 2008]</CITA> </SECTION> </PART> </CHAPTER> </TITLE> </CFRDOC>
... View more