Export Data with AD
Hi expert,
I have a question related to AD export data to CSV. I'm using AD Manage Plus and create a report with 4 columns: SAMS Account, Custom Field, Email, Modify Date. When I exported data to CSV program automatically add 2 more column S.No. My questions:
Report Data:
SAMS | SAMS | Email | Modify Date |
1001 | 1001 | 1001@SUNTORYPEPSICO.VN | 29-09-2021 12:00 |
1002 | 1002 | 1002@suntorypepsico.vn | 29-09-2021 13:00 |
CSV exported data:
S.No | SAMS | SAMS | Email | Modify Date |
1 | 1001 | 1001 | 1001@suntorypepsico.vn | 29-09-2021 12:00 |
| 2 | 1002 | 1002 | 1002@suntorypepsico.vn | 29-09-2021 13:00 |
The result expected:
1. Remove S.No column
2. Having double quote for each data, instead of 1001,1001,1001@suntorypepsico.vn,20-09-2021 12:00, I'm expected result: "1001","1001","1001@suntorypepsico.vn","20-09-2021 12:00""
Can you help to export data like this?