Start Free Trial

Alteryx Designer Desktop Discussions

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

Add a 0 before . (period character)

Praneeth1996
8 - Asteroid

Hi team,

 

I am looking to add a "0" before period character "."

 

For some entries there is already a 0 (items highlighted in green in the attached file).

 

For items highlighted in yellow, I am looking to add a 0 as it is not existing.

 

Can we use Regex to achieve this? If yes, could you please help with the logic or the workflow.

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @Praneeth1996 

 

You can use this formula

replace([Description], ' .', ' 0.')

 

Felipe_Ribeir0_0-1669905683378.png

 

Labels
Top Solution Authors