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

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

msantoso
8 - 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

 

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus
[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.
msantoso
8 - Asteroid

thanks BenMoss !

It works fine

TNShan
8 - Asteroid

Hello,

 

I'd like to inquire about a specific procedure. How can I modify characters within the data to display as empty cell instead of completely removing the data?

For example:

FromTo
# 
#12-12#12-12
#Happy#Happy

 

Your guidance in achieving this is much appreciated.

 

Thank you.

Labels