• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

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

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.
 
Originally posted by: Electric Amish
Yeah, that was our first thought, but unfortunately some of the data will have commas included in it (currency).
Click to expand...
Have you tried saving as a tab delimited file and then find/replace the tabs with '|'?
 
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.
 
Originally posted by: Electric Amish
Anyone know how or if this can be done??

TIA

amish
Click to expand...

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.
 
You must log in or register to reply here.
Back
Top