Fix jumbled CSV files - 200 Files of 200K records each - 40Million total

Hi There, Please share one sample data so we can review and confirm the method to split for 200K details Thanks Mirth

Respected Sir, Will u like to export the information again in a proper way to make it readable? Regards Pankaj Garg

HI i saw your project and i really apreciate it. First, before i start to work with you i need to see the files you're talking about so i can estimate what the project takes. Thank you.

Hello I suggest to automate the process with a script implemented in java i used to do this many times before if you are interested then feel free to contact me over chat Thank you

hi i'm expert in webscrap and database strucre and xml and csv files. ------------------------------------------------- ---------------------------------------------------- trust me I do best

Hi, As you exported your database in 200 CSV files and it's showing all data in one column. I will surely help you in this to arrange the data properly and will guide you how to do that for reset of the files. Please give me this opportunity to work with you. Thanks, Peter

Hi, can you share the 200k file please? Just to check if I'm able to split in columns. Probably is better if I proceed with remaining files if I can adjust first 200k. Regards, Ilirjan

Fix csv Hello, I'm a professional software developer with vast experience working with csv files. I can easily fix your problem. For further information feel free to contact me. With regards, Julian Katzwinkel

Hi there, I am an experienced database administrator and programmer. I can write a custom script depending upon the type of data on the CSV file to correctly display the information. Please contact for further discussion. Thanks and regards!!!

Hi friend . I can do your work . to export file from a MYSQL database with php (web page) . we can discuss more in chat .

Hi, If you could provide a few sample lines I could take a look and see what are the options. It sounds like the delimiter is wrong (so it is tab not a comma, or 3 blank or ….). I am presuming you are wanting/trying to open the files in Excel and there is a data import tool that might help you although for 200+ files I wouldn't recommend it as after the first 3 you will get bored and frustrated! If there is a way to identify each column correctly in the file then we can either do a search/replace in any old text editor or create a small application (I prefer C# but open to other languages) that parses the files into a valid CSV for you. Kind regards, Chris

Hi, This is David. I’m a new freelancer and I’m interested to take up your project. I’m capable of doing your project and deliver you the best quality results. Please check my profile and ping me if you’re interested to assign me the work. Money is no criteria and I can support until you satisfied with the result. Thanks, David.

Hi, What application do you use to open its .csv file ...? If you wish, can you send 1 sample file to me ...? For a few lines (10/20 lines) I want to see its file structure, whether using space or comma separator...

I've spent time doing something like this similar on some of my downtime at my current company please hit me up if you are looking for some help getting this done hope to hear from you soon.

Can write a small app for you to have all the files converted instead of just doing one, This way you can just point the application to the files and have all your files fixed.