Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?

This WebDNA talk-list message is from

2012

It keeps the original formatting. numero = 108068
interpreted = N
texte = Open the db with the "open" command, then follow the assistant and =choose text format for the column with the cart no ... this "should" =work.Anyway, I don't recommend using Excel to edit db files, it's just good =for controlling reasons ...ThierryAm 10.01.2012 um 19:18 schrieb Eddie Z:> Ok, since the Excel subject came up today, I started looking into it =for the> first 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 in> quotes or putting a non-numerical character in front of it.>=20> So now I have two options:> Make sure the cart number is 15 characters or less, or I place a =random> letter in front of all of my cart numbers. I don't care for the quotes =idea.>=20> Can the [cart] variable be altered to 15 characters or less? I assume =I> could do it with [getchars], but I'm not sure if it would still remain> unique.>=20> Is there a downfall to having a letter in front of my cart number, =like> R162389472337495033? The only thing I can think of is that it may =effect> some [math] code.>=20>=20> On 1/10/12 12:00 PM, "Eddie Zelhofer" wrote:>=20>> 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.>>=20>> This really would come in handy for me if anyone out there knows how =I could>> get around this issue.>>=20>> Eddie>>=20>>=20>> On 1/10/12 11:33 AM, "Donovan Brooke" wrote:>>=20>>> 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'd like to know =it.>>>>=20>>>> Eddie>>>=20>>> It's a preference setting on the column. (format cell if remember =right)>>>=20>>> Donovan>>>=20>>=20>>=20>> --------------------------------------------------------->> 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>=20>=20> ---------------------------------------------------------> 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 Associated Messages, from the most recent to the oldest:

Open the db with the "open" command, then follow the assistant and =choose text format for the column with the cart no ... this "should" =work.Anyway, I don't recommend using Excel to edit db files, it's just good =for controlling reasons ...ThierryAm 10.01.2012 um 19:18 schrieb Eddie Z:> Ok, since the Excel subject came up today, I started looking into it =for the> first 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 in> quotes or putting a non-numerical character in front of it.>=20> So now I have two options:> Make sure the cart number is 15 characters or less, or I place a =random> letter in front of all of my cart numbers. I don't care for the quotes =idea.>=20> Can the [cart] variable be altered to 15 characters or less? I assume =I> could do it with [getchars], but I'm not sure if it would still remain> unique.>=20> Is there a downfall to having a letter in front of my cart number, =like> R162389472337495033? The only thing I can think of is that it may =effect> some [math] code.>=20>=20> On 1/10/12 12:00 PM, "Eddie Zelhofer" wrote:>=20>> 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.>>=20>> This really would come in handy for me if anyone out there knows how =I could>> get around this issue.>>=20>> Eddie>>=20>>=20>> On 1/10/12 11:33 AM, "Donovan Brooke" wrote:>>=20>>> 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'd like to know =it.>>>>=20>>>> Eddie>>>=20>>> It's a preference setting on the column. (format cell if remember =right)>>>=20>>> Donovan>>>=20>>=20>>=20>> --------------------------------------------------------->> 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>=20>=20> ---------------------------------------------------------> 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 Thierry Almy

DOWNLOAD WEBDNA NOW!

Re: [BULK] Re: [WebDNA] Can WebDNA corrupt a db?

2012

Top Articles:

Related Readings: