[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Re: [mv] how to gid rid of "" when field include spaces/special characters ??
****** 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
