General information
Category:
Coding, syntax & commands
Title:
Parsley, sage, rosemary
Environment versions
Network:
Windows Server 2016
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only