Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi i am using subfield in chart but somehow top two user UK709065 and UK703562 are not showing basically it dosent have \ on that user
my expression of subfield is
=SubField([user],'\',2)
UK709065
UK703562
UTA\Ram
CAMPUS\Juliya
PHM\RAmtu
Maybe
=If(Index(user,'\'), SubField([user],'\',2), user)
Now i am getting
UK709065
UK703562
but not this
UTA\Ram
CAMPUS\Juliya
PHM\RAmtu
Stefan's expression seems to be working for me
Seems to work for me:
user | test |
---|---|
CAMPUS\Juliya | Juliya |
UK703562 | UK703562 |
UK709065 | UK709065 |
UTA\Ram | Ram |
LOAD *,
If(Index(user,'\'), SubField([user],'\',2), user) as test;
LOAD * INLINE [
user
UK709065
UK703562
UTA\Ram
CAMPUS\Juliya
];
stefan's expression is working fine.
Here is the another one.
If(SubStringCount(data,'\')=1, SubField(data,'\',2), data)
Thanks
Thanks Sunny
Or
mid(user, Index(user,'\')+1)
-Rob