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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HuaMin ChenProblem resolverCommented:
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
Divya ThakurProject engineerAuthor Commented:
What else I can do if I don't have to use ms excel.is there any other way
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.