4 Replies Latest reply on Feb 17, 2016 8:14 AM by Simon Runc

    Calculated field to turn this string into number?

    D C

      Hi, I would like to turn a field (currently data type = string) that looks like this:


      150,000 lbs. (68kg)

      Into a number:




      So I would like to get rid of everything after the first number


      Could someone advise on how to do this?


      Also, I would be interested to see a tutorial on how to write formulas for Tableau calculated fields... haven't been able to find one yet