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"

[j_angelevski]

Hi @Rahul,

Can you explain which are the values and which are the columns in this data set ? It’s really hard to read and I don’t know what are the columns/values here. Are there any delimiters here ? Because this looks like a comma separated string. There has to be some type of delimiter to split the data.

[Rahul]

Hi,
Below are column names.
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