Special characters in a TXT data file

Denise G
Denise G New Altair Community Member
edited October 2023 in Community Q&A

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?

Tagged:

Best Answer

  • Lasse
    Lasse Altair Community Member
    edited October 2023 Answer ✓

    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

Answers

  • Lasse
    Lasse Altair Community Member
    edited October 2023 Answer ✓

    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
    CPorthouse
    Altair Employee
    edited October 2023
    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
    Denise G New Altair Community Member
    edited October 2023

    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
    Baba_Majekodunmi_703
    Altair Employee
    edited October 2023
    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.

Categories