RE: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108064
interpreted = N
texte = Select column ...format cell as text and then import your DB. The super longstring will present correctly withut any need fr alphabets in it.Cheers TDn-----Original Message-----From: Eddie Z [mailto:eddie@thinksite.com] Sent: Wednesday, January 11, 2012 02:19To: talk@webdna.usSubject: Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?Importance: LowOk, since the Excel subject came up today, I started looking into it for thefirst time in years. Turns out Excel can't open numbers over 15 characters.You can trick Excel into thinking the number is text by wrapping it inquotes or putting a non-numerical character in front of it.So now I have two options:Make sure the cart number is 15 characters or less, or I place a randomletter in front of all of my cart numbers. I don't care for the quotes idea.Can the [cart] variable be altered to 15 characters or less? I assume Icould do it with [getchars], but I'm not sure if it would still remainunique.Is there a downfall to having a letter in front of my cart number, likeR162389472337495033? The only thing I can think of is that it may effectsome [math] code.On 1/10/12 12:00 PM, "Eddie Zelhofer"
wrote:> I've tried everything, but I'm not an expert Excel user by any means. > If I open in Excel a cart number looks like this: 1.06391E+16 instead > of 10639064155219361. If I change the formatting on the cell, the > closest I can get to the actual cart number is 10639064155219300. The > first 15 characters are correct, but it goes to zeros after that. So > unless there's some sort of setting that can be done before I open the > file, I don't know how this is possible.> > This really would come in handy for me if anyone out there knows how I > could get around this issue.> > Eddie> > > On 1/10/12 11:33 AM, "Donovan Brooke" wrote:> >> Eddie Z wrote:>>> I only use a text editor (BBEdit) for my dbs. I've never figured out >>> how to keep Excel from truncating my [cart] numbers when opening a >>> db text file for the first time though. If there's a secret to that I'dlike to know it.>>> >>> Eddie>> >> It's a preference setting on the column. (format cell if remember >> right)>> >> Donovan>> > > > ---------------------------------------------------------> This message is sent to you because you are subscribed to the mailing > list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed to the mailing list.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
Associated Messages, from the most recent to the oldest:
Select column ...format cell as text and then import your DB. The super longstring will present correctly withut any need fr alphabets in it.Cheers TDn-----Original Message-----From: Eddie Z [mailto:eddie@thinksite.com] Sent: Wednesday, January 11, 2012 02:19To: talk@webdna.usSubject: Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?Importance: LowOk, since the Excel subject came up today, I started looking into it for thefirst time in years. Turns out Excel can't open numbers over 15 characters.You can trick Excel into thinking the number is text by wrapping it inquotes or putting a non-numerical character in front of it.So now I have two options:Make sure the cart number is 15 characters or less, or I place a randomletter in front of all of my cart numbers. I don't care for the quotes idea.Can the [cart] variable be altered to 15 characters or less? I assume Icould do it with [getchars], but I'm not sure if it would still remainunique.Is there a downfall to having a letter in front of my cart number, likeR162389472337495033? The only thing I can think of is that it may effectsome [math] code.On 1/10/12 12:00 PM, "Eddie Zelhofer" wrote:> I've tried everything, but I'm not an expert Excel user by any means. > If I open in Excel a cart number looks like this: 1.06391E+16 instead > of 10639064155219361. If I change the formatting on the cell, the > closest I can get to the actual cart number is 10639064155219300. The > first 15 characters are correct, but it goes to zeros after that. So > unless there's some sort of setting that can be done before I open the > file, I don't know how this is possible.> > This really would come in handy for me if anyone out there knows how I > could get around this issue.> > Eddie> > > On 1/10/12 11:33 AM, "Donovan Brooke" wrote:> >> Eddie Z wrote:>>> I only use a text editor (BBEdit) for my dbs. I've never figured out >>> how to keep Excel from truncating my [cart] numbers when opening a >>> db text file for the first time though. If there's a secret to that I'dlike to know it.>>> >>> Eddie>> >> It's a preference setting on the column. (format cell if remember >> right)>> >> Donovan>> > > > ---------------------------------------------------------> This message is sent to you because you are subscribed to the mailing > list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us---------------------------------------------------------This message is sent to you because you are subscribed to the mailing list.To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us
"Terry Nair"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Roundup function? (1997)
talking to MacAuthorize (1997)
template cache problem (1998)
Remote delivery (1998)
proper username/password *w/out* the authenticate dialog. (2000)
Logging purchases (1997)
Time code! (2002)
[subtotal] problems -- help? (1998)
[SearchString] problem with [search] context (1997)
#uck you (1998)
[ot] Webserver monitoring (2001)
Review comparison by PC Magazine: Open for On-line Business (1997)
[Webcat 2]Next (1997)
WebCat2 - [format thousands] (1997)
encrypt (2000)
WebMerchant and PCAuthorize (1998)
Today's suggestions (1998)
[OT] degree symbol (2003)
Base 64 encoding (2001)
Mac Vs WindowsNT (1997)