Hi , i have this data set shown below, the data i am extracting is in feet and inches, i was able to separate the column into two keeping the feet values in one column and the inches value in another column. My problem now is to get rid of the characters in the inches column namely(\, ") without deleting the (.). I have tried the cleaning tool, when i use delete punctuation s it take out everything including the (.) which i want to keep because its a decimal value, can someone help me with what i can do, in this case. i have over 5000, records it will almost impossible to go through each row deleting the unwanted character before doing a conversion on the field.
.961\"
.961\"
.961\"
3.189\"
Solved! Go to Solution.