Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

Special characters in a TXT data file

Hi,

In one of our data sets, we have the names of people that contain special characters (like: á, é, ó) and they get translated to multiple character values that skew the data in that row. For example:

Value in the .TXT file contains: László

Value when added to Monarch is: LÃ¡szlÃ³

And the fields afterwards get pushed over by 2 spaces and that record is ignored. I cannot figure out a trap that will work to include this value.

Is there a setting that can be adjusted or a way to fix this problem?

Find more posts tagged with

English

Monarch

Monarch Server

Accepted answers

Lasse

Hi Denise,

Have you tried to change the character set encoding, for example to UTF-8 encoding?

Monarch Classic: Home -> Options -> Input -> Text Files

Data Prep Studio: Settings (on Report Design view) -> Input

All comments

Lasse

Hi Denise,

Have you tried to change the character set encoding, for example to UTF-8 encoding?

Monarch Classic: Home -> Options -> Input -> Text Files

Data Prep Studio: Settings (on Report Design view) -> Input

CPorthouse

Hi Denise,

Have you tried to change the character set encoding, for example to UTF-8 encoding?

Monarch Classic: Home -> Options -> Input -> Text Files

Data Prep Studio: Settings (on Report Design view) -> Input

The default is to use ANSI encoding. Using @Lasse suggestion to change the encoding type to UTF-8 should resolve your issue.

Denise G

Hi Lasse,

I kept working on this problem after posting and found that if I saved the TXT file from UTF-8 to ANSI worked, so I was very happy. Now I just tried your suggestion and that's even better since I won't be the one using this workspace daily. I'm new to Monarch so I really appreciate your quick help, genius!

Regards, Denise

Baba_Majekodunmi_703

Hi Lasse,

I kept working on this problem after posting and found that if I saved the TXT file from UTF-8 to ANSI worked, so I was very happy. Now I just tried your suggestion and that's even better since I won't be the one using this workspace daily. I'm new to Monarch so I really appreciate your quick help, genius!

Regards, Denise

Hi Denise,

Are you working with reports from Ellucian Banner or Colleague? Or another ERP system?

We're building a library of pre-built templates for those systems and others in our Monarch Model Library.

If you don't see a system you work with on that list let us know and we'll add it to the list.