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:

       

      150000

       

      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

       

      Thanks