Skip to Content
avatar image
Former Member

Formula for removing trailing dots in name

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jan 08, 2015 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 11:54 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 09, 2015 at 05:08 AM

    This should work irrespective of number of trailing dots.

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

    Add comment
    10|10000 characters needed characters exceeded