CODEWITHSUNDEEP
databasecsv
Andrew Jouffray
Andrew Jouffray

Reputation: 11

CSV database column edit

I usually have more code oriented questions, but I need help with a CSV database. Basically I need to change it's format to Fname;Lname;email. The problem is that I have 13000 rows and all of the data is in 1 column, the separator is ";". I used different CSV file editors and all of them put the data in 1 column, so I can't change the order of those columns... i cannot re-extract the data from the original database. So is there a fix to that, or am I screwed?

So I am starting with a CSV file, that has ";" between each data cell in each rows. So I open Excel 2016 and I do: data > from text > I find the CSV file > I click on delimited ";", start import on row 1, file origin: Windows (ANSI) > delimiter: ";" > column data format: "General" > finish. And I get all the data in 1 column...

Upvotes: 0

Views: 79

Answers (1)

John M.
John M.

Reputation: 307

If I understand you...

You could use excel and a vb macro to do the shuffling for you. Split by ';' and put each row in an array, shuffle, and then concatenate?

You can also change the column break when importing a csv in excel.

Upvotes: 1

Related Questions