Special characters in a TXT data file

Denise G

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?

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

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

Lasse said:

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

Denise G said:

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.