I have a dataset with values of D15 (mm), D35 (mm), D50 (mm), D84 (mm), D95 (mm), & D100 (mm). I want to use stringreplacer to remove the letter "D" and "(mm)". Syntax to remove?
Best answer by debbiatsafe
Hi @jencinas
Try using the following Regex in the StringReplacer (Replace Regular Expression mode):
\DThis expression will identify any single character that is not a digit. Leave the Replacement Text parameter empty.
I hope this helps.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+21- Safer
- Best Answer
Hi @jencinas
Try using the following Regex in the StringReplacer (Replace Regular Expression mode):
\DThis expression will identify any single character that is not a digit. Leave the Replacement Text parameter empty.
I hope this helps.
Hi @jencinas
Try using the following Regex in the StringReplacer (Replace Regular Expression mode):
\DThis expression will identify any single character that is not a digit. Leave the Replacement Text parameter empty.
I hope this helps.
That was the solution! Thank you! I was able to use this suggestion and get the numbers by themselves. I wanted to sort those numbers and this allowed me to do so. Then, I used String Concatenator to add them back to the sorted numbers. I appreciate your help! 🙂