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?
Topic Participants
Hai
Venkatesh M
New to M365 Manager Plus?
New to M365 Manager Plus?
New to RecoveryManager Plus?
New to RecoveryManager Plus?
New to Exchange Reporter Plus?
New to Exchange Reporter Plus?
New to SharePoint Manager Plus?
New to SharePoint Manager Plus?
New to ADManager Plus?