topic Convertir texto a numero in QlikView

Convertir texto a numero

Thu, 05 Jan 2012 17:03:23 GMT

Estimados, tengo este problema, como puedo convertir a numero un dato de 15 digitos, por ejemplo

000000000125481 a 125481

000000012601511 a 12601511

000000000001225 a 1225

tengo 2 tablas que se unen por este codigo, o tambien como hacer para que se complete con CEROS

125481 a 000000000125481

Gracias por el apoyo.

swuehl — Thu, 05 Jan 2012 17:20:16 GMT

My spanish is not very good, but maybe one of these will help you to either strip the zeros or format your numbers with leading zeros:

Number1:

LOAD num(Number) as Number1 INLINE [

Number

00000012123214

12000123000122

00001232134414

];

Number2:

LOAD num(Number,'000000000000000') as Number2 INLINE [

Number

123456

244

45353535

];

Clever_Anjos — Thu, 05 Jan 2012 17:31:49 GMT

SET Ceros = 15;

LOAD

right(Repeat('0',$(Ceros)-1) & RecNo(),$(Ceros)) as x

AutoGenerate 200;

Thu, 05 Jan 2012 17:44:18 GMT

Thanks, i worked the first, i have problems with the NUM, and the second came out perfect.

I found this here:

replace(ltrim(replace(CAMPO1,'0',' ',)),' ',0) as CAMPO1

Thanks for the help.

Fri, 09 May 2014 14:45:04 GMT

Hello , to complete with ceros to the left i did this sentence:

set var=10;

repeat('0', var - len(campo)) & campo;