You misunderstood the message. See at the end

>I have to turn the ITEM_SECTION /ITEM_SECTION into 5 records, but I can't seem to be able to create the right schema file.
>Is it possible...can someone show me how to do that?
>Please note that I replaced the open tag with a "|", and the close tag with a "~" so I could post it.

He is asking how to parse this XML and the XML is the actual XML only changed for posting here.

>

>lcXML=CHRTRAN(lcData,"|~","<>")
>

>
>MartinaJ
>
>>Hi All,
>>
>>A customer has presented me with an XML file like the one below:
>>
>>|VFPData~
>> |dbftemp~
>> |EXPCONTACT~I:0#\NEOGIS01|/EXPCONTACT~
>> |CUST_2~NOC|/CUST_2~
>> |REFERENCE~NOC160128-080200|/REFERENCE~
>> |INV_DATE~2016-01-28|/INV_DATE~
>> |EXPORTER~TestCode|/EXPORTER~
>> |SHIPNAME~|/SHIPNAME~
>> |ITEM~
>> |ItemsSections~
>>
>>|ItemSection~|ItemSection_Item~SUJITH1234|/ItemSection_Item~|ItemSection_Quantity~30|/ItemSection_Quantity~|ItemSection_ItemBatchNo~|/ItemSection_ItemBatchNo~|ItemSection_NoOfBatches~123|/ItemSection_NoOfBatches~|ItemSection_ItemsPackagingDetails~|/ItemSection_ItemsPackagingDetails~|ItemSection_NoOfContainers~1|/ItemSection_NoOfContainers~|ItemSection_Therapeutic~Test;Test;test;Test|/ItemSection_Therapeutic~|ItemSection_FieldContainer~|/ItemSection_FieldContainer~|ItemSection_Hidden~0|/ItemSection_Hidden~|ItemSection_ItemContainer~|/ItemSection_ItemContainer~|/ItemSection~
>>
>>|ItemSection~|ItemSection_Item~SUJITH1234|/ItemSection_Item~|ItemSection_Quantity~30|/ItemSection_Quantity~|ItemSection_ItemBatchNo~|/ItemSection_ItemBatchNo~|ItemSection_NoOfBatches~123|/ItemSection_NoOfBatches~|ItemSection_ItemsPackagingDetails~|/ItemSection_ItemsPackagingDetails~|ItemSection_NoOfContainers~1|/ItemSection_NoOfContainers~|ItemSection_Therapeutic~Test;Test;test;Test|/ItemSection_Therapeutic~|ItemSection_FieldContainer~|/ItemSection_FieldContainer~|ItemSection_Hidden~0|/ItemSection_Hidden~|ItemSection_ItemContainer~|/ItemSection_ItemContainer~|/ItemSection~
>>
>>|ItemSection~|ItemSection_Item~TestCode|/ItemSection_Item~|ItemSection_Quantity~2|/ItemSection_Quantity~|ItemSection_ItemBatchNo~|/ItemSection_ItemBatchNo~|ItemSection_NoOfBatches~2|/ItemSection_NoOfBatches~|ItemSection_ItemsPackagingDetails~|/ItemSection_ItemsPackagingDetails~|ItemSection_NoOfContainers~1|/ItemSection_NoOfContainers~|ItemSection_Therapeutic~test;test;test;test|/ItemSection_Therapeutic~|ItemSection_FieldContainer~|/ItemSection_FieldContainer~|ItemSection_Hidden~0|/ItemSection_Hidden~|ItemSection_ItemContainer~|/ItemSection_ItemContainer~|/ItemSection~
>>
>>|ItemSection~|ItemSection_Item~TestCode|/ItemSection_Item~|ItemSection_Quantity~10|/ItemSection_Quantity~|ItemSection_ItemBatchNo~|/ItemSection_ItemBatchNo~|ItemSection_NoOfBatches~2|/ItemSection_NoOfBatches~|ItemSection_ItemsPackagingDetails~|/ItemSection_ItemsPackagingDetails~|ItemSection_NoOfContainers~2|/ItemSection_NoOfContainers~|ItemSection_Therapeutic~test;test;test;test|/ItemSection_Therapeutic~|ItemSection_FieldContainer~|/ItemSection_FieldContainer~|ItemSection_Hidden~0|/ItemSection_Hidden~|ItemSection_ItemContainer~|/ItemSection_ItemContainer~|/ItemSection~
>>
>>|ItemSection~|ItemSection_Item~SUJITH1234|/ItemSection_Item~|ItemSection_Quantity~1|/ItemSection_Quantity~|ItemSection_ItemBatchNo~|/ItemSection_ItemBatchNo~|ItemSection_NoOfBatches~2|/ItemSection_NoOfBatches~|ItemSection_ItemsPackagingDetails~|/ItemSection_ItemsPackagingDetails~|ItemSection_NoOfContainers~3|/ItemSection_NoOfContainers~|ItemSection_Therapeutic~test;test;test;test|/ItemSection_Therapeutic~|ItemSection_FieldContainer~|/ItemSection_FieldContainer~|ItemSection_Hidden~0|/ItemSection_Hidden~|ItemSection_ItemContainer~|/ItemSection_ItemContainer~|/ItemSection~
>>
>> |/ItemsSections~
>> |/ITEM~
>> |COMMENTS2~TestName TestBriefDescr;TestName TestDetail1;TestName TestDetail2;TestName TestDetail3|/COMMENTS2~
>> |PACKING~5|/PACKING~
>> |OCEAN~250|/OCEAN~
>> |SHPUM~TS TSD|/SHPUM~
>> |ENTRYDATE~2016-01-28|/ENTRYDATE~
>> |DETAILS2~TestName TestBriefDescr;TestName TestDetail1;TestName TestDetail2;TestName TestDetail3|/DETAILS2~
>> |MAN_PROC~TestName TestBriefDescr;TestName TestDetail1;TestName TestDetail2;TestName TestDetail3|/MAN_PROC~
>> |DOMESTIC~2|/DOMESTIC~
>> |INSURANCE~2|/INSURANCE~
>> |ASSIST~100|/ASSIST~
>> |FABRIC_CO~test mfg|/FABRIC_CO~
>> |YARN_CO~Test|/YARN_CO~
>> |SHIPPERSBN~\\FileShare\graphics\Images\imagename\test|/SHIPPERSBN~
>> |BUYERSBN~\\FileShare\graphics\Images\imagename\test|/BUYERSBN~
>> |FIBRE_CO~test|/FIBRE_CO~
>> |ISONUMBER~Test|/ISONUMBER~
>> |COMMISSION~10|/COMMISSION~
>> |DESC~TestCode|/DESC~
>> |CRTN~SUJITH1234|/CRTN~
>> |FACILITY~\\FileShare\graphics\Images\imagename\test|/FACILITY~
>> |EXPORT_CAR~TestFirstName TestMiddleName TestLastName |/EXPORT_CAR~
>> |PORT_ENTRY~TestCode|/PORT_ENTRY~
>> |HSCode~|/HSCode~
>> |MEAS~|/MEAS~
>> |CUSTOMER~SUJITH1234|/CUSTOMER~
>> |CUSTNAME~TestCode|/CUSTNAME~
>> |MISC~150|/MISC~
>> |email_address~|/email_address~
>> |/dbftemp~
>>|/VFPData~
>>
>>I have to turn the ITEM_SECTION /ITEM_SECTION into 5 records, but I can't seem to be able to create the right schema file.
>>Is it possible...can someone show me how to do that?
>>Please note that I replaced the open tag with a "|", and the close tag with a "~" so I could post it.
>>Thanks.
>>
>>Luke