Search caracters inside text

[#1]

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

[Sokkorn]

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

[Miguel_Angel_Baeyens]

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