Subfield

[everest226]

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

tamilarasu‌

stalwar1‌

[swuehl · Accepted solution]

Maybe

=If(Index(user,'\'), SubField([user],'\',2), user)

[everest226]

Now i am getting 

UK709065

UK703562

but not this

UTA\Ram

CAMPUS\Juliya

PHM\RAmtu

[sunny_talwar]

Stefan's expression seems to be working for me

[swuehl]

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

];

[surendraj]

stefan's expression is working fine.

Here is the another one.

If(SubStringCount(data,'\')=1, SubField(data,'\',2), data)

[everest226]

Thanks  

[everest226]

Thanks Sunny

[rwunderlich]

Or

mid(user, Index(user,'\')+1)

-Rob