nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Regex

Accepted answers

messi007

@BautistaC888,

Please see below :

Attached the workflow,

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

Regards,

Repalce_20210323.yxmd

All comments

messi007

@BautistaC888,

Please see below :

Attached the workflow,

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

Regards,

Repalce_20210323.yxmd

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.

Replace Accents.jpg

Replace Accents.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703