topic Re: buscar data na frase in QlikView https://community.qlik.com/t5/QlikView/buscar-data-na-frase/m-p/1353533#M842627 <HTML><HEAD></HEAD><BODY><P>Resolvido.</P><P></P><P>consegui achar a solução, obrigado!</P><P>MID( DS_TABELA_CUSTO, FindOneOf( DS_TABELA_CUSTO, '/' )-2,5 ) as posicao </P></BODY></HTML> Thu, 20 Apr 2017 18:35:21 GMT marcelviegas 2017-04-20T18:35:21Z buscar data na frase https://community.qlik.com/t5/QlikView/buscar-data-na-frase/m-p/1353532#M842625 <HTML><HEAD></HEAD><BODY><P>Prezados,</P><P></P><P>tenho um campo de uma tabela que tem uma frase não padrão, exemplo:</P><P>&nbsp; <STRONG>campo,</STRONG></P><P>'bla bla bla 10/15 bla bla bla ',</P><P><SPAN style="font-size: 13.3333px;">'bla bla bla 10/17 bla bla bla ',</SPAN></P><P><SPAN style="font-size: 13.3333px;">'bla bla bla 01/15 bla bla bla ',</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Necessito buscar somente a data entre os bla bla blas.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/buscar-data-na-frase/m-p/1353532#M842625 marcelviegas 2020-11-25T16:16:04Z Re: buscar data na frase https://community.qlik.com/t5/QlikView/buscar-data-na-frase/m-p/1353533#M842627 <HTML><HEAD></HEAD><BODY><P>Resolvido.</P><P></P><P>consegui achar a solução, obrigado!</P><P>MID( DS_TABELA_CUSTO, FindOneOf( DS_TABELA_CUSTO, '/' )-2,5 ) as posicao </P></BODY></HTML> Thu, 20 Apr 2017 18:35:21 GMT https://community.qlik.com/t5/QlikView/buscar-data-na-frase/m-p/1353533#M842627 marcelviegas 2017-04-20T18:35:21Z