Hi D C
What you need to achieve is easily done using Datawatch Monarch, which is a tool for data preparation and data blending. You can download a free version here:
When you are done data prepping, you can export the data to a .TDE file, or csv, or Excel etc.
I have inserted a short video that shows how it is done.
Best regards, Theo Klemming, product expert, Datawatch Corporation
Datawatch is an official partner of Tableau Software
2 of 2 people found this helpful
An easier and free method would be to use a Regular Expression:
for some intro (and then more advanced videos on Calculated field, the On-Demand Training is a great starting point)....Tableau Training and Tutorials
for your question, you can use the String manipulation functions to do this (I've assumed that all your values are in this form with lbs). The formula would be
This works similar to Excel. The FIND function returns the position in the String of where it finds 'lbs' and takes all the values to the left of this (-2 for the leading space after the value), and then casts to an Integer.
Hope this helps and makes sense, but if not please post back.