cancel
Showing results for 
Search instead for 
Did you mean: 

Formula for removing trailing dots in name

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

This should work irrespective of number of trailing dots.

=Replace(RightTrim(Replace([Object];".";" "));" ";".")

Former Member
0 Kudos

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.

Former Member
0 Kudos

HI,

try

REplace([Test];".";Char(0))

CHeers,

ROgerio

Former Member
0 Kudos

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