topic Re: Converter String em Valor in Brasil https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062595#M36883 <HTML><HEAD></HEAD><BODY><P>Bom Dia Renato,</P><P></P><P>Talvez o PurgeChar possa lhe ajudar. </P><P></P><P>Se entendi direito, tentar.</P><P></P><P>PurgeChar('124,56 dias','dias')</P></BODY></HTML> Tue, 01 Mar 2016 16:03:37 GMT tiago_hubner 2016-03-01T16:03:37Z Converter String em Valor https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062593#M36881 <HTML><HEAD></HEAD><BODY><P>Bom Dia.!</P><P></P><P>Tenho um campo string que preciso converter para numérico. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P></P><P>124,56 dias</P><P>1 dia</P><P>234,45 dias</P><P></P><P>Preciso pegar apenas o valor já transformado em numérico.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/cry.png" /></P><P></P><P>124,56</P><P>1</P><P>234,45</P><P></P><P>Existe alguma função que já realize este tipo de tarefa ?&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P><P></P><P>Obrigado..!!</P><P></P><P>Renato</P></BODY></HTML> Tue, 01 Mar 2016 15:00:34 GMT https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062593#M36881 girino777 2016-03-01T15:00:34Z Re: Converter String em Valor https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062594#M36882 <HTML><HEAD></HEAD><BODY><P>Bom Dia</P><P></P><P><SPAN lang="pt">tenta adicionando esta linha para carregar</SPAN></P><P></P><P>LOAD</P><P><STRONG>num(Left([Tiempo],Len([Tiempo])-index([Tiempo],'dia'))) AS [Tiempo]</STRONG></P><P>[...etc]</P><P></P><P>Philippe</P></BODY></HTML> Tue, 01 Mar 2016 15:25:50 GMT https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062594#M36882 2016-03-01T15:25:50Z Re: Converter String em Valor https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062595#M36883 <HTML><HEAD></HEAD><BODY><P>Bom Dia Renato,</P><P></P><P>Talvez o PurgeChar possa lhe ajudar. </P><P></P><P>Se entendi direito, tentar.</P><P></P><P>PurgeChar('124,56 dias','dias')</P></BODY></HTML> Tue, 01 Mar 2016 16:03:37 GMT https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062595#M36883 tiago_hubner 2016-03-01T16:03:37Z Re: Converter String em Valor https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062596#M36884 <HTML><HEAD></HEAD><BODY><P>Renato,</P><P></P><P>daria para usar os comandos abaixo.......</P><P></P><P>num#(purgechar(Campo , 'dias'))</P><P></P><P>num#(replace(replace(Campo,'dias',''),'dia',''))</P><P></P><P>num#(subfield(Campo,' ',1))</P><P></P><P>(obs - digitei sem colocar no QlikView e nao vi a sintaxe....)</P></BODY></HTML> Tue, 01 Mar 2016 16:30:06 GMT https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062596#M36884 afurtado 2016-03-01T16:30:06Z Re: Converter String em Valor https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062597#M36885 <HTML><HEAD></HEAD><BODY><P>Muito Obrigado pelas dicas..!!&nbsp; <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>Renato</P></BODY></HTML> Tue, 01 Mar 2016 16:37:47 GMT https://community.qlik.com/t5/Brasil/Converter-String-em-Valor/m-p/1062597#M36885 girino777 2016-03-01T16:37:47Z