Forum Discussion

RanjanThammaiah's avatar
RanjanThammaiah
Icon for Helper V rankHelper V
7 years ago
Solved

Measure column replace text

Hi All,   Can some one tell how to replace the value of Measured Column.   Below is the example.   I have created a measured column based one some formula, And there is text called "Oceania" i ...
Tips and Tricks
  • d_gosbell's avatar
    d_gosbell
    7 years ago

    Measures and columns are two different things, but if you are talking about doing this in a calculated column, then you could use the Substitute function

     

    eg

     

    SUBSTITUTE( [Column1] , "Oceania", "", 1)

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago

Measures and columns are two different things, but if you are talking about doing this in a calculated column, then you could use the Substitute function

 

eg

 

SUBSTITUTE( [Column1] , "Oceania", "", 1)

RanjanThammaiah's avatar
RanjanThammaiah
Icon for Helper V rankHelper V
7 years ago

Wonderfull.. Much appreciated.

 

Thanks