How to remove special characters from cells and parse data in sql
I have data stored as text and am wanting to convert it to int with-in SQL. Currently the text reads (8'-6 11/16"). I am needing to remove the foot symbol ('), the dash (-), and the inches (") symbol. Then take each number (stored as text) and convert to int. At which point I would rebuild the cell to read 102 11/16". If it is possible to convert each number (stored as text) to decimal, then I could do a easy conversion and rebuild into fraction format. The SUBSTRING() command is not recognized in the "Transform" of MySQL DataFLow.