Save as a pipe delimited text file

**Jetheat** · 07-01-2010, 12:32 AM

I have a csv file which I have opened in Excel 2008 on my mac.

How do I export it as a pipe delimited text file.

I can only see an option to save it as a tab delimited text file.

If I cant save as a pipe delimited text file,
Is there a way to convert from a tab delimited text file to a pipe delimited text file?

**estige** · 07-01-2010, 04:32 AM

You could always open the tab delimited file in a text editor (word, wordpad, notepad), replace all tabs with pipes, and save as txt?

**martindwilson** · 07-01-2010, 04:33 AM

maybe if you save as tab delimited
open with word
find/replace ^t with pipe character

**martindwilson** · 07-01-2010, 04:39 AM

very strange board behavior today double posting and all!!!

**estige** · 07-01-2010, 07:04 AM

Instant QA:-D

**Jetheat** · 07-01-2010, 08:07 AM

You could always open the tab delimited file in a text editor (word, wordpad, notepad), replace all tabs with pipes, and save as txt?

maybe if you save as tab delimited
open with word
find/replace ^t with pipe character

Tried these 2 but did not work.

Anyhow, I had to do a windows hack with regional settings and then it worked.

JH