Unanswered: Load data to MySql with varying comma delimited data
I have a (CDR) text data file delimited by commas. Each entry varies from 20 to 37 entries per line. How do I insert this data into a MySql database and make sure each field is always placed in the same column?
I would paste Line 1 into Excel so you get all the fields you need and then paste Line 2 into the appropriate columns. Then I would use concantonate to pull it back into the format I need. Copy from Excel to notepad and save.