Hi Geeks,
I need to pick a csv file which has the field names in the first row. But the data starts from line 2.
The file looks as follows
Shipment Date,Airline Carrier Code (DHL),Mode,Airline Carrier Number,Freight Airway Bill Number,Origin,Destination,Service Center,Weight,Weigt Unit of Measure,Pieces,Total Value
8/5/2007,AS,D,27,12345678,JFK,SEA,JFK,1234567.12,LB,10,1234567.21
I am getting the payload as below.
- <ns:MT_CAL_DW_MULTI xmlns:ns="http://PurchOrder">
- <CAL_PO>
<shipment_date>Shipment Date</shipment_date>
<airline_carrier_code>Airline Carrier Code (DHL)</airline_carrier_code>
<mode>Mode</mode>
<airline_carrier_number>Airline Carrier Number</airline_carrier_number>
<freight_airway_billnumber>Freight Airway Bill Number</freight_airway_billnumber>
<origin>Origin</origin>
<destination>Destination</destination>
<service_center>Service Center</service_center>
<weight>Weight</weight>
<weight_unit_of_messure>Weigt Unit of Measure</weight_unit_of_messure>
<pieces>Pieces</pieces>
<total_value>Total Value</total_value>
</CAL_PO>
- <CAL_PO>
<shipment_date>8/5/2007</shipment_date>
<airline_carrier_code>AS</airline_carrier_code>
<mode>D</mode>
<airline_carrier_number>27</airline_carrier_number>
<freight_airway_billnumber>12345678</freight_airway_billnumber>
<origin>JFK</origin>
<destination>SEA</destination>
<service_center>JFK</service_center>
<weight>1234567.12</weight>
<weight_unit_of_messure>LB</weight_unit_of_messure>
<pieces>10</pieces>
<total_value>1234567.21</total_value>
</CAL_PO>
</ns:MT_CAL_DW_MULTI>
Here the requirement is that the communication channel should ignore the first row which contains the field names and should start reading from line 2.
It would be a great help if some body can throw light that how this can be achieved.
Thanks,
Noorul