convert txt or log file into csv format
Answers
Answer:
Need to convert a logfile that will have some information into a csv format.
Sample Data:
Output:
Info type: PERSON_NAME; Count: 25
Info type: LOCATION; Count: 25
Info type: CREDIT_CARD_NUMBER; Count: 2
Info type: EMAIL_ADDRESS; Count: 150
Info type: US_VEHICLE_IDENTIFICATION_NUMBER; Count: 20
Info type: MALE_NAME; Count: 13
Info type: LAST_NAME; Count: 85
Info type: DOMAIN_NAME; Count: 150
Info type: SSN; Count: 1000
Explanation:
please mark as brainliest
Answer:
Open Excel and create a new spreadsheet.
2. Select the Data tab.
3. On the far right, click “Get External Data”, then select the “From Text” option.
4. Find the TXT file on your computer and click “Open”.
5. In the first step of the Import Wizard, select “Delimited”.
6. Below the area where you selected delimited, make sure to select that your data has headers (check the box) then click next.
7. In the second step, select “Tab” if you’re working with the Amazon All Products Report, or “Comma” if you’re using another file. The best way to tell is to take a look at the contents of the file and see how they’re divided. If there is just a bunch of space between one field and another, then Tab is the right choice. If you look at the file and there are commas after each entry, then Comma is the right choice. If you’re still unsure, you can send it to our Customer Support team and we’ll be more than happy to help.
8. Click Next.
9. In the third step, review and make sure no changes need to be made. Then click Finish.
10. On the Import Data window that comes up, click OK.
Excel will then display your data in the spreadsheet. You may then review it and make any adjustments to the data you need to.
When you save it, please be sure to save it as a CSV file.
mark as brainlist.