# What is the Gtok Pattern for this xml

**URL:** <https://discuss.elastic.co/t/what-is-the-gtok-pattern-for-this-xml/147263>\
**Category:** Elasticsearch\
**Created:** [September 4, 2018, 7:35pm UTC](https://discuss.elastic.co/t/what-is-the-gtok-pattern-for-this-xml/147263 "2018-09-04T19:35:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![satish161418](https://avatars.discourse-cdn.com/v4/letter/s/35a633/32.png) [@satish161418](https://discuss.elastic.co/u/satish161418)\
**Post date:** [September 4, 2018, 7:35pm UTC](https://discuss.elastic.co/t/what-is-the-gtok-pattern-for-this-xml/147263/1 "2018-09-04T19:35:33Z")

</div>

SOURCE MESSAGEJMS Message In : \<?xml version="1.0" encoding="UTF-8" standalone="yes"?\>\<\> A001 59619 94 579 2018-08-05T23:55:18 2018-08-05T23:55:18 2018-08-05 pmanagb8 USD 480 2018-08-05T23:55:18 pcms:PCMSTransactionpcms:BuildNumber3.106.0.0\</pcms:BuildNumber\> pcms:OnlineStatus0\</pcms:OnlineStatus\> pcms:TransactionType52\</pcms:TransactionType\> pcms:WorkstationLocationDT\</pcms:WorkstationLocation\> pcms:ExternalSystempcms:SequenceNumber59619940480018080552\</pcms:SequenceNumber\> \</pcms:ExternalSystem\> wag:RFN59619940480018080552\</wag:RFN\> wag:CashierEmployeeID090909\</wag:CashierEmployeeID\> wag:CashierNumber131\</wag:CashierNumber\> \</pcms:PCMSTransaction\>

above is an xml in which i need the whole xml under one name like IN\_MESSAGE and then i need seperate 3 line having RetailStoreID, ReceiptNumber,UnitID seperately.

Like below

"In\_Message":  
[["\<?xml version="1.0" encoding="UTF-8" standalone="yes"?\>\<\> A001 59619 94 579 2018-08-05T23:55:18 2018-08-05T23:55:18 2018-08-05 pmanagb8 USD 480 2018-08-05T23:55:18 pcms:PCMSTransactionpcms:BuildNumber3.106.0.0\</pcms:BuildNumber\> pcms:OnlineStatus0\</pcms:OnlineStatus\> pcms:TransactionType52\</pcms:TransactionType\> pcms:WorkstationLocationDT\</pcms:WorkstationLocation\> pcms:ExternalSystempcms:SequenceNumber59619940480018080552\</pcms:SequenceNumber\> \</pcms:ExternalSystem\> wag:RFN59619940480018080552\</wag:RFN\> wag:CashierEmployeeID090909\</wag:CashierEmployeeID\> wag:CashierNumber131\</wag:CashierNumber\> \</pcms:PCMSTransaction\> "]  
]  
,  
"RetailStoreID": [  
[  
"59619"  
]  
],  
"ReceiptNumber": [  
[  
"480"  
]  
],  
"UnitID": [  
[  
"A001"  
]  
], }

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 2, 2018, 7:35pm UTC](https://discuss.elastic.co/t/what-is-the-gtok-pattern-for-this-xml/147263/2 "2018-10-02T19:35:46Z")

</div>

Closed on October 2, 2018, 7:35pm UTC

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.