Index

[#1]

Hi!.

I need extract a character in a field. All the fields that contain ".qvw" extract previous character.

Example:

Log	I need
car_bt_avaya_split_6.qvw.log	6
car_bt_avaya_split_6.qvw.log	6
car_lk_tie_dia_7.qvw.log	7
sistema.log	-
sistema.log	-
car_gir_1_1.qvw.log	1
sistema.log	-
car_bt_evento_4.qvw.log	4
car_bt_evento_4.qvw.log	4

I trying with Index funtion but i did not succeed.

Can they help me?

Thank!!!

Ivan.

[swuehl · Accepted solution]

Try a combination of index and mid functions:

LOAD Log,

     [I need],

    mid(Log,index(Log,'.qvw')-1,1) as Wanted

FROM

[http://community.qlik.com/thread/49231?tstart=0]

(html, codepage is 1252, embedded labels, table is @1);

[CELAMBARASAN]

Hi,

     =Mid(Log,Index(Log,'.qvw')-1,1)

Hope it helps

Celambarasan

[#4]

Thank Swuehl!!  Thank Celambarasan!!.