Re: validaciòn de RUT en Excel

Article View: chile.comp.multimedia

Article #229

Back to chile.comp.multimedia Previous Next

#229

From: gato2006chile
Date: Sun, 24 Jun 2007 22:35

30 lines
2122 bytes

Si embargo dicha funcion solo genera el digito verificador, no tiene 
ninguna integridad para verificar errores.
Debes modificarla para que el digito verificador se compare con el 
ultimo caracter, y previamente debes definir como estan presentados los 
datos en ambas bases.

�12.345.678-6, 12345678-6, 123456786?
Generas el digito y compruebas que sea igual.

quincy escribi�:
> "Diego Styl Q." <dstyl@vtr.net> wrote in
> news:f5mbdo$mh8$1@news.nivel5.cl: 
> 
>> Sirve.
>>
>> Validar RUT!
>> Excel
>> Function dv(a)
> 
> 
> bien, Diego, gracias . . . x anticipado a la prueba.
> 
> y, para mayor precisi�n:
> �sa funci�n ir�a en "la celda �nica o en la celda de la primera columna 
> extra", tal como lo defin� en mi post?
> 
> y,,, cu�l deber�a ser el formato espec�fico de la celda???
> 
> graxs, again
>

Technical Details

Message-ID: <f5mrlr$r5p$1@news.nivel5.cl>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.google.com!out04b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!newsfeed.yul.equant.net!news-santiago!news.nivel5.cl!not-for-mail

References: <467ea30e@news.vcd.cl> <f5mbdo$mh8$1@news.nivel5.cl> <467eac53@news.vcd.cl>

Show Full Headers

Complete Article Headers

X-Google-Thread: f82d0,db7731e988b546b0
X-Google-Thread: f9ea8,db7731e988b546b0
X-Google-Attributes: gidf82d0,gidf9ea8,public,usenet
X-Google-Language: SPANISH,CP1252
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news3.google.com!out04b.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!newsfeed.yul.equant.net!news-santiago!news.nivel5.cl!not-for-mail
From: gato2006chile <gato2006chileSINESTO@gmail.com>
Newsgroups: chile.comp.multimedia,chile.comp.pc
Subject: Re: validaciòn de RUT en Excel
Date: Sun, 24 Jun 2007 18:35:54 -0400
Organization: Varios
Lines: 30
Message-ID: <f5mrlr$r5p$1@news.nivel5.cl>
References: <467ea30e@news.vcd.cl> <f5mbdo$mh8$1@news.nivel5.cl> <467eac53@news.vcd.cl>
NNTP-Posting-Host: pc-152-68-44-190.cm.vtr.net
Mime-Version: 1.0
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: news.nivel5.cl 1182724603 27833 190.44.68.152 (24 Jun 2007 22:36:43 GMT)
X-Complaints-To: news@news.nivel5.cl
NNTP-Posting-Date: Sun, 24 Jun 2007 22:36:43 +0000 (UTC)
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; es-ES; rv:1.8.1.4) Gecko/20070604 Thunderbird/2.0.0.4 Mnenhy/0.7.5.0
In-Reply-To: <467eac53@news.vcd.cl>

Reply to Parent Message