Forum Discussion

dbernabefdez's avatar
dbernabefdez
Frequent Visitor
3 years ago
Solved

How to replace text in Bulk for Calculated Columns -- Tabular Editor

Hi Community   I´ve found this script to change in bulk measures using Tabular Editor: var FromString = "Text1"; var ToString = "Text2"; foreach(var c in Selected.Measures) { c.Expression = ...
Need Help
  • LQuedas's avatar
    LQuedas
    3 years ago

    Hey dbernabefdez 

     

    After looking at the documentation and doing an example you should try the following code

     

    var FromString = "Text1";
    var ToString = "Text2";

    foreach(var c in Selected.CalculatedColumns)
    {
    c.Expression = c.Expression.Replace(FromString,ToString);
    /* Cycle over all measures in model and replaces the
    FromString with the ToString */
    }

     

    Hope it works for you.

     

    Cheers, LQ

     

     

     

LQuedas's avatar
LQuedas
Resolver II
3 years ago

Hey dbernabefdez 

 

After looking at the documentation and doing an example you should try the following code

 

var FromString = "Text1";
var ToString = "Text2";

foreach(var c in Selected.CalculatedColumns)
{
c.Expression = c.Expression.Replace(FromString,ToString);
/* Cycle over all measures in model and replaces the
FromString with the ToString */
}

 

Hope it works for you.

 

Cheers, LQ

 

 

 

  • dbernabefdez's avatar
    dbernabefdez
    Frequent Visitor
    3 years ago

    WOUU incredible!!!! Works great

     

    I was making the mistake of using ""foreach(var c in Selected.Columns)"" instead of ""foreach(var c in Selected.CalculatedColumns)""

     

    Thank you so much for your help