Replacing characters everytime they appear

[BautistaC888]

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.

[messi007 · Accepted solution]

@BautistaC888,

Please see below :

Attached the workflow,

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

Regards,

[DanielG]

@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

 

[mpennington]

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.