How to Create a Tab Delimited Csv?

Sophia Al-Mansoor
Sophia Al-Mansoor
• • 2 min read

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

How to Create a Tab Delimited Csv?

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.

2

1 Answer

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.

1

Must Read

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Sophia Al-Mansoor

Sophia Al-Mansoor

Global Business & E-Commerce Reporter
Linkedin Twitter

Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.

Share this article
Twitter Facebook Pinterest