Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data something like keerthi(3222).
I need to display Keerthi and 3222 separately.
Please help me with this
Thanks,
Keerthi KS
Hi Jagan,
Attached the Qvw.
Regards,
Keerthi KS
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)
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>
why Null for Case 1?
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.
what will be the output in this case?
Adarsh Kumar Kochhar (Vir Chakra ) & Mrs. Neena Kochhar (15)
15 for unit number. Remaining full as Name
Hi Keerthi
Please see if this helps?
Regards
Sasi
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 !