We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Converting Latin characters

ay
6 - Meteoroid

I have Portuguese source data containing Latin characters, in Excel files.  I want to convert these to characters in the basic Latin alaphabet, so they won't cause problems downstream in reports etc.

 

Examples: PortuµRios, Manipulação, Fia€ço

 

I've experimented with ConvertfromCodePage and ConverttoCodePage but didn't manage to get this result.  Is there a way I can do this in Alteryx without creating a set of substitution rules?  Or failing that, is there a reference available I could use to achieve this?

 

Thanks

2 REPLIES 2
danrh
13 - Pulsar

There are some good ideas over here.  Take a look, see if one of these solutions works for you.

ay
6 - Meteoroid

Perfect :)

 

This hadn't come up in my searches.

Labels