community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Remove a character when it is the only character in the cell

Asteroid

Hi everyone, 

 

I cannot figure out how to do this cleaning...

 

In my row, some cells contain a single dash. And I want to remove it. 

but other cells contain also a dash with other characters. And in that case, I need to keep the dash. 

 

Example

-

RRR-1535

RRR 1242-U REUTLINGEN

RRA-NR. 19521

 

thank you for your help

Myriam

 

Alteryx Certified Partner
Alteryx Certified Partner
[Field] = '-'

Would be my bet, in this case the entire string of the field has to match.

Alternatively if there are other single characters you could do...

Length([field]) = 1

Using a filter tool in both scenarios of course.
Asteroid

thanks BenMoss !

It works fine

Labels