H Lucien,
For future, use tag
<pre> </pre>
For current your problem, you can use MSXML DOM or STREXTRACT()
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