Alteryx Designer Desktop Discussions

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

How Do I get rid of the period?

Carolyne
8 - Asteroid

This is what my table currently shows:

 

Indicators
B35.1
E11.9

 

I want the table to show this:

 

Indicators
B351
E119

 

Thanks!

1 REPLY 1
itestu
Alteryx
Alteryx

Just use a formula tool with this formula : 

ReplaceChar([data], '.', null())

 

Irene

Labels