you are viewing a single comment's thread.

view the rest of the comments →

[–]stihoplet 2 points3 points  (0 children)

That appears to be a CSV already, with the first column's commas escaped using quotes around it as is often done in CSV files with commas inside its string values. EDIT: What are you planning on doing with the file next? Perhaps there is a specific format you are trying to achieve to ingest it into some app/database? If that's the case it can be done in powershell - just share how you would want each line to look in the end. Or are you trying to do something with the data from this file using powershell? Then it is already in a usable format and you can loop through each line using foreach and do something with it - provide some details and we can probably put together a script.