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

["Eran Binyamin Zeitoun" <eran_zeitoun@karmail.com>]

******    message to minivend-users from "Eran Binyamin Zeitoun" <eran_zeitoun@karmail.com>     ******

Tal'chok!
I am not quite sure what is the way you work with your products.asc file....
so you might do this process once... so the settings will be saved....
load products.asc file in the excel in the normal way (file, open, change
file type to "all files")
then you will have 3 phases in the import screens..., in the phase 2 screen,
there is a
"Text qualifer" (i am not quite sure this is the translation, becouse i have
the hebrew version,
and since you are hebrew reader, it says "MEZA-HEA TEXT")...
there change from " to None...., this should solve your problems....
Also as you will read the Minivend Docs... you will notice (as i noted now,
for giving you the right
answer) that mike sayed all my blahh blahh shortly:

"NOTE: Microsoft Excel is a widely-used tool to maintain MiniVend databases,
but has several problems with its standard TAB-delimited export, like
encasing fields containing commas in quotes, generating extra carriage
returns embedded in records, and not including trailing blank fields. To
avoid problems, use a text-qualifier of none"

Also from the docs, about the excel directive....:
"EXCEL  -
Microsoft Excel insists on surrounding any exported field that contains a
comma with quotes, even for TAB-delimited exports. Set the EXCEL attribute
to 1 to fix this on import:

    Database products EXCEL 1

This is normally used only with TAB-delimited files. "

All the thanks should go to Mike....

If you wont get along with that... call me... 050-555187

Hope I Helped...
Eran.







----- Original Message -----
From: "Tal Hart (TelNET)" <tal@telnet.co.il>
To: <minivend-users@minivend.com>
Sent: Monday, May 22, 2000 5:18 PM
Subject: Re: [mv] how to gid rid of "" when field include spaces/special
characters ??


> ******    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....
>
> ???
>
> Tal Hart
> =============================================================
> TelNET Communication
> Tel # + 972-9-8859919    Fax # +972-9-88598929
> Address : Office - 10 giborey israel, New industrial area,Netanya
> Post Adress : 2 Gur st. , Ramat Poleg , Netanya , ISRAEL , 42000
> E-mail : tal@telnet.co.il           Web : www.telnet.co.il
> =============================================================
> ----- Original Message -----
> From: <minivend-users@minivend.com>
> To: <minivend-users@minivend.com>
> Sent: Monday, May 22, 2000 4:39 PM
> Subject: Re: [mv] how to gid rid of "" when field include spaces/special
> characters ??
>
>
> > ******    message to minivend-users from "Eran Binyamin Zeitoun"
> > <eran_zeitoun@karmail.com>     ******
> >
> > I think it becouse you are editing you products.asc file with
excell.....,
> > (If So) when importing you can ilminate this problem, by changing " to
> none
> > on the import screen....
> >
> > Also use the EXCEL directive in the catalog.cfg files declerations...
> >
> > If i am mistaken... sorry for spending some bits over the net....
> >
> > Eran.
> > ----- Original Message -----
> > From: "Tal Hart (TelNET)" <tal@telnet.co.il>
> > To: <minivend-users@minivend.com>
> > Sent: Monday, May 22, 2000 12:58 PM
> > Subject: [mv] how to gid rid of "" when field include spaces/special
> > characters ??
> >
> >
> > >> ******    message to minivend-users from "Tal Hart (TelNET)"
> > <tal@telnet.co.il>     ******
> > >>
> > >> We use a TAB Delimited text file as our DB source...
> > >> when an item includes spaces or special characters in it,
> > >> it will show up with " before and after the field ... I.E. :
> > >> Product : "Brother HL-1240 Laser Printer"
> > >> instead of plain : Product : Brother HL-1240 Laser Printer
> > >>
> > >> How can we get rid of these ""'s ????
> > >>
> > >> Tal Hart
> > >> =============================================================
> > >> TelNET Communication
> > >> Tel # + 972-9-8859919    Fax # +972-9-8859929
> > >> Address : Office - 10 giborey israel, New industrial area,Netanya
> > >> Post Adress : 2 Gur st. , Ramat Poleg , Netanya , ISRAEL , 42000
> > >> E-mail : tal@telnet.co.il           Web : www.telnet.co.il
> > >> =============================================================
> > >>
> > >> -
> > >> 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
> >
>
> -
> 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