how to create a Tab Delimited CSV?

excel csv export tab-delimited
user1563414 picture user1563414 · Aug 7, 2012 · Viewed 45.8k times · Source

I need to produce a Tab Delimited CSV of a query pulled from a mySql database. I am using MySQL Query Browser to extract the data as ordenery CSV.

Does anyone know how to convert an ordinery -- comma seperated -- CSV into a Tab Delimited. I can't find a way to do it in nither Excel nor Open Office.

Manny thanks!

p.s. I'm working on a windows 7 machine.

Answer

Oday Mansour picture Oday Mansour · Aug 7, 2012

Linux?

sed 's/,/\t/g' commaDelimited > tabDelimited

Windows?

Open notepad, press TAB, select and copy the tab space. Open the CSV in notepad, Edit->Replace... fill , in the first box and paste your tab in the second box and just Replace All.

Related questions

What is the best mime-type and extension to use when exporting tab delimited?

I've come across the problem where Excel will not play nice with UTF-8 encoded CSV files. See this related question on Stack Overflow. I've followed the solution of exporting as UTF-16, however it seems that with UTF-16, the comma character …

Read More
How to create CSV Excel file C#?

I'm looking for a class for creating CSV Excel files. Expected features: Extremely simple to use Escapes commas and quotes so excel handles them fine Exports date and datetimes in timezone-proof format Do you know any class capable of this?

Read More
Automate the export of Facebook Insights data

I'm looking for a way of programmatically exporting Facebook insights data for my pages, in a way that I can automate it. Specifically, I'd like to create a scheduled task that runs daily, and that can save a CSV or …

Read More