Re: [mv] how to gid rid of "" when field includespaces/special characters ??

[".c o r y . t r e s e." <digital@specialty-books.com>]

******    message to minivend-users from ".c o r y . t r e s e." <digital@specialty-books.com>     ******

For a long time I used "rpl" to remove these (that's a console tr replacement
of sorts for those of you that haven't ever heard of it,) "'s from my stupid
XLS files, until I started setting the EXCEL thingy in the configuration files
for the database.

This seems to do a very neat job.  Check it out in the docs...

Cory

At the time of Mon, 22 May 2000, Barry Treahy wrote about Re: [mv] how to gid
rid of "" when field includespaces/special characters ??: >******    message to
minivend-users from Barry Treahy <Barry@BSTent.com>     ****** >
>My experience is that Excel will quote CSV (comma seperated value) outputs if a comma,
>apostrophe or quote exists in the text and when have the same type of problems with TAB (tab
>delimited values) additionall if a TAB exists in the alpha field.
>
>I'm running an old version of Excel, 1995 I believe, but if I recall, some of the newer
>versions may allow you to tell Excel not to quote on export.
>
>Barry
>
>Ed LaFrance wrote:
>
>> ******    message to minivend-users from Ed LaFrance <edlafrance@printexusa.com>     ******
>>
>> At 05:18 PM 5/22/00 +0200, you wrote:
>> >******    message to minivend-users from "Tal Hart (TelNET)"
>> ><tal@telnet.co.il>     ******
>> >
>> >I am not sure i get your Ideas....
>> >Yes, i am editing With Excelll..
>> >When i save the file , i save it as Tab delimited...
>> >
>> >In the file itself there are no "" , these are somehow added by minivend....
>> >
>> >should i make any correction in :
>> >A. the Database processing/generating
>> >B. Minivend configuration
>> >C. My HTML Pages....
>>
>> Are you sure?  I find that Excel adds quotes not matter how I set my open
>> and save options.  Right after saving your database as a TAB file in excel,
>> open it using Excel's evil counterpart Word, then use the Replace command
>> to replace " with nothing (leave "replace with" blank).  It will tell you
>> how many instances were changed when it is done.  You can then save the
>> cleansed file in its existing format with CTRL-S.
>>
>> - Ed L.
>> Printex Marking Technologies
>> 12113 Kirkham Rd.
>> Poway, CA  92064  U.S.A.
>> 858-513-2418
>> 800-982-1928
>> 858-513-2419 FAX
>> http://www.printexusa.com
>>
>> -
>> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>> Archive of past messages: http://www.minivend.com/minivend/minivend-list
>
>-
>To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
>email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
>Archive of past messages: http://www.minivend.com/minivend/minivend-list
--
digital@specialty-books.com
800.466.1365-ext223
[head web-human, Specialty Books]
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list