converting a text file into csv

Dear sir,
i am facing a problem regarding conversion of tab separated text file into csv file. in my text file i have millions of entries and each entry consists of many fields such as first name , last name , address, contact number etc. and some fields are also missing in some of entries.Now i have to convert this text file into csv file . Can you please guide me in right direction. I will be obliged.
Divya ThakurProject engineerAsked:
Who is Participating?
 
Jignesh JainSr. Oracle Apps DBACommented:
Then it is better to go with MS-Excel. If you have 2010 Office or above , it things will be easy. Just define the delimit things as "space".
0
 
HuaMin ChenSystem AnalystCommented:
Hi,
Is there any fixed format to your Text file? Is relevant fields in fixed position? If yes, you can load such Text file into Excel, and further save Excel file into a csv format file.
0
 
Jignesh JainSr. Oracle Apps DBACommented:
Try to open your text file in excel or you import your file in Excel. Then you can save it  in csv format.
1
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Divya ThakurProject engineerAuthor Commented:
What else I can do if I don't have to use ms excel.is there any other way
0
 
Jignesh JainSr. Oracle Apps DBACommented:
Then you can use Linux Vi Editor if you have. There you can get it done in xml or csv format.
0
 
Divya ThakurProject engineerAuthor Commented:
I have to read a txt file that is space separated and then convert into CSV in golan
0
 
John TsioumprisSoftware & Systems EngineerCommented:
If  "golan" means "golang" a simple Google search will "reveal" a ton of ways to handle your issue.
0
 
EirmanChief Operations ManagerCommented:
If you don't have Excel try Open Office (which is free)

If your data is "tab separated" use tab as the delimiter.

I think you will have to manually go through all your data and fill in the blanks (with a delimiter)
where fields are blank.
0
 
Divya ThakurProject engineerAuthor Commented:
It will be a cumbersome task to replace all spaces with delimiter, Because there are millions of entries.
0
 
EirmanChief Operations ManagerCommented:
We need more information - What program is the data in at the moment - does it have an export option?

If it's tab separated text at present and you have tabs in empty fields you
can do it all automatically with excel.
You will need a good 64 bit PC with plenty of memory.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.