Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Replacing characters everytime they appear

BautistaC888
8 - Asteroid

Hello,

I'm trying to replace:

Every - for 0.(for example: 000123214-1401851-0413 to 0001232140140185100413)

Every character with an accent for the same character without the accent (for example: "produccióninglés" to "produccioningles")

 

I wonder if can be replaced with a Regex.
Thank you.

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@BautistaC888,

 

Please see below :

 

messi007_0-1616513401731.png

Attached the workflow,

If this solve your need please mark it as solved it will help others.

Regards,

DanielG
12 - Quasar

@BautistaC888 

 

See this solution for the accent marks  https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Converting-written-accents/td-p/470511

 

For the Regex of the dashes, this should work in RegEx tool

 

Regex.png

 

mpennington
11 - Bolide

I'm sure it isn't the most elegant solution, but you can do it with a series of RegEx replacements. Each one overwrites the previous. The hyphen to zero is straightforward.  You could probably do this with a Find Replace, as well. 

 

Replace Accents.jpg

Labels
Top Solution Authors