I have an xml as given below. I want to extract all xml tags found between each #NEWPAGE# tag and save them separately to a sql sever database. Please suggest an approach.
Initially, I had a txt file containing the below detail but I thought of converting each line of the file into an xml tag line. Now, that I have an xml file. I'm not able to extract portion of the xml based on node value #NEWPAGE#.
XML content is as follows:
<?xml version="1.0" encoding="utf-8"?> <root> <Line>#HEADINGBEGIN#</Line> <Line></Line> <Line>Employee: 16062 Name: MERZLAK,BRIAN Base: MSP Eqpt: E70 Pos: CA</Line> <Line></Line> <Line> Daily On Off Daily Daily Jr Accum</Line> <Line>Date Assign Duty Duty TAFB Block Credit Trip Guarantee Man Credit</Line> <Line>----- ------ ----- ----- ----- ----- ------ --------------- ---- ------</Line> <Line>#HEADINGEND#</Line> <Line>11/01 M2100A 0:01 0:00 4:35 0:00 0:00 0:00 0:00 </Line> <Line>11/02 " 0:00 7:17 0:00 0:00 0:00 0:00 </Line> <Line>11/03 " 19:12 67:12 6:51 20:14 0:00 0:00 20:14 </Line> <Line>#GROUPNOBREAK#</Line> <Line>#GROUPBEGIN#</Line> <Line></Line> <Line> Taxable TAFB 0:00 </Line> <Line> Non-Taxable TAFB 178:00 </Line> <Line> Total TAFB 178:00 </Line> <Line>#GROUPEND#</Line> <Line>#NEWPAGE#</Line> <Line>#HEADINGBEGIN#</Line> <Line></Line> <Line>Employee: 19814 Name: GRAYSON,MONIQUE Base: LAX Eqpt: E70 Pos: CA</Line> <Line></Line> <Line> Daily On Off Daily Daily Jr Accum</Line> <Line>Date Assign Duty Duty TAFB Block Credit Trip Guarantee Man Credit</Line> <Line>----- ------ ----- ----- ----- ----- ------ --------------- ---- ------</Line> <Line>#HEADINGEND#</Line> <Line>11/01 OFF 0:00 0:00 0:00 0:00 0:00 0:00 </Line> <Line>11/02 OFF 0:00 0:00 0:00 0:00 0:00 0:00 </Line> <Line>11/03 L2488 13:30 0:00 7:10 0:00 0:00 0:00 0:00 </Line> <Line>11/04 " 0:00 4:25 0:00 0:00 0:00 0:00 </Line> <Line>#GROUPNOBREAK#</Line> <Line>#GROUPBEGIN#</Line> <Line></Line> <Line> Taxable TAFB 0:00 Over Guar: 17:08</Line> <Line> Non-Taxable TAFB 327:29 </Line> <Line> Total TAFB 327:29 </Line> <Line>#GROUPEND#</Line> <Line>#NEWPAGE#</Line> <Line>#HEADINGBEGIN#</Line> <Line></Line> <Line>Employee: 20730 Name: ZAHN,GEOFFREY Base: SEA Eqpt: E70 Pos: CA</Line> <Line></Line> <Line> Daily On Off Daily Daily Jr Accum</Line> <Line>Date Assign Duty Duty TAFB Block Credit Trip Guarantee Man Credit</Line> <Line>----- ------ ----- ----- ----- ----- ------ --------------- ---- ------</Line> <Line>#HEADINGEND#</Line> <Line>11/01 OFF 0:00 0:00 0:00 0:00 0:00 0:00 </Line> <Line>11/02 OFF 0:00 0:00 0:00 0:00 0:00 0:00 </Line> <Line>11/03 S2088 10:02 0:00 6:47 0:00 0:00 0:00 0:00 </Line> <Line>#GROUPNOBREAK#</Line> <Line>#GROUPBEGIN#</Line> <Line></Line> <Line> Taxable TAFB 9:25 Over Guar: 0:53</Line> <Line> Non-Taxable TAFB 122:30 </Line> <Line> Total TAFB 131:55 </Line> <Line>#GROUPEND#</Line> </root>
No comments:
Post a Comment