Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Period/Full stop in substitute macro causes query error

    Posted 02/28/24 11:24 AM
    Edited by Marc Reed 02/28/24 11:29 AM

    Hi all, in 11.2.3 this macro causes a query error:

    # sq( substitute( '$\.', 'ABC', '.') ) # 

    I have to escape the '.' character otherwise there is an error about a bad search pattern. I also want to use the special $ for the end of word. It seems the combination of $ prevents any substitution of a '.'.

    Anyone have any ideas on how to replace a '.; character? Thanks



    ------------------------------
    Marc Reed
    ------------------------------



  • 2.  RE: Period/Full stop in substitute macro causes query error
    Best Answer

    Posted 02/28/24 12:30 PM

    Try 

    # sq( substitute( '\.$', 'ABC', '.test.test2.test3.') ) # 
    If you want to replace every instance you could also do:
    # sq( join('ABC',split('.', 'test0.test1.test2.test3.')) ) # 


    ------------------------------
    Paul Mendelson
    ------------------------------



  • 3.  RE: Period/Full stop in substitute macro causes query error

    Posted 02/29/24 05:22 AM

    Thanks Paul. I hadn't spotted that the $ needs to be at the end of the string.



    ------------------------------
    Marc Reed
    ------------------------------

    Original Message


Related Content