Special characters in a TXT data file

User: "Denise G"
Altair Community Member
Updated by 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?

Find more posts tagged with

Sort by:
1 - 4 of 41
    User: "Lasse"
    Altair Community Member
    Accepted Answer
    Updated by 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

    User: "CPorthouse"
    Altair Employee
    Updated by 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.

    User: "Denise G"
    Altair Community Member
    OP
    Updated by 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

    User: "Baba_Majekodunmi_703"
    Altair Employee
    Updated by 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.