Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Data Cleaning

razzy
8 - Asteroid

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\"

1 REPLY 1
MarqueeCrew
20 - Arcturus
20 - Arcturus
Try this please:

ReplaceChar([Field],'\"', "")

That should do the trick.

Cheers,

Mark
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Labels