1 Reply Latest reply on Jul 23, 2012 10:53 AM by Tracy Rodgers

    Modifying/Manipulating  Data

      Hi!

      i have a dimension that has data like:

      ABC 11.1 XC

      1-0-3

       

      I want to cleanse the data and do some replacements:

      eg: for the 1st value i need to strip out AAA and AA to get 11.1 instead pf AAA 11.1 XC

      for the 2nd value i need the - replaced by . eg 1.0.3 instead of 1-0-3

       

      how can this be acheived in tableau. i tried to use replace function and it does not work.

        • 1. Re: Modifying/Manipulating  Data
          Tracy Rodgers

          Hi Girija,

           

          Are both of these values in the same dimension?

           

          To get the first example, a calculated field can be created similar to the following:

           

          mid([Dimension], find([Dimension], "11.1"), 4)

           

          For the second example, the replace function can be used (however, note that it cannot be used with Microsoft JET--to get around this, create an extract).

           

          Hope this helps!

           

          -Tracy