Forum Discussion

Deleted's avatar
Deleted
Jun 11, 2018

Converting csv to columns

Hi,

 

I have used PowerShell to extract a list of files, with information on file name, creation date, owner, directory etc. The data comes out in a csv file and I would like to split the data into columns.

I have tried to use 'text to columns', using a comma as the delimiter. However, some of the files have commas in the file name, so for these files the data is separated too many times and placed in the wrong columns.

Is there a way to fix this? I can't go through the entire list and correct the file names, since I have 150.000 lines in my list.

1 Reply

  • Steven Correy's avatar
    Steven Correy
    Copper Contributor
    Tough one without looking at an example. The data is all stored in one column?

Resources