How to get column names and corresponding column values

[Rahul]

“Received,Carrier,Tracking number,Status,Locker Number,Delivered,Delivered to,Recipient,Recipient location,Package location,Sender,Comments,Arrived damaged,Modified By,Job ID Test,Bin,Department,PO Number,Class 3 name,Recipient: Po number,Recipient: TEST Field,Recipient: ADDRESS,Recipient: Department,Sender: Po number,Sender: TEST Field,Sender: ADDRESS,Sender: Department\r\n"Sep 24, 2020 11:24 AM”,PB4362\t,Inventory,GAIL G WEISHAAR,“Syracuse, 87, 20074”,No,QA Enrerprise,\r\n"Sep 24, 2020 12:34 PM",TA09800\t,Active,NEIL O WINTERS,“Knoxville, 67, 20030”,The iam atjl lasnalks.,No,QA Enrerprise,\r\n"Oct 14, 2020 6:03 PM",SHEHEHSHBEE\t,Active,Ahmednagar,No,QA Enrerprise,\r\n"

[marjan_karafilo]

Hi @Rahul ,

Could you please give some more information about what kind of data is the one that you posted?
Where are the column names? Can you split the data?

Regards,
Marjan

[Rahul]

How to Get column names and values for these columns from the below set of data.

[
{
“entity”: “Received,Carrier,Tracking number,Status,Locker Number,Delivered,Delivered to,Recipient,Recipient location,Package location,Sender,Comments,Arrived damaged,Modified By,Job ID Test,Bin,Department,PO Number,Class 3 name,Recipient: Po number,Recipient: TEST Field,Recipient: ADDRESS,Recipient: Department,Sender: Po number,Sender: TEST Field,Sender: ADDRESS,Sender: Department\r\n"Sep 24, 2020 11:24 AM",PB4362\t,Inventory,GAIL G WEISHAAR,"Syracuse, 87, 20074",No,QA Enrerprise,\r\n"Sep 24, 2020 12:34 PM",TA09800\t,Active,NEIL O WINTERS,"Knoxville, 67, 20030",The iam atjl lasnalks.,No,QA Enrerprise,\r\n"Oct 14, 2020 6:03 PM",SHEHEHSHBEE\t,Active,Ahmednagar,No,QA Enrerprise,\r\n"Oct 15, 2020 5:13 AM",SACH-13\t,Active,Ahmednagar,No,QA Enrerprise,\r\n"Aug 27, 2021 3:17 PM",DHL,PB1591\t,Received,ADRIAN EDIT PREBIL,"San Diego, 37, 20041",Achalpur,jolly ,No,Admin User,Option 1,1234,po1,test1,address1,PO9349,test data,Danbury,\r\n"Sep 15, 2021 1:56 PM",PB14X1008\t,Received,Addd receipient,Achalpur,Angad ,No,QA Enrerprise,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Sep 15, 2021 1:56 PM",PB14X1009\t,Received,Addd receipient,Achalpur,Angad ,No,QA Enrerprise,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Sep 15, 2021 2:53 PM",PB1616\t,Delivered,"Sep 15, 2021 2:53 PM",Addd receipient,"Achalpur, 1, MSC 1-21",No,QA Enrerprise,\r\n"Sep 15, 2021 2:54 PM",PB1615\t,Delivered,"Sep 15, 2021 2:54 PM",Addd receipient,"Achalpur, 1, MSC 1-21",No,QA Enrerprise,\r\n"Sep 15, 2021 2:54 PM",PB1614\t,Delivered,"Sep 15, 2021 2:54 PM",Addd receipient,"Achalpur, 1, MSC 1-21",No,QA Enrerprise,\r\n"Sep 15, 2021 3:18 PM",DHL,PB1617\t,Checkpoint,TES ,"Adoni, 70, 20202",Angad ,"Comment for package tracking number PB1617\nSep 15, 2021 3:26:18 PM: Common comment for all 3 packages\nSep 15, 2021 3:35:09 PM: Comment for PB1617 and PB1618",Yes,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Sep 15, 2021 3:20 PM",Amazon,PB1618\t,Delivered,"Sep 15, 2021 3:51 PM",Tom Jerry,Tom Jerry,Nabadwip,Karin Steiner,New comment for the package,Yes,QA Enrerprise,Option 1,1234,\r\n"Sep 15, 2021 3:22 PM",USPS,PB1619\t,Delivered,"Sep 15, 2021 3:26 PM",BALDEV S PAVLOVICH,ALVIN D MCNAMARA,"Sterling Heights, 57, 20021","Grand Rapids, 62, 20062",rahul ,"Package comments for PB1619\nSep 15, 2021 3:26:18 PM: Common comment for all 3 packages",Yes,QA Enrerprise,Option 1,1234,\r\n"Sep 15, 2021 7:41 PM",PB1621\t,Received,"Adityapur, 59, 20192",No,QA Enrerprise,Option 1,1234,\r\n"Sep 17, 2021 2:37 PM",Amazon,PB1623\t,Delivered,"Sep 20, 2021 2:05 PM",ALLAN Q PULS,SHELLY B POSLUSZNY,"Reno, 7, 20082","Hollywood, 59, 20032",Adddd recipient,"Comments for tracking PB1623\nNew line comments for PB1623\nSep 17, 2021 3:05:48 PM: Comments for multiple delivery of 3 packages\nNew line comments for the 3 packages\nSep 17, 2021 3:36:16 PM: New Comments for the new delivery\nSep 20, 2021 1:50:27 PM: 9/20/2021 comments\nSep 20, 2021 2:05:46 PM: Next line Comments",Yes,QA Enrerprise,Option 1,1234,\r\n"Sep 17, 2021 2:40 PM",FedEx,PB1624\t,Delivered,"Sep 20, 2021 2:05 PM",ALLAN Q PULS,ADRIAN EDIT PREBIL,"San Diego, 37, 20041","Hollywood, 59, 20032",dddddddddddd ,"Comments for tracking PB1624\nNew line for tracking PB1624\nSep 17, 2021 3:05:48 PM: Comments for multiple delivery of 3 packages\nNew line comments for the 3 packages\nSep 17, 2021 3:36:16 PM: New Comments for the new delivery\nSep 20, 2021 1:50:27 PM: 9/20/2021 comments\nSep 20, 2021 2:05:46 PM: Next line Comments",No,QA Enrerprise,Option 1,1234,po1,test1,address1,\r\n"Sep 17, 2021 2:45 PM",DHL,PB1625\t,Delivered,"Sep 20, 2021 2:05 PM",ALLAN Q PULS,ALVIN M OEHLERT,"Anchorage, 94, 20011","Hollywood, 59, 20032",gty ,"Comments for PB1625\nNew Line comments for ticket PB1625\nSep 17, 2021 3:05:48 PM: Comments for multiple delivery of 3 packages\nNew line comments for the 3 packages\nSep 17, 2021 3:36:16 PM: New Comments for the new delivery\nSep 20, 2021 1:50:27 PM: 9/20/2021 comments\nSep 20, 2021 2:05:46 PM: Next line Comments",Yes,QA Enrerprise,Option 2,1238,\r\n"Sep 17, 2021 6:26 PM",DHL,PB1626\t,Delivered,"Sep 17, 2021 6:29 PM",Addd receipient,Addd receipient,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Sep 20, 2021 8:21 PM",FedEx,PB1630\t,Received,Ahmedabad,No,QA Enrerprise,Option 1,1234,\r\n"Sep 20, 2021 8:22 PM",PB1631\t,Received,Dhuri,No,QA Enrerprise,Option 1,1234,\r\n"Sep 20, 2021 8:22 PM",Amazon,PB1632\t,Received,Dhuri,No,QA Enrerprise,Option 1,1234,\r\n"Sep 20, 2021 10:50 PM",PB1144\t,Received,Minneapolis,No,QA Enrerprise,Option 1,Pete’s Stuff,1234,\r\n"Sep 21, 2021 4:52 PM",PB1643\t,Delivered,"Sep 21, 2021 4:57 PM",ALLAN Q PULS,"Hollywood, 59, 20032","Sep 21, 2021 4:52:09 PM: Commets for multiple deliver package\nSep 21, 2021 4:57:23 PM: Nw comments for myltiple delivery",No,QA Enrerprise,\r\n"Sep 21, 2021 4:52 PM",PB1642\t,Delivered,"Oct 21, 2021 10:53 AM",Achalpur,"Sep 21, 2021 4:52:09 PM: Commets for multiple deliver package\nSep 21, 2021 4:57:23 PM: Nw comments for myltiple delivery",No,QA Enrerprise,\r\n"Sep 21, 2021 4:52 PM",FedEx,PB1641\t,Delivered,"Sep 21, 2021 4:57 PM",ALLAN Q PULS,ALVIN D MCNAMARA,"Sterling Heights, 57, 20021","Hollywood, 59, 20032",dddddddddddd ,"Sep 21, 2021 4:52:09 PM: Commets for multiple deliver package\nSep 21, 2021 4:57:23 PM: Nw comments for myltiple delivery",No,QA Enrerprise,\r\n"Sep 21, 2021 5:45 PM",Amazon,PB1645\t,Received,Minneapolis,No,QA Enrerprise,Option 1,Bin 3,Science,1234,\r\n"Sep 22, 2021 6:05 PM",New carrier royal update,PB1646\t,Received,ADRIANE P DUEKER,"Bridgeport, 26, 20007","Achalpur, 1, MSC 1-21",Jamwal ,Checking the recent carrier delete,No,QA Enrerprise,Option 1,1234,A1-100,MLSC,"Kalari, Kerala",\r\n"Sep 23, 2021 11:02 AM",FedEx,PB1652\t,Received,No,QA Enrerprise,Option 1,1234,\r\n"Sep 23, 2021 11:08 AM",DHL,PB1653\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Sep 23, 2021 9:06 PM",FedEx,PB1657\t,Received,323196 ,Dhuri,Jamwal ,No,QA Enrerprise,Option 1,1234,A1-100,MLSC,"Kalari, Kerala",\r\n"Sep 23, 2021 11:41 PM",PB1658\t,Received,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Sep 24, 2021 2:37 PM",1234567890!@#$%^&*()_+<>?:,PB1660\t,Received,Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Sep 24, 2021 5:34 PM",FedEx,794969322779\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Sep 24, 2021 5:36 PM",USPS,9405510200793188602222\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Sep 24, 2021 5:43 PM",839EHHEOE9HRBI\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Sep 27, 2021 3:02 PM",FedEx,PB1661\t,Received,ANDREW M HENEBERRY,"Fresno, 45, 20036",Adityapur,No,QA Enrerprise,Option 1,1234,\r\n"Sep 27, 2021 5:18 PM",FedEx,794689582464\t,Received,Tom Jerry,Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Sep 28, 2021 1:35 PM",FedEx,SDASDASDASD\t,Delivered,"Sep 28, 2021 1:35 PM",ALLAN Q PULS,"Hollywood, 59, 20032",Hollywood,No,QA Enrerprise,Option 1,1234,\r\n"Sep 28, 2021 6:40 PM",adasdggg,PB16X1007\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Sep 28, 2021 7:59 PM",FedEx,PB1664\t,Received,323196 ,Achalpur,Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Sep 28, 2021 8:54 PM",Amazon,PB1665\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Sep 28, 2021 9:18 PM",PB1666\t,Received,Moreno Valley,No,QA Enrerprise,Option 1,1234,\r\n"Sep 28, 2021 9:18 PM",FedEx,PB1667\t,Received,jyoti gupta,"Adilabad, 72, 20278","Moreno Valley, 19",sddadasda,No,Admin User,Option 1,1234,\r\n"Sep 29, 2021 4:01 PM",FedEx,794616818333\t,Received,Peter Griffin,Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 4:02 PM",FedEx,123456712345678\t,Received,Attn Tom Smith,Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 4:09 PM",FedEx,774799508835\t,Received,Transaction ProcessingCanadian,Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 4:10 PM",USPS,9474814222222222007720\t,Received,Achalpur,No,Admin User,Option 1,1234,\r\n"Sep 29, 2021 4:10 PM",UPS,1ZE9F9566600024777\t,Received,Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 6:12 PM",UPS,PB1670\t,Received,ALLAN Q PULS,"Hollywood, 59, 20032",Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 6:12 PM",FedEx,PB1671\t,Received,Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 6:48 PM",FedEx,A/C\t,Received,323196 ,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 6:50 PM",A/123\t,Received,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Sep 29, 2021 6:50 PM",A/124\t,Active,Nagaon,f,No,QA Enrerprise,\r\n"Sep 30, 2021 1:00 PM",FedEx,PB1675\t,Received,ADRIENNE J CUMMINGS,"Grand Rapids, 10, 20025","Adoni, 70, 20202",dddddddddddd ,hello,No,QA Enrerprise,Option 1,1234,\r\n"Sep 30, 2021 1:48 PM",FedEx,PB1677\t,Delivered,"Sep 30, 2021 1:51 PM",Adilabad,test,No,QA Enrerprise,Option 1,1234,\r\n"Sep 30, 2021 1:53 PM",UPS,PB1679\t,Received,TERRENCE N JACKNEWITZ,"Cedar Rapids, 48, 20012",Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Sep 30, 2021 2:07 PM",FedEx,PB1680\t,Received,Joe Shmoe,"Adoni, 70, 20202","Adityapur, 59, 20192",Angad ,qaaa,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 5, 2021 4:31 PM",FedEx,PB1686\t,Received,Kapil 33,Achalpur,Angad ,No,QA Enrerprise,Option 1,1234,123,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 7, 2021 5:52 PM",FedEx,PB1688\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 8, 2021 2:10 PM",FedEx,PB1694\t,Received,ADRIAN EDIT PREBIL,"San Diego, 37, 20041",Achalpur,Angad ,sdasdas,No,QA Enrerprise,Option 1,Test123,1234,po1,test1,address1,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 8, 2021 3:59 PM",FedEx,PB1695\t,Received,Anchorage,No,QA Enrerprise,Option 1,1234,\r\n"Oct 8, 2021 4:01 PM",UPS,PB1696\t,Received,Adilabad,No,Admin User,Option 1,1234,\r\n"Oct 11, 2021 7:07 PM",FedEx,PB1698\t,Delivered,"Oct 11, 2021 7:07 PM",323257 323257,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 12, 2021 3:37 PM",9622015420008000255900000000000000\t,Received,Achalpur,No,QA Enrerprise,\r\n"Oct 12, 2021 3:37 PM",1009986544641536198000000000000000\t,Received,Achalpur,No,QA Enrerprise,\r\n"Oct 12, 2021 3:38 PM",1001921374250002160100000000000000\t,Received,Achalpur,No,QA Enrerprise,\r\n"Oct 12, 2021 3:55 PM",Staples,00000123455555555558\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 12, 2021 4:50 PM",FedEx,PB1699\t,Checkpoint,No,QA Enrerprise,Option 1,1234,\r\n"Oct 12, 2021 4:59 PM",FedEx,PB1701\t,Checkpoint,Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 11:47 AM",Amazon,PB1702\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 14, 2021 11:51 AM",Amazon,PB1703\t,Received,jyoti gupta,"Adilabad, 72, 20278",Adilabad,updated comment,No,Admin User,Option 1,1234,\r\n"Oct 14, 2021 12:26 PM",FedEx,PB1704\t,Received,jyoti gupta,"Adilabad, 72, 20278",Adilabad,rahul ,No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 1:43 PM",FedEx,PB1705\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 14, 2021 1:43 PM",DHL,PB1706\t,Received,WRAY J PIKE,"Salem, 99, 20075",Adilabad,Karin Steiner,No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 1:49 PM",FedEx,PB1707\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 1:50 PM",DHL,PB1708\t,Received,jyoti gupta,"Adilabad, 72, 20278",Adilabad,Karin Steiner,No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 2:25 PM",DHL,PB1709\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 3:13 PM",DHL,PB1710\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 3:16 PM",DHL,PB1711\t,Received,ANTHONY C SANFILIPPO,"Denver, 55, 20072",Achalpur,Rajat New User,hello,No,QA Enrerprise,Option 1,1234,\r\n"Oct 14, 2021 4:11 PM",9612019000000000000000\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 18, 2021 2:54 PM",Amazon,PB1712\t,Received,323257 323257,"Adityapur, 59, 20192",jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 18, 2021 2:55 PM",USPS,PB1713\t,Received,"Adityapur, 59, 20192",No,QA Enrerprise,Option 1,1234,\r\n"Oct 18, 2021 3:27 PM",Amazon,PB1714\t,Received,jyoti gupta,"Adilabad, 72, 20278",Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Oct 18, 2021 3:27 PM",USPS,PB1715\t,Received," ",Adilabad,Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 18, 2021 3:27 PM",Amazon,PB1716\t,Received,BRYAN F JACKNEWITZ,"Wichita, 52, 20023",Adilabad,Jamwal ,No,QA Enrerprise,Option 1,1234,A1-100,MLSC,"Kalari, Kerala",\r\n"Oct 18, 2021 3:28 PM",DHL,PB1717\t,Received,323257 323257,Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Oct 18, 2021 4:56 PM",Amazon,PB1718\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",No,QA Enrerprise,Option 1,1234,\r\n"Oct 18, 2021 5:22 PM",Amazon,PB1719\t,Received,jyoti gupta,"Adilabad, 72, 20278","Adityapur, 59, 20192",Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 19, 2021 2:43 PM",DHL,PB1722\t,Received,DEBBIE U UMBECK,"Kent, 12, 20045",Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 2:43 PM",Amazon,PB1723\t,Received,ADRIANE P DUEKER,"Bridgeport, 26, 20007",Achalpur,SSX ,Package delivery by a deactivated user,No,Adam Milne,Option 1,1234,\r\n"Oct 20, 2021 4:06 PM",USPS,PB1724\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:06 PM",Amazon,PB1725\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:06 PM",USPS,PB1726\t,Received,Adam Milne,Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:06 PM",Amazon,PB1727\t,Received,Adam Milne,Achalpur,Jamwal ,asdas,No,QA Enrerprise,Option 1,1234,A1-100,MLSC,"Kalari, Kerala",\r\n"Oct 20, 2021 4:07 PM",USPS,PB1728\t,Received,Adam Milne,Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:07 PM",DHL,PB1729\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:07 PM",USPS,PB1730\t,Received,DAVIS C FRANKEN,"Jersey City, 98, 20001",Achalpur,Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 20, 2021 4:07 PM",DHL,PB1731\t,Received,Adam Milne,Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:08 PM",USPS,PB1732\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:08 PM",DHL,PB1733\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:09 PM",USPS,PB1734\t,Received,Adam Milne,Achalpur,Jamwal ,No,QA Enrerprise,Option 1,1234,A1-100,MLSC,"Kalari, Kerala",\r\n"Oct 20, 2021 4:09 PM",Amazon,PB1735\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:09 PM",USPS,PB1736\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:09 PM",Amazon,PB1737\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:09 PM",DHL,PB1738\t,Received,Adam Milne,Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:10 PM",USPS,PB1739\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:10 PM",DHL,PB1740\t,Received,323257 323257,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:10 PM",USPS,PB1741\t,Received,323257 323257,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:11 PM",DHL,PB1742\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:11 PM",USPS,PB1743\t,Received,Mystery Mail,Research Required,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:11 PM",DHL,PB1744\t,Received,HURSEL F OBST,"Philadelphia, 13, 20097",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:11 PM",USPS,PB1745\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:12 PM",DHL,PB1746\t,Received,DESMOND T FUNK,"Charleston, 92, 20064",Achalpur,asdasda,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:12 PM",USPS,PB1747\t,Received,PERNELLA G FUGEL,"Anaheim, 51, 20058",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:12 PM",DHL,PB1748\t,Received,MICHELE O LAFFOLD,"Orlando, 88, 20069",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:12 PM",USPS,PB1749\t,Received,RAMESH F SCHULZ,"Thornton, 32, 20046",Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:13 PM",DHL,PB1750\t,Received,MARCIA H SANDER,"San Antonio, 11, 20019",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:13 PM",DHL,PB1751\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:13 PM",DHL,PB1752\t,Received,VICKIE M ALDENDERFER,"Springfield, 48, 20026",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:14 PM",Amazon,PB1753\t,Received,pulkit anchalia,Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:14 PM",USPS,PB1754\t,Received,TRICIA H JAKOVICH,"San Bernardino, 47, 20093",Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:14 PM",DHL,PB1755\t,Received,TINA V ROUGGLY,"Amarillo, 35, 20070",Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:14 PM",USPS,PB1756\t,Received,TRICIA H JAKOVICH,"San Bernardino, 47, 20093",Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:15 PM",Amazon,PB1757\t,Received,SHYAMOLIKA F SHRODES,"Orlando, 41, 20003",Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 4:15 PM",DHL,PB1758\t,Received,MISCHA A PASCHKE,"Seattle, 29, 20049",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:31 PM",DHL,PB1759\t,Received,RAMESH F SCHULZ,"Thornton, 32, 20046",Achalpur,Jamwal ,No,QA Enrerprise,Option 1,1234,A1-100,MLSC,"Kalari, Kerala",\r\n"Oct 20, 2021 4:32 PM",Amazon,PB1760\t,Received,ROSS L RAINWATER,"Henderson, 12, 20060",Achalpur,Karin Steiner,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:32 PM",DHL,PB1761\t,Received,SONIK CHOPRA,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Oct 20, 2021 4:33 PM",Amazon,PB1762\t,Received,WRAY J PIKE,"Salem, 99, 20075",Achalpur,Walmart corporate,No,QA Enrerprise,Option 1,1234,Kuth,\r\n"Oct 20, 2021 4:33 PM",USPS,PB1763\t,Received,WRAY J PIKE,"Salem, 99, 20075",Achalpur,Walmart corporate,No,QA Enrerprise,Option 1,1234,Kuth,\r\n"Oct 20, 2021 4:33 PM",Amazon,PB1764\t,Received,WRAY J PIKE,"Salem, 99, 20075",Achalpur,Jamwal ,No,QA Enrerprise,Option 1,1234,A1-100,MLSC,"Kalari, Kerala",\r\n"Oct 20, 2021 4:33 PM",Staples,PB1765\t,Received,TERRENCE N JACKNEWITZ,"Cedar Rapids, 48, 20012",Achalpur,jolly ,No,QA Enrerprise,Option 1,1234,PO9349,test data,Danbury,\r\n"Oct 20, 2021 7:29 PM",ANDREWSIGNATURE\t,Delivered,"Oct 20, 2021 7:29 PM",Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Oct 21, 2021 6:41 PM",PB1766\t,Delivered,"Oct 21, 2021 6:41 PM",Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Oct 21, 2021 6:41 PM",PB1767DFADF\t,Delivered,"Oct 21, 2021 6:41 PM",Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Oct 21, 2021 6:41 PM",PB176834234234\t,Delivered,"Oct 21, 2021 6:41 PM",Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Oct 26, 2021 3:17 PM",Staples,PP11123\t,Received,323257 323257,No,QA Enrerprise,Option 1,1234,\r\n"Oct 26, 2021 3:22 PM",PB1769\t,Received,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Oct 26, 2021 3:31 PM",PB1770\t,Received,HILLARY B WESTBROOKS,"Syracuse, 5, 20095",Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 26, 2021 4:11 PM",PB112233\t,Received,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Oct 26, 2021 4:16 PM",Staples,PB1771\t,Received,323196 ,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Oct 26, 2021 5:31 PM",GSO,POPPB1680111\t,Received,323196 ,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 26, 2021 5:35 PM",DHL,909090\t,Received,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 2:11 PM",FedEx,99111\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 2:14 PM",FedEx,TA99111\t,Received,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 2:19 PM",DHL,TA909090\t,Received,Adam Milne,Adoor,Angad ,next,No,QA Enrerprise,Option 1,123,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Oct 27, 2021 3:23 PM",DHL,PB1772\t,Received,323196 ,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 4:49 PM",FedEx,PB1773\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 5:13 PM",DHL,PB1774\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 5:40 PM",FedEx,PB1776\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 5:45 PM",Amazon,PB1777\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Oct 27, 2021 8:43 PM",FedEx,PB1778\t,Received,ADRIAN EDIT PREBIL,"San Diego, 37, 20041",Achalpur,Custom sender,Custom comments,No,QA Enrerprise,Option 1,1234,po1,test1,address1,\r\n"Oct 28, 2021 6:30 PM",GSO,PB1779\t,Received,323196 ,Nagaon,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 3:25 PM",FedEx,PB1784\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 3:47 PM",FedEx,PB1785\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 3:48 PM",FedEx,PB1786\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 4:07 PM",FedEx,PB1787\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 4:45 PM",FedEx,PB1791\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 4:49 PM",FedEx,PB1792\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 4:56 PM",FedEx,PB1793\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 5:00 PM",FedEx,PB1794\t,Received,323196 ,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 5:30 PM",GSO,PB1795\t,Received,323196 ,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 5:33 PM",FedEx,PB1796\t,Received,Adam Milne,Adoor,No,Admin User,Option 1,1234,\r\n"Nov 1, 2021 6:14 PM",DHL,PB1797\t,Received,323196 ,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 1, 2021 9:30 PM",DHL,PB1800\t,Delivered,"Nov 1, 2021 9:32 PM",New Recipient,New Recipient,Nagaon,Whatever,No,QA Enrerprise,Option 1,1234,\r\n"Nov 8, 2021 2:00 PM",DHL,PB1809\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 8, 2021 2:06 PM",DHL,PB1811\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 8, 2021 2:26 PM",DHL,PB1813\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 8, 2021 2:28 PM",FedEx,PB1814\t,Received,323196 ,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 8, 2021 2:29 PM",FedEx,PB1815\t,Received,Adam Milne,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 9, 2021 6:22 PM",PB1825\t,Delivered,"Nov 9, 2021 6:22 PM",Addd receipient,Achalpur,"Nov 9, 2021 6:22:52 PM: jkhdkfjhsdkjh",No,QA Enrerprise,\r\n"Nov 9, 2021 6:22 PM",PB1824\t,Delivered,"Nov 9, 2021 6:22 PM",Addd receipient,Achalpur,"Nov 9, 2021 6:22:52 PM: jkhdkfjhsdkjh",No,QA Enrerprise,\r\n"Nov 9, 2021 6:22 PM",PB1823\t,Delivered,"Nov 9, 2021 6:22 PM",Addd receipient,Achalpur,"Nov 9, 2021 6:22:52 PM: jkhdkfjhsdkjh",No,QA Enrerprise,\r\n"Nov 9, 2021 6:23 PM",GSO,PB1826\t,Attempted," ",Adilabad,etsy ,dfhkjfdfhkjsdh,No,QA Enrerprise,Option 1,1234,\r\n"Nov 12, 2021 6:01 PM",DHL,PB1827\t,Received,Adam Milne,"Achalpur, 1, MSC 1-21",jolly ,dgjhsgdjdsg,No,Admin User,Option 1,1234,PO9349,test data,Danbury,\r\n"Nov 12, 2021 6:02 PM",uber,PB1828\t,Received,ADRIENNE J CUMMINGS,"Grand Rapids, 10, 20025","Achalpur, 1",Karin Steiner,No,Admin User,Option 1,1234,\r\n"Nov 12, 2021 6:04 PM",Amazon,PB1830\t,Received," ","Achalpur, 1",Karin Steiner,No,Admin User,Option 1,1234,\r\n"Nov 15, 2021 1:58 PM",PB1834\t,Received,"Achalpur, 1, MSC 1-21",No,QA Enrerprise,Option 1,1234,\r\n"Nov 15, 2021 5:52 PM",01 32 {)> 49 0340 0200 02 02082021 1Z1235556600000009 01 P 0271996001 3 1.0 LBS 0.0 P/P 1000.00 USD T1 R 09 CA P 03 2 IN47 04 SH SENDSUITE XPRESS SHELTON CT 67840 US 123555 1 ANY STREET DINESH 234/323-4235 04 ST THE HORSE-AND-A-HALF RANC\t,Received,Achalpur,No,Admin User,\r\n"Nov 16, 2021 6:52 PM",GSO,PB1838\t,Received,jyoti gupta,"Adilabad, 72, 20278",Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Nov 16, 2021 8:04 PM",FedEx,PB1840\t,Attempted,jyoti gupta,"Adilabad, 72, 20278","Adilabad, 72, 20278",No,QA Enrerprise,Option 1,1234,\r\n"Nov 17, 2021 5:39 PM",GSO,PB1851\t,Received,No,QA Enrerprise,Option 1,1234,\r\n"Nov 17, 2021 6:11 PM",FedEx,PB1854\t,Received,323257 323257,Nahan,dddddddddddd ,test,No,QA Enrerprise,Option 1,1234,\r\n"Nov 17, 2021 7:51 PM",PB1856\t,Received,Nabadwip,No,QA Enrerprise,Option 1,1234,\r\n"Nov 17, 2021 7:52 PM",PB1857\t,Received,Muvattupuzha,No,QA Enrerprise,Option 1,1234,\r\n"Nov 17, 2021 9:42 PM",adasdggg,PB1858\t,Received,Nizamabad,No,QA Enrerprise,Option 1,1234,\r\n"Nov 18, 2021 4:41 PM",FedEx,PB1859\t,Received,"Achalpur, 1, Office 120",No,QA Enrerprise,Option 1,1234,\r\n"Nov 18, 2021 5:00 PM",FedEx,PB1861\t,Received,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 2:17 PM",FedEx,524740270000267\t,Received,Achalpur,No,Admin User,Option 1,1234,\r\n"Nov 23, 2021 2:20 PM",PB16X1011\t,Received,Achalpur,No,Admin User,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1167\t,Delivered,"Nov 30, 2021 1:37 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1168\t,Delivered,"Nov 23, 2021 5:06 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1169\t,Delivered,"Nov 23, 2021 5:06 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1170\t,Delivered,"Nov 30, 2021 12:48 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1171\t,Delivered,"Nov 23, 2021 5:06 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1172\t,Delivered,"Nov 23, 2021 5:06 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1173\t,Delivered,"Nov 23, 2021 5:06 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:06 PM",PB1X1174\t,Delivered,"Nov 30, 2021 12:49 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:17 PM",PB1X1189\t,Delivered,"Dec 1, 2021 7:49 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:17 PM",PB1X1190\t,Delivered,"Nov 30, 2021 2:12 PM",Addd receipient,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 23, 2021 5:17 PM",PB1X1191\t,Delivered,"Dec 2, 2021 4:18 PM",Addd receipient,"Achalpur, 1",New comment,No,QA Enrerprise,Option 1,1234,\r\n"Nov 24, 2021 6:00 PM",adasdggg,PB1864\t,Delivered,"Nov 24, 2021 6:00 PM",Adam Smith,Adam Smith,Adoor,No,QA Enrerprise,Option 1,1234,\r\n"Nov 24, 2021 8:11 PM",PB1866\t,Received,"Dhuri, 20",No,QA Enrerprise,Option 1,1234,\r\n"Nov 25, 2021 3:34 PM",PB16X1012\t,Received,Achalpur,No,Admin User,\r\n"Nov 25, 2021 3:44 PM",FedEx,794697471543\t,Received,Ando XAdapter,Achalpur,No,Admin User,Option 1,1234,\r\n"Nov 25, 2021 3:53 PM",UPS,1Z077837YW25798203\t,Received,Achalpur,No,Admin User,\r\n"Nov 25, 2021 3:54 PM",UPS,420009813#65&&/\t,Received,Achalpur,No,Admin User,\r\n"Nov 29, 2021 3:34 PM",adasdggg,PB1868\t,Delivered,"Nov 29, 2021 3:34 PM",Kapil 33,Kapil 33,Dibrugarh,No,QA Enrerprise,Option 1,1234,123,\r\n"Nov 29, 2021 3:34 PM",FedEx,PB1869\t,Received,Kapil 33,Nizamabad,No,QA Enrerprise,Option 1,1234,123,\r\n"Nov 29, 2021 6:02 PM",Amazon,PB1870\t,Received,"Achalpur, 1, Office 120",No,Admin User,Option 1,1234,\r\n"Nov 29, 2021 6:40 PM",PB1873\t,Received,"Achalpur, 1, Office 120",No,Admin User,Option 1,1234,\r\n"Nov 29, 2021 6:40 PM",UPS,PB1874\t,Received,Adam Milne,"Achalpur, 1, Office 120",No,QA Enrerprise,Option 1,1234,\r\n"Nov 29, 2021 7:55 PM",PB1876\t,Received,Adam Milne,"Adilabad, 72",Custom sender,jkfhsdkjhjhgyhyguygyhjhhjh,No,QA Enrerprise,Option 1,1234,\r\n"Nov 30, 2021 6:03 PM",DHL,PB1878\t,Delivered,"Nov 30, 2021 6:04 PM",Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Nov 30, 2021 6:37 PM",DHL,PB1879\t,Checkpoint,Adam Smith,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Nov 30, 2021 6:43 PM",PB1880\t,Checkpoint,Achalpur,asdasd,No,Admin User,Option 1,1234,\r\n"Nov 30, 2021 6:45 PM",DHL,PB1881\t,Received,323257 323257,"Adilabad, 72",Custom sender,jhkjhjkh,No,Admin User,Option 1,1234,\r\n"Dec 1, 2021 7:56 AM",DHL,PB1884\t,Delivered,"Dec 1, 2021 8:15 AM",323196 ,Adam Milne,Achalpur,Custom sender,test12,Yes,QA Enrerprise,Option 1,1234,\r\n"Dec 1, 2021 12:25 PM",PB16X1014\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Dec 1, 2021 12:26 PM",PB1885\t,Received,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Dec 1, 2021 12:26 PM",DHL,PB1886\t,Received,Adam Milne,Achalpur,Custom sender,tyftguj,No,QA Enrerprise,Option 1,1234,\r\n"Dec 1, 2021 1:25 PM",FedEx,PB1889\t,Received,"Adoni, 70",jgjghkjhk,No,QA Enrerprise,Option 1,1234,\r\n"Dec 1, 2021 3:25 PM",PB1891\t,Received,Achalpur,No,Admin User,Option 1,1234,\r\n"Dec 1, 2021 3:26 PM",FedEx,PB1893\t,Received,Achalpur,No,Admin User,Option 1,1234,\r\n"Dec 1, 2021 7:40 PM",FedEx,PB1896\t,Checkpoint,Adam Milne,Achalpur,Angad ,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Dec 1, 2021 7:50 PM",PB1897\t,Delivered,"Dec 1, 2021 7:50 PM",Adilabad,No,QA Enrerprise,Option 1,1234,\r\n"Dec 1, 2021 7:56 PM",DHL,PB1900\t,Attempted,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Dec 2, 2021 12:15 PM",Amazon,PB1902\t,Delivered,"Dec 14, 2021 2:13 PM",Adam Milne,Achalpur,"Admin user comments 5th checkpoint status comment (Edited comments for attempted status)\nRefused status… RTM… Reqiures research\n1st delivery, 2nd delivery attempthhfkjhdjfgduf",Yes,QA Enrerprise,Option 1,Math,1234,\r\n"Dec 2, 2021 6:25 PM",PB1907\t,Delivered,"Dec 2, 2021 6:25 PM",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Dec 2, 2021 6:27 PM",PB1909\t,Delivered,"Dec 2, 2021 6:30 PM",Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Dec 2, 2021 8:38 PM",CHECKPOINTSIG1\t,Checkpoint,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Dec 2, 2021 8:45 PM",CHECKPOINTSIG2\t,Checkpoint,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n"Dec 9, 2021 3:23 PM",Amazon,PB1917\t,Checkpoint,Adam Smith,Adam Milne,Nahan,Angad ,test,No,QA Enrerprise,Option 1,1234,P0W3R,BeachSide,"Somewhere , Iskinda",\r\n"Dec 14, 2021 12:37 PM",Amazon,PB1919\t,Delivered,"Dec 14, 2021 12:38 PM",alan smith,alan smith,"Adilabad, 72, 20278","Achalpur, 1, Office 120",No,QA Enrerprise,Option 1,1234,\r\n"Dec 14, 2021 12:48 PM",Amazon,PB1920\t,Delivered,"Dec 14, 2021 12:50 PM",alan smith,"Achalpur, 1, Office 120",No,QA Enrerprise,Option 1,1234,\r\n"Dec 14, 2021 1:08 PM",Amazon,PB101010\t,Received,Adam Milne,Achalpur,No,QA Enrerprise,Option 1,1234,\r\n”

}
]

[viktor_n]

Hi @Rahul,

First of all, sample data that you provided is not a valid json.
It looks like you have just copied the csv data and pasted it in a entity field.

I’ve worked only with data what is in entity as a text file, not json.
Here is input data.

And here is to where I came.

First I split the string data by "\r\n" or in other words, it will split by line.
After that again I am splitting each element by ",", and now we will have all columns.
In first element are headers, all other are data.

Problem now is, how can I find out which element from the data is for which header, because in data I have fewer elements then in headers.

The only way that I see to solve this is to set some patter on each header and when data from data field is corresponding to that pattern, to go under that header.

Lets say that you have made it with patters, the problem here will be that this solution will work by predictions, and because will work by predictions someday will make a mistake.

Maybe would mismatch the data from header, we do not want that to happen.
Another problem with patterns would be that for some headers you can’t set patters, for example Comments header, I don’t see here what patter will be compatible, when in comments can come anything.

Regards,
Viktor

[Rahul]

Data I am getting from RestGet snap and Column names are below.

Received,Carrier,Tracking number,Status,Locker Number,Delivered,Delivered to,Recipient,Recipient location,Package location,Sender,Comments,Arrived damaged,Modified By,Job ID Test,Bin,Department,PO Number,Class 3 name,Recipient: Po number,Recipient: TEST Field,Recipient: ADDRESS,Recipient: Department,Sender: Po number,Sender: TEST Field,Sender: ADDRESS,Sender: Department

Values : “Sep 24, 2020 11:24 AM”,PB4362\t,Inventory,GAIL G WEISHAAR,“Syracuse, 87, 20074”,No,QA Enrerprise,\r\n"Sep 24, 2020 12:34 PM”,TA09800\t,Active,NEIL O WINTERS,“Knoxville, 67, 20030”,The iam atjl lasnalks.,No,QA Enrerprise,\r\n"Oct 14, 2020 6:03 PM",SHEHEHSHBEE\t,Active,Ahmednagar,No,QA Enrerprise,\r\n"