Hello,

Is there any way to edit the files with pipe delimited data and save them in the same format?

Thankx

If you set up the delimiter character the same in both LINKS and Excel, they should work fine. Make sure that you have corresponding NULL fields for each. One problem we are running into is that we have a data manager who is creating the database files for Gossamer-Threads programs, including LINKS and he tends to forget about the NULL | | fields, which causes the database to not show up clean.

Regards,

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

Hi azkar,

All you need to do is change

# Database delimeter.
$db_delim = '|';
to

# Database delimeter.
$db_delim = ',';

In both links.def and category.def.
Now both DB's are comma delimited and you can use Excel or another spreadsheet with no problems.

------------------
JRM Studios www.jrmstudios.com
The Hotrodding Network www.hotrodding.net
Web discuss Free speech newsgroups - www.webdiscuss.com

Eliot, many thanks for your suggestion. The problem is that I am not very well aware that Excel will let me choose the delimiter chnaracter other than comma. How do we choose these? If I can set it to pipe, 99% of my problem will be solved.

Thanks again.

Thank you John for taking that precious time and explaining it all. But my trouble is that i HAVE to use the pipe. Some of the stuff I am doing slows down the server heavily with comma delimited files as compared to pipe delimited.

So, again, :-) , is there any way we can make MS excell export files with pipe delimited data?

Thanks

Hi

The way I have done it in the past is export a CVS file and then open it in a text editor (I use http://www.notetab.ch/ ) and do a find and replace on the commers for |'s.

Chris