I want to save an Excel file in "Pipe Delimited" (instead of csv).

I want to save my Excel file as "Pipe Delimited" (instead of csv) or else, if 
csv, then all values from a column to be enclosed in double quotes and not 
just the ones which have a comma in their values.
0
Zee (23)
11/1/2004 7:07:02 PM
excel.misc 78881 articles. 5 followers. Follow

3 Replies
630 Views

Similar Articles

[PageSpeed] 25

See www.cpearson.com/excel/imptext.htm for details and example 
code.


-- 
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com




"J�Zee" <J�Zee@discussions.microsoft.com> wrote in message 
news:846F5BD4-D8AF-41C6-B474-B788AEFF188D@microsoft.com...
>I want to save my Excel file as "Pipe Delimited" (instead of 
>csv) or else, if
> csv, then all values from a column to be enclosed in double 
> quotes and not
> just the ones which have a comma in their values. 


0
chip1 (1821)
11/1/2004 7:09:59 PM
Thanks a lot Chip.

"Chip Pearson" wrote:

> See www.cpearson.com/excel/imptext.htm for details and example 
> code.
> 
> 
> -- 
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
> 
> 
> 
> 
> "JèZee" <JèZee@discussions.microsoft.com> wrote in message 
> news:846F5BD4-D8AF-41C6-B474-B788AEFF188D@microsoft.com...
> >I want to save my Excel file as "Pipe Delimited" (instead of 
> >csv) or else, if
> > csv, then all values from a column to be enclosed in double 
> > quotes and not
> > just the ones which have a comma in their values. 
> 
> 
> 
0
JZee (1)
11/1/2004 8:13:01 PM
Another option...

Earl Kiosterud's Text Write program does this after you choose a couple of
options (if I recall correctly).

You can find it at:

www.smokeylake.com/excel
(or directly:  http://www.smokeylake.com/excel/text_write_program.htm)



J�Zee wrote:
> 
> I want to save my Excel file as "Pipe Delimited" (instead of csv) or else, if
> csv, then all values from a column to be enclosed in double quotes and not
> just the ones which have a comma in their values.

-- 

Dave Peterson
ec35720@msn.com
0
ec35720 (10082)
11/2/2004 12:21:48 AM
Reply:

Similar Artilces:

save as pipe delimited
hi, please help me in this, it is an urgent requirement. i have an excel file with several columns of data, spanning over 6500 rows. i would like to extract the data to a file with the data separated wit a pipe '|' character, instead of tab or comma. can this be done? if so, how do i go about achieving this? thanks in advance, mac -- icestationzbr ----------------------------------------------------------------------- icestationzbra's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=458 View this thread: http://www.excelforum.com/showthread.php?threa...

I want to save an Excel file in "Pipe Delimited" (instead of csv).
I want to save my Excel file as "Pipe Delimited" (instead of csv) or else, if csv, then all values from a column to be enclosed in double quotes and not just the ones which have a comma in their values. See www.cpearson.com/excel/imptext.htm for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "J�Zee" <J�Zee@discussions.microsoft.com> wrote in message news:846F5BD4-D8AF-41C6-B474-B788AEFF188D@microsoft.com... >I want to save my Excel file as "Pipe Delimited" (instead o...

save as pipe delimited #3
rehan, thanks for the response, but that is not the solution to my problem. i am trying to extract data from an excel file onto a data file (csv) the extract file needs to have the data from the contiguous column delimited by '|' character, and not space or tab. thanks, mac -- icestationzbr ----------------------------------------------------------------------- icestationzbra's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=458 View this thread: http://www.excelforum.com/showthread.php?threadid=26877 ...

save as pipe delimited #4
hi dave, thank you very much, link to chip pearson's macro worked for me. regards, mac -- icestationzbr ----------------------------------------------------------------------- icestationzbra's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=458 View this thread: http://www.excelforum.com/showthread.php?threadid=26877 ...

save as pipe delimited #2
hi, just an appendage: i found another link, which provides a file by Earl which does this. http://www.excelforum.com/showthread.php?t=265998&highlight=pipe+delimited i am not able to figure out where to input the filename for the data t be picked up from. any information regarding this would be helpful. thanks, mac -- icestationzbr ----------------------------------------------------------------------- icestationzbra's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=458 View this thread: http://www.excelforum.com/showthread.php?threadid=26877 ...

Import Pipe Delimited File, Parse out certian Fields, create new f
In Excel 2000, how do I take a pipe delimited file, strip out column(field) 6, 10, 11, 21. Then take that data, create a new pipe delimited file, and put the stripped 4 fields in columns 4,5,6,7 of a 15 column(field) new pipe delimited file? I want to do this automatically on a file that contains 1000+ records. What goes in columns 1-3 and 8-15 of the new file? In article <4696CAA0-1DD3-45E3-9627-3FE001611AD2@microsoft.com>, "StarBoy2000" <StarBoy2000@discussions.microsoft.com> wrote: > In Excel 2000, how do I take a pipe delimited file, strip out column(fiel...

pipe delimited format
how do i save a spreadsheet in pipe delimited format? i am using excel 2002, thanks Here's one way, works well if you only need to do it a couple of times! Save as a csv. change the extension of the csv to txt open the file, select all and copy paste it into word use replace to replace "," with "|" select all, copy and paste back into the text file If you have to do it numerous times your best bet is a macro, post back if that's what you need Dan E "rick" <elewis9125@aol.com> wrote in message news:059901c356d0$b29f5a80$a101280a@phx.gbl... >...

Export Access Query to a pipe delimited .csv file
Fairly new to Access VBA. How can I export an Access Query to a pipe delimited .csv file??? I believe the VBA Syntax is... DoCmd.TransferText acExportDelim, _ "Specification Name", "qry_name", "C:\PathName\FileName.csv" How do I specify and indicate to make it pipe delimited, "|"??? Thanks for your review and hopeful for a replay. PSULionRP You would set that up in your specification, and save it. That would be the "specification name" parameter. "PSULionRP" wrote: > Fairly new to Access VBA. > ...

Can someone help; pipe delimited text import not working
Im trying to import a pipe delimited text file into access 2007 and I get the following message when I try to finish the import "Method Execute TempImexSpec' of object '_Wizhook'failed. It doen't seem to be recognizing the "|" pipe sysmbol I entered? Help nothing seems to be working for me. Thanks Char Char - Can you import the text manually (which is how you usually set up import specs anyway)? It could be a data issue or an import spec issue... Can you copy the import text file and remove all but maybe the first few records and see if o...