topic Search caracters inside text in QlikView

Search caracters inside text

Fri, 14 Oct 2011 12:05:19 GMT

Community,

Whats the equivalent of search function in excel?

I have a column with with Year&";"&"Name";"&";"&"ID"

I want to left(variable a, len(variable a) - search(variable a, ";",1))

Thats the formula in excel.

How can i procedure that in qlikview? theres any equivalent in search function?

Regards,

Eliano

Search caracters inside text

Sokkorn — Fri, 14 Oct 2011 12:15:09 GMT

Hi Eliano,

QlikView have Search Object that this one maybe answer to your question, just Right Click on sheet ==> New Sheet Object ==> Search Object. In case you want to search all column or field, you need to add the require field.

Regards,

Sokkorn

Re: Search caracters inside text

Miguel_Angel_Baeyens — Fri, 14 Oct 2011 12:16:01 GMT

Hello Eliano,

My guess is that Index() or SubField() will do

=SubField('2011;MAB;15', ';', 1)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica