Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

General Discussions

Discuss any topics that are not product-specific here.
SOLVED

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

TNShan
8 - Asteroid

Hello,

 

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

 

In my column, some cells contain a single "#". And I want to remove it. 

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

 

For example:

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

 

Your guidance in achieving this is much appreciated.

 

Thank you.

2 REPLIES 2
ShankerV
17 - Castor

Hi @TNShan 

 

Please use the below in Formula tool.

 

Column name: To

 

IF Length([From]) = 1 AND [From] = "#"
THEN Null()
ELSE [From]
ENDIF

 

Many thanks

Shanker V

TNShan
8 - Asteroid

I extend my heartfelt gratitude for your invaluable assistance. I am pleased to share that your guidance has enabled successful implementation. Thank you immensely for your support.

Labels
Top Solution Authors