Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mid function along with index function

Hi Team,

I am trying to split phone number column into 3 parts base on a delimiter '-'.

I know that it's quite easy to resolve the above problem using subfield() function.

But, I want to try the same using Index function.

I have successfully achieved the leftmost and the rightmost column but i don't know what mistake i am doing in my logic to achieve the middle part of the phone number.

I have attached my qvw file for your reference.

Regards

Priyanka

1 Solution

Accepted Solutions
Kush
MVP
MVP

Try,

First-

=mid(Phone_Number.PhoneNumber,1,Index(Phone_Number.PhoneNumber,'-',1)-1)

Mid -

=mid(Phone_Number.PhoneNumber,Index(Phone_Number.PhoneNumber,'-',1)+1,Index(Phone_Number.PhoneNumber,'-',2)-(Index(Phone_Number.PhoneNumber,'-',1)+1))

Last-

=mid(Phone_Number.PhoneNumber,Index(Phone_Number.PhoneNumber,'-',2)+1)

View solution in original post

4 Replies
swuehl
MVP
MVP

Try like

Left(PhoneNumber, Index(PhoneNumber,'-')-1) as lft,

Mid(PhoneNumber,Index(PhoneNumber,'-')+1,Index(PhoneNumber,'-',2)-Index(PhoneNumber,'-',1))as mid,

Index(PhoneNumber,'-')+1 as 1,

Len(PhoneNumber) as Len,

Index(PhoneNumber,'-',2) as 2,

Len(PhoneNumber)-Index(PhoneNumber,'-',2) as 3,

Right(PhoneNumber,Len(PhoneNumber)- Index(PhoneNumber,'-',2)) as right

Kush
MVP
MVP

Try,

First-

=mid(Phone_Number.PhoneNumber,1,Index(Phone_Number.PhoneNumber,'-',1)-1)

Mid -

=mid(Phone_Number.PhoneNumber,Index(Phone_Number.PhoneNumber,'-',1)+1,Index(Phone_Number.PhoneNumber,'-',2)-(Index(Phone_Number.PhoneNumber,'-',1)+1))

Last-

=mid(Phone_Number.PhoneNumber,Index(Phone_Number.PhoneNumber,'-',2)+1)

View solution in original post

antoniotiman
Master III
Master III

Mid :

Mid([Phone-1.PhoneNumber],Index([Phone-1.PhoneNumber],'-')+1,Index([Phone-1.PhoneNumber],'-',2)-Index([Phone-1.PhoneNumber],'-')-1)

qlikviewwizard
Master II
Master II

Hi Priyanka018,

Use this app.

Capture1.JPG

Capture.JPG