Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to get the User Level from the UserField.This Field has the Userid along with LevelType.
UserID
ABCL1 -L1
HZHL2 -L2
HSDL3-L3
JHHJ-NA
GHJD-NA
GHJJ-NA
Hello Harish,
Something like this should help you return LevelType, assuming the delimiter is always '-'.
=mid([UserID],index([UserID],'-',1),len([UserID]) - len(index([UserID],'-',1)))