Export "Pipe" de-limited text file from Excel???

[Electric Amish]

Anyone know how or if this can be done??

TIA

amish

 

[notfred]

Would it be that hard to use commas or tabs and then replace them?

 

[Agamar]

That would probably be best...Just use a search / replace to replace all the commas with |

 

[Electric Amish]

Yeah, that was our first thought, but unfortunately some of the data will have commas included in it (currency).

 

[DaveSimmons]

also for text fields excel exports " as "" (doubles the double-qoutes) if that field is in quotes.

so a field: I said "Hi, bye"
mght be exported as ...,"I said ""Hi, bye""", ...

A comma-delim to tab-delim filter isn't hard to write though in c/c++, VB, etc., or there are probably conversion programs out there too.

 

[TSDible]

I don't have the solution with me, but I will see what I can come up with...

 

[Yomicron]

Originally posted by: Electric Amish
Yeah, that was our first thought, but unfortunately some of the data will have commas included in it (currency).

Have you tried saving as a tab delimited file and then find/replace the tabs with '|'?

 

[TSDible]

Yomicron's solution does indeed work.

I'm looking for a smoother solution directly from excel. I will let you know if I find anything.

 

[Mday]

Originally posted by: Electric Amish
Anyone know how or if this can be done??

TIA

amish

if it's plain txt, you can open excel, then use the file-open menu to open the file, you should be given some sort of wizard as to what to do.

if you just have it opened in exel, tools-text to column, and it's self explanatory from there (wizard)

if you do want to replace the | with some txt to do column separation, DONT USE QUOTES. use something simple like TAB or even a fixe set of *** or ZZZ (something that is not part of the document). but i recommend my first 2 options (one of them), both will work.