on 01-08-2015 9:45 AM
Please help me out if i can remove trailing dots in name in WEBI using variable formula
Ex: Object instance : india.... or in....dia..... should display as india or in....dia
thanks,
hasan
This should work irrespective of number of trailing dots.
=Replace(RightTrim(Replace([Object];".";" "));" ";".")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Javeed,
You can try following formula where [Test] is the dimension.
=Substr([Test];0;Pos([Test];".")-1)
Hope this will help you…!!
Veer S.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
are you able to generalize the ending pattern of your object?
if yes then you can try to use substr([obj],0,length([obj])-n)
n= number of characters at the end
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.