Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Index

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.log6
car_bt_avaya_split_6.qvw.log6
car_lk_tie_dia_7.qvw.log7
sistema.log-
sistema.log-
car_gir_1_1.qvw.log1
sistema.log-
car_bt_evento_4.qvw.log4
car_bt_evento_4.qvw.log4

I trying with Index funtion but i did not succeed.

Can they help me?

Thank!!!

Ivan.

1 Solution

Accepted Solutions
swuehl
Not applicable

Index

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);

3 Replies
swuehl
Not applicable

Index

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
Not applicable

Index

Hi,

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

Hope it helps

Celambarasan

Not applicable

Re: Index

Thank Swuehl!!  Thank Celambarasan!!.