Split part in Qlikview

[#1]

Hi,

I have data something like keerthi(3222).

I need to display Keerthi and 3222 separately.

Please help me with this

Thanks,

Keerthi KS

[#2]

Hi Jagan,

Attached the Qvw.

Regards,

Keerthi KS

[sasiparupudi1]

Hi

what is the expected output the following cases

Z-TECH (India) Pvt Ltd

Taxes ( VAT & ST )

Mr. AMIT   NANDI FOUZDAR, Mrs. SWETAMBRA  SINGH (B19-C)

Mr Goda Venkata  Balachander (106a)

[#4]

Output

Case 1: Blank or null

Case 2: VAT & ST

Case 3 B19-C

Case 4: 106a

On Jul 21, 2015 6:19 PM, "Sasidhar Parupudi" <qcwebmaster@qlikview.com>

[Kushal_Chawda]

why Null for Case 1?

[#6]

Any value which is at the end within brackets has unit number. There are

names in between within brackets those are considered as Name.

Case 1 is similar case.

[Kushal_Chawda]

what will be the output in this case?

Adarsh Kumar Kochhar (Vir Chakra ) & Mrs. Neena Kochhar (15)

[#8]

15 for unit number. Remaining full as Name

[sasiparupudi1 · Accepted solution]

Hi Keerthi

Please see if this helps?

Regards

Sasi

[Kushal_Chawda]

Try like this,

Unit Number  =

if(len(Level2)=index(Level2,')',-1), mid(Level2,Index(Level2,'(',-1)+1,Index(Level2,')',-1) -(Index(Level2,'(',-1)+1)))

Name =

if(len(Level2)=index(Level2,')',-1), mid(Level2,1,Index(Level2,'(',-1)-1))

Please see the attached !