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

Anasitani

Hello,

I am new to Alteryx and I am trying to replace some symbols such as ä, ö, é, &, ", etc... with a, o, e, and... I stumbled across two methods, the first being the RegEx which I've noticed is only limited to one character per formula which makes the whole thing a little messy. The second formula is the find and replace, which I think could be better but I am trying to connect two separate excels instead of two sheets on the same file. My question is, is it possible to either do multiple replaces on RegEx or to link separate excel files onto a find and replace tool?

Thanks a lot

Anas

Regex

Parse

Accepted answers

grazitti_sapna

Hi @Anasitani, you can create a data mapping file and leverage that to replace the special characters in your string. Please refer to the screenshot below if that helps?

Thanks!

Anasitani_workflow.yxmd

All comments

IraWatt

@Anasitani The find and replace route is definitely better than Regex for this use case in my opinion. You can use multiple files with the find and replace tool. Do you have any example files/data?

Qiu

@Anasitani
We can always bring the seperated files into the workflow with a dynamic input tool by providing the file link.

grazitti_sapna

Hi @Anasitani, you can create a data mapping file and leverage that to replace the special characters in your string. Please refer to the screenshot below if that helps?

Thanks!

Anasitani_workflow.yxmd

binu_acs

@Anasitani one way of doing this with the DecomposeUnicodeForMatch() function

Decompose_08_06.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15905

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703