Alteryx Designer Desktop Discussions

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

remove non numeric characters from the beginning or end of a string (not the middle)

RBF
7 - Meteor

Hi!  

 

Regex question.  How can I remove non numeric characters from the beginning or end of a string (but not from the middle)?

 

e.g. before:

 

65x

2.5

si98

a99a

3-

 

I want the result to be:

65

2.5

98

99

3

 

This is important because I do not want to lose the decimals, e.g. 2.5 should not become 25

11 REPLIES 11
aatalai
13 - Pulsar

@alexnajm very true, guess data celanese and then a formula tool with replace([field],"-","") assuming that's the only puncuatuion you would want to get rid of. 

alexnajm
16 - Nebula
16 - Nebula

Agreed @aatalai!

Labels