[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 "Tal Hart (TelNET)" <tal@telnet.co.il> ******
Thanks to you All.
The """ problem has been solved...
It was indid the Excel's fault....
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
=============================================================
----- Original Message -----
From: <minivend-users@minivend.com>
To: <minivend-users@minivend.com>
Sent: Monday, May 22, 2000 11:52 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> ******
>
> 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
>
-
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
