Get a Array from E-mail, how to slice array and transfer to csv table?

(0) Share

Report

Posted on by Andrewlu81

I have get use xpath to get data from E-mail body, it is a array, how to slice array and transfer to csv table to save sharepoint?

Step:

1. When received E-mail from sb, it should read E-mail body, and transfer to xml and use xpath to get data------Have finished.

[ "Right subassy VI", "1", "1", 
 S2-sub function test", "3", "0",
 "Left side VI", "0", "0",
 "Right side VI", "0", "0",
 "S3-ARF", "4", "3",
 "S4 IMU CAL", "0", "0",
 "S5-Acoustic test", "78", "13",
 "S6-Listening test", "6", "6",
 "S7-Reflash", "7", "0",
 "S8-Final Function", "0", "0",
 "Product Functional Inspection", "0", "0",
 "Clamping force test", "2", "1",
 "S9 Lock", "5", "1",
 "FVI Vedder", "1", "1",
 "FVI2", "1", "1",
 "OBA", "0", "0"
]

2. Step1 output is array, I need transfer table. how to do?